B4J Question B4J unable to initialize WorkSheet

[rossati]

Hi
I'm trying to use jExcel, but the last instruction

        Dim Workbook As WritableWorkbook
        Log(fh_Data.Get("ExcelFile"))
        Workbook.Initialize("C:\Users\User\Desktop\", "porkon.xls")

gets this error:

java.lang.NoSuchMethodError: anywheresoftware.b4a.objects.streams.File.getDirInternalCache()Ljava/lang/String;

Thanks

 

[amykonio]

Hi.

Can you replace the following:

        Dim Workbook As WritableWorkbook
        Workbook.Initialize("C:\Users\User\Desktop\", "porkon.xls")

Thanks

with:

        Dim Workbook As WritableWorkbook
        Workbook.Initialize("C:\Users\User\Desktop", "porkon.xls")

Also, is there a reason you prefer to work with jExcel instead of jPoi?

Andreas.

 

[rossati]

Thanks Andreas

Also with your suggestions dosn't works. Searching in the net it seems there is a problem of old and new library.
The use of jExcel is random, I can try co jPoi.

John

 

[Erel]

Are you sure that you are not using the B4A library? The correct one is here: https://www.b4x.com/android/forum/threads/jexcel-library.35004/

Though you should use jPOI instead anyway.

 

[rossati]

Thanks Erel
Now I use jPoi although is heavy for my purpose.
I anticipate you that I'm going to start a new post on what seems to me an error in the management of the combo box events (B4J),
regards