Import excel (.xlsx) file data in android

Question

I have a problem regarding Excel(.xlsx) file import in Android SQLite database, I am using Poi jar file but finding following Runtime error.

• java.lang.VerifyError: org/apache/poi/xssf/usermodel/XSSFWorkbook

How can i resolve this problem ? please help me.

Answer 1

If you are using maven try the following

<!-- http://mvnrepository.com/artifact/org.apache.poi/poi-ooxml -->
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>3.14</version>
</dependency>

if not just download the jar file and add in your built path.

Answer 2

Java on Android has some intricacies which require some more work due to duplicate classes in some jars, the number of methods that POI has and some javax.* code that is included via transitive dependencies.

There are multiple approaches that were used by others over time:

• Recently I prepared a sample at https://github.com/centic9/poi-on-android/ which allows to build a combined jar-file which includes everything needed for Apache POI in a way that also works on Android
• The project at https://github.com/andruhon/android5xlsx tries to provide ready-made jar-files that are patched and adjusted to work on Android
• Previously for Android versions below 5, https://github.com/andruhon/AndroidReadXLSX did provide a slightly approach, still with ready-made jar-files being provided

Please try to use one of those and report back if you succeed. The first one is a rather new approach, but it would allow to re-package newer versions of Apache POI rather quickly compared to the other two which are a few versions behind already.