使用apache poi读取excel xlsx文件时发生NoSuchMethodError（初始化失败

Question

我尝试应用Apache POI，但失败了。我一直在四处寻找解决办法，但还是解决不了问题。不确定是java版本不兼容还是缺少jar文件。我需要专业人士的指导。

system.out之后的当前版本:1.6.0system.out.println(Runtime.Class.GetPackage().GetImplementationVersion())；

添加的外部Jar文件:
-dom4j-1.6.1.Jar
-log4j-1.2.17.Jar
-junit-4.11.Jar
-poi-3.11-20141211.Jar
-poi-ooxml-3.11-20141211.Jar
-poi-ooxml-schemas-3.11-20141211.Jar
-xmlbeans-2.6.0.Jar

//jsp is my front end system

<jsp:useBean id="ReadXLSXFile" scope="page" class="com.home.file.ReadXLSXFile" />
<script>
    if(sType.equals("Y"))
    {
      ReadXLSXFile.main(null);
    }
</script>

package com.home.file;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.util.Iterator;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class ReadXLSXFile {

public static void main(String[] args) {

    try {
        File excel = new File("C:/Banklist.xlsx");
        FileInputStream fis = new FileInputStream(excel);
        XSSFWorkbook book = new XSSFWorkbook(fis);
        XSSFSheet sheet = book.getSheetAt(0);

        Iterator<Row> itr = sheet.iterator();

        // Iterating over Excel file in Java
        while (itr.hasNext()) {
            Row row = itr.next();

            // Iterating over each column of Excel file
            Iterator<Cell> cellIterator = row.cellIterator();
            while (cellIterator.hasNext()) {

                Cell cell = cellIterator.next();

                switch (cell.getCellType()) {
                case Cell.CELL_TYPE_STRING:
                    System.err.print(cell.getStringCellValue() + "\t");
                    break;
                case Cell.CELL_TYPE_NUMERIC:
                    System.err.print(cell.getNumericCellValue() + "\t");
                    break;
                case Cell.CELL_TYPE_BOOLEAN:
                    System.err.print(cell.getBooleanCellValue() + "\t");
                    break;
                default:

                }
            }
            System.err.println("");
        }

    } catch (FileNotFoundException fe) {
        fe.printStackTrace();
    } catch (IOException ie) {
        ie.printStackTrace();
    }
}
}

Eclipse控制台结果：

Caused by: java.lang.NoClassDefFoundError: org.apache.poi.openxml4j.opc.internal.marshallers.ZipPackagePropertiesMarshaller (initialization failure)
at java.lang.J9VMInternals.initialize(J9VMInternals.java:140)
at org.apache.poi.openxml4j.opc.OPCPackage.init(OPCPackage.java:161)
at org.apache.poi.openxml4j.opc.OPCPackage.<init>(OPCPackage.java:141)
at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:87)
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:272)
at org.apache.poi.util.PackageHelper.open(PackageHelper.java:37)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:258)
at com.rexit.easc.ReadXLSXFile.main(ReadXLSXFile.java:26)
at com.ibm._jsp._pop_5F_cnFW_5F_nstbl._jspService(_pop_5F_cnFW_5F_nstbl.java:500)

P/S：这个问题和这个线程很相似，但我还是想不通。这里

Answer 1

poi-3.11-20141211.jar中缺少org.apache.poi.openxml4j.opc.internal.marshallers.ZipPackagePropertiesMarshaller。
首先，您可以检查ZipPackagePropertiesMarshaller类是否在此JAR中。
如果没有，则可能是您的POI-3.11-20141211.jar无效或ZipPackagePropertiesMarshaller不支持POI-3.11-20141211.jar。

I would recommend you to change poi-ooxml-3.11-20141211.jar to poi-ooxml-3.9-20121203.jar.