Android Question aPOI celltypes [SOLVED]

[Tim Chapman]

In the exmaple for aPOI that you can download here:

aPOI - A wrapper for jPOI for Android - reading and writing XLS, XLSX on Android 5+

This is a wrap for this Github project which is itself a wrap for jPOI. Reading and Writing XLSX on Android 5 Reading and Writing XLSX and XLS on Android 5 with Apache POI It was quite a challenging task to use Apache POI on android with Dalvik VM. It is much easier to use Apache POI on...

www.b4x.com

The celltype shows in the log. Type 0 and 1 show.

In the jPOI library (https://www.b4x.com/b4j/help/jpoi.html#poicell_type_boolean) there are cell TYPE_BOOLEAN As Object, etc.

Is there any equivalent in aPOI? How do I find out what the celltypes are? I have found this same issue on a couple things in B4A. The other was notification importance. I can't find anywhere that says what they are. Only that they are integer values. Any tips?

Thank you all.

 

[Tim Chapman]

I saw this question has been asked a couple times with no answer.
Once here:

aPOI - A wrapper for jPOI for Android - reading and writing XLS, XLSX on Android 5+

This is a wrap for this Github project which is itself a wrap for jPOI. Reading and Writing XLSX on Android 5 Reading and Writing XLSX and XLS on Android 5 with Apache POI It was quite a challenging task to use Apache POI on android with Dalvik VM. It is much easier to use Apache POI on...

www.b4x.com

I saw another request elsewhere but can't find it now.

So, I did some experimenting using the APOI Example here:

aPOI - A wrapper for jPOI for Android - reading and writing XLS, XLSX on Android 5+

This is a wrap for this Github project which is itself a wrap for jPOI. Reading and Writing XLSX on Android 5 Reading and Writing XLSX and XLS on Android 5 with Apache POI It was quite a challenging task to use Apache POI on android with Dalvik VM. It is much easier to use Apache POI on...

www.b4x.com

I found the following celltypes:
0 = Numeric
1 = String
2 = Formula
4 = Boolean

Could not figure out 3 or others. Dug more on the web and found the following:

Cell (POI API Documentation)

It shows that
3 = Blank
5 = Error