Android Question aPOI (jPOI for Android) with ProgressDialog

Revisable5987 · Feb 23, 2020

I have an app that will compile an xlsx file.
The process of creating and saving the file takes about 20 seconds.

Currently I am trying to implement a Progress Dialog so the end user can see something is happening.
I hoped it would be something as simple as adding

B4X:

ProgressDialogShow2("Please Wait", False)

before the aPOI code.

Unfortunately the ProgressDialog only starts after the xlsx file has finished saving, and so only shows for a second.
What would be the best way to implement the Dialog so it starts when the user clicks save and finishes once the file is saved?

I have attached a small sample of the aPOI code.

B4X:

        Dim row As XSSFRow = sheet.getRow(41)
        Dim Cell As XSSFCell = row.getCell(2)
        Cell.StringCellValue = ACEditText1.Text
        
        Dim row As XSSFRow = sheet.getRow(42)
        Dim Cell As XSSFCell = row.getCell(5)
        Cell.StringCellValue = DateText.Text
        
        
        
        
        Starter.rp.CheckAndRequest(Starter.rp.PERMISSION_WRITE_EXTERNAL_STORAGE)
        wait for Activity_PermissionResult (Permission As String, Result As Boolean)
        If Result Then
        
            Dim outstream As OutputStream = File.OpenOutput(File.DirRootExternal, "Vehicle Checks Completed.xlsx", False)
            xls.write(outstream)
            outstream.close

Erel · Feb 24, 2020

The problem is that xls.Write is a blocking method. It will hold the main thread until it completes and you will not be able to show any UI. It can also cause the app to crash with the ANR dialog.

The best solution is to update the library and add an async version using BA,runAsync: https://www.b4x.com/android/forum/threads/java-libraries-and-multithreading.12697/post-204943

Revisable5987 · Feb 26, 2020

Erel said:
The problem is that xls.Write is a blocking method. It will hold the main thread until it completes and you will not be able to show any UI. It can also cause the app to crash with the ANR dialog.

The best solution is to update the library and add an async version using BA,runAsync: https://www.b4x.com/android/forum/threads/java-libraries-and-multithreading.12697/post-204943

Okay thanks.

I think libraries are possibly beyond my understanding currently, I'll have to start learning and hope DonManfred updates his library first ?

DonManfred · Feb 27, 2020

I see. I´ll investigate

DonManfred · Feb 28, 2020

kgcarpenter said:
I'll have to start learning and hope DonManfred updates his library first

Try it with this Version.

B4X:

    Starter.rp.CheckAndRequest(Starter.rp.PERMISSION_WRITE_EXTERNAL_STORAGE)
    wait for Activity_PermissionResult (Permission As String, Result As Boolean)
    If Result Then
        xls.write2(File.DirRootExternal,"excelout.xlsx")
    End If

B4X:

Sub XLS_written(success As Boolean, Info As String)
    Log($"XLS_written(${success}, ${Info})"$)
End Sub

Revisable5987 · Feb 29, 2020

DonManfred said:
Try it with this Version.

This writes the file without blocking, however the sub xls_written is never triggered.

DonManfred · Mar 1, 2020

kgcarpenter said:
however the sub xls_written is never triggered.

It depends on the event-prefix you set when initializing.

Change it from "" to "xls"

B4X:

    xls.Initialize("XLS",File.Combine(File.DirInternal,"qqq.xlsx"))

Revisable5987 · Mar 1, 2020

DonManfred said:
Change it from "" to "xls"

Of course!
I was thinking the sub needed to match the value I declared "xls As XSSFWorkbook"
Didn't occur to me to check the prefix I set and use that ?

Working like a charm now, much appreciated.

Android Question aPOI (jPOI for Android) with ProgressDialog

Revisable5987

Member

Erel

B4X founder

Revisable5987

Member

DonManfred

Expert

DonManfred

Expert

Attachments

Revisable5987

Member

DonManfred

Expert

Revisable5987

Member

Similar Threads

Android Question aPOI (jPOI for Android) with ProgressDialog

Member

B4X founder

Member

Expert

Expert

Attachments

Member

Expert

Member

Similar Threads

Privacy & Transparency

Privacy & Transparency