我想使用Apache POI在Android中读写excel文件(包括xlsx和xls)。但是我不能解决我目前所遇到的依赖问题。
如果gradle文件中只有这两个依赖项
compile files('libs/poi-3.12-20150511.jar')
compile files('libs/poi-ooxml-3.12-20150511.jar')
然后我得到以下错误:
java.lang.NoClassDefFoundError: Failed resolution of: Lorg/apache/xmlbeans/XmlOptions;
at org.apache.poi.POIXMLDocumentPart.(POIXMLDocumentPart.java:59)
at com.gargzdai.spreadsheet.MainActivity.readData(MainActivity.java:131)
at com.gargzdai.spreadsheet.MainActivity.prepareForReadingData(MainActivity.java:109)
at com.gargzdai.spreadsheet.MainActivity.onCreate(MainActivity.java:68)
at android.app.Activity.performCreate(Activity.java:5990)
at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1106)
at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2278)
at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2387)
at android.app.ActivityThread.access$800(ActivityThread.java:151)
at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1303)
at android.os.Handler.dispatchMessage(Handler.java:102)
at android.os.Looper.loop(Looper.java:135)
at android.app.ActivityThread.main(ActivityThread.java:5254)
at java.lang.reflect.Method.invoke(Native Method)
at java.lang.reflect.Method.invoke(Method.java:372)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:903)
这是我用来读取excel文件的代码:
if (isXlsxFile)
myWorkbook = new XSSFWorkbook(OPCPackage.open(file));
else
myWorkbook = new HSSFWorkbook(fileStream);
Sheet mySheet = myWorkbook.getSheetAt(0);
Iterator rowIterator = mySheet.rowIterator();
似乎我应该添加xmlbeans库。将此依赖项添加到gradle文件后:
compile files('libs/xmlbeans-2.6.0.jar')
在我添加了这个依赖之后,我在gradle构建过程中得到了以下错误:
Error:Execution failed for task ':app:preDexDebug'.
> com.android.ide.common.process.ProcessException: org.gradle.process.internal.ExecException: Process 'command 'C:\Program Files\Java\jdk1.8.0_40\bin\java.exe'' finished with non-zero exit value 1
关于我应该如何处理这个问题,有什么想法吗?
发布于 2016-06-01 18:12:34
我也面临着同样的问题。poi:poi-ooxml在末尾引用stax:stax-api,它包含核心包javax.xml。*。编译器(或predexer或在android studio中的其他名称)会中止编译,并显示一条长警告。有三种方法可以解决这个问题:
希望这能有所帮助!
发布于 2018-07-30 04:47:24
这对我很有效:
dependencies { implementation 'org.apache.poi:poi:3.12' implementation 'org.apache.poi:poi-ooxml:3.12' implementation 'com.fasterxml:aalto-xml:1.0.0'}
发布于 2021-02-26 12:01:08
只需在build.gradle模块文件中添加这两个依赖项
implementation group: 'org.apache.poi', name: 'poi-ooxml', version: '4.1.2'
implementation 'javax.xml.stream:stax-api:1.0'
https://stackoverflow.com/questions/30578750
复制相似问题