I saw this question has been asked a couple times with no answer.
Once here:
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...
I saw another request elsewhere but can't find it now.
So, I did some experimenting using the APOI Example here:
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...
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:
It shows that
3 = Blank
5 = Error