如何解决ApachePOI中的InvocationTargetException

Question

我试图读取xlsx格式的excel文件。但是我得到的结果太大，无效的句柄异常。我把文件实例在一个FileInputStream对象，并试图在XSSFWorkbook中设置该对象。但是我得到了这个例外。

我工作的环境中没有安装Microsoft office，并且有开放式office。我没有在open office中编辑我的xlsx文件。但我在open office中打开了文件，然后尝试运行poi代码。是否因此发生了任何问题？

我给我的代码片段和下面的例外也罐我正在使用

commons-codec-1.10
commons-collections4-4.1
commons-io-2.5
commons-logging-1.2
curvesapi-1.04
ooxml-schemas-1.0
poi-3.17
poi-excelant-3.17
poi-ooxml-3.17
xmlbeans-2.3.0

这是代码从哪里我得到一个异常，

 private void openWorkbook(String fileName) throws IOException {
    FileInputStream excelFile = new FileInputStream(new File(fileName));
    try {

        this.setWorkbook(new XSSFWorkbook(excelFile)); // here the exception is coccuring
    } catch (Exception e) {
        e.printStackTrace();
    }finally{
        excelFile.close();
    }
}

我相信setWorkBook方法不能处理工作簿的大小。

我得到的例外是

org.apache.poi.POIXMLException: java.lang.reflect.InvocationTargetException
at org.apache.poi.POIXMLFactory.createDocumentPart(POIXMLFactory.java:63)
at org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:580)
at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:165)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:300)
at com.test.ExcelManager.openWorkbook(ExcelManager.java:26)
at com.test.ExcelManager.<init>(ExcelManager.java:18)
at com.test.ActivityLauncher.main(ActivityLauncher.java:87)
 Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:56)
at org.apache.poi.POIXMLFactory.createDocumentPart(POIXMLFactory.java:60)
... 6 more
 Caused by: java.lang.NoSuchMethodError: org.openxmlformats.schemas.spreadsheetml.x2006.main.CTTableStyle.getTableStyleElementList()Ljava/util/List;
at org.apache.poi.xssf.usermodel.XSSFTableStyle.<init>(XSSFTableStyle.java:87)
at org.apache.poi.xssf.model.StylesTable.readFrom(StylesTable.java:247)
at org.apache.poi.xssf.model.StylesTable.<init>(StylesTable.java:141)
... 12 more
Exception in thread "main" java.lang.NullPointerException
at com.test.ExcelManager.<init>(ExcelManager.java:19)
at com.test.ActivityLauncher.main(ActivityLauncher.java:87)

请帮忙。

Answer 1

您可以在这里尝试centic的解决方案，特别是带有POI流式API的部分