用java阅读Excel表时的NoSuchFieldError

Question

try {
    FileInputStream file = new FileInputStream(new File("howtodoinjava_demo.xlsx"));

    // Create Workbook instance holding reference to .xlsx file
    XSSFWorkbook workbook = new XSSFWorkbook(file);

    // Get first/desired sheet from the workbook
    XSSFSheet sheet = workbook.getSheetAt(0);

    // Iterate through each rows one by one
    Iterator<Row> rowIterator = sheet.iterator();
    while (rowIterator.hasNext()) {
        Row row = rowIterator.next();
        // For each row, iterate through all the columns
        Iterator<Cell> cellIterator = row.cellIterator();

        while (cellIterator.hasNext()) {
            Cell cell = cellIterator.next();
            // Check the cell type and format accordingly
            switch (cell.getCellType()) {
            case Cell.CELL_TYPE_NUMERIC:
                System.out.print(cell.getNumericCellValue() + "t");
                break;
            case Cell.CELL_TYPE_STRING:
                System.out.print(cell.getStringCellValue() + "t");
                break;
            }
        }
        System.out.println("");
    }
    file.close();
} catch (Exception e) {
    e.printStackTrace();
}

线程“main”java.lang.nosuchfielderror:RAW_XML_FILE_HEADER位于org.apache.poi.openxml4j.opc.internal.ziphelper.verifyzipheader(ziphelper.java:179)位于org.apache.poi.openxml4j.opc.internal.ziphelper.openzipstream(ziphelper.java:228)位于org.apache.poi.openxml4j.opc.zippackage。.在org.apache.poi.xssf.usermodel.xssfworkbook.(xssfworkbook.java:273)在com.wtolliver.spring.test.readexcel.readexcel(readexcel.java:18)在com.wtolliver.spring.test.app.main(app.java:17)

Answer 1

环顾四周后。我浏览了APACHE POI的文档，看到这是常量之一（我不知道这是什么意思）。

但最终，我意识到我使用的所有教程都是2014年之前的。

因此，为了实现apache-poi和poi-ooxml的依赖关系，我将Maven POM更改为3.11版本。