B4J Question B4J unable to initialize WorkSheet

rossati · Nov 23, 2018

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

B4X:

        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 · Nov 23, 2018

Hi.

Can you replace the following:

rossati said:

B4X:

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

Thanks

with:

B4X:

        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 · Nov 24, 2018

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 · Nov 25, 2018

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 · Nov 25, 2018

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

B4J Question B4J unable to initialize WorkSheet

rossati

Active Member

amykonio

Active Member

rossati

Active Member

Erel

B4X founder

rossati

Active Member

Similar Threads

B4J Question B4J unable to initialize WorkSheet

rossati

Active Member

amykonio

Active Member

rossati

Active Member

Erel

B4X founder

rossati

Active Member

Similar Threads

Privacy & Transparency

Privacy & Transparency