尝试读取 .xlsx excel 文件时出现 java.lang.NoSuchMethodError

Question

你好，我尝试使用 Spring Boot 读取 XLSX 文件，但出现错误我的 Controller :

@PostMapping("/upload")
public ResponseEntity<?> addRfp  (@RequestParam("file") MultipartFile file) throws IOException, InvalidFormatException  {
    ZipSecureFile.setMinInflateRatio(0);  
    InputStream inputStream = file.getInputStream();
    String originalName = file.getOriginalFilename();
    String name = file.getName();
    String contentType = file.getContentType();
    long size = file.getSize();
    FileInputStream fis =  (FileInputStream) file.getInputStream();
    XSSFWorkbook myWorkBook = new XSSFWorkbook (fis);
    XSSFSheet mySheet = myWorkBook.getSheetAt(0);
    Iterator<Row> rowIterator = mySheet.iterator();
    while (rowIterator.hasNext()) {
        Row row = rowIterator.next();
        Iterator<Cell> cellIterator = row.cellIterator();
        while (cellIterator.hasNext()) {
            Cell cell = cellIterator.next();
            switch (cell.getCellType())
            { case STRING:
                System.out.print(cell.getStringCellValue() + "\t"); break; 
                case NUMERIC: System.out.print(cell.getNumericCellValue() + "\t"); break;
                case BOOLEAN: System.out.print(cell.getBooleanCellValue() + "\t"); break; 
                default : } } 
        System.out.println(""); }
return null;

}

错误是:

java.lang.NoSuchMethodError: org.apache.xmlbeans.XmlOptions.setEntityExpansionLimit(I)Lorg/apache/xmlbeans/XmlOptions;
    at org.apache.poi.ooxml.POIXMLTypeLoader.<clinit>(POIXMLTypeLoader.java:43) ~[poi-ooxml-4.1.2.jar:4.1.2]
    at org.apache.poi.xssf.model.SharedStringsTable.readFrom(SharedStringsTable.java:123) ~[poi-ooxml-4.1.2.jar:4.1.2]
    at org.apache.poi.xssf.model.SharedStringsTable.<init>(SharedStringsTable.java:111) ~[poi-ooxml-4.1.2.jar:4.1.2]
    at org.apache.poi.ooxml.POIXMLFactory.createDocumentPart(POIXMLFactory.java:61) ~[poi-ooxml-4.1.2.jar:4.1.2]
    at org.apache.poi.ooxml.POIXMLDocumentPart.read(POIXMLDocumentPart.java:684) ~[poi-ooxml-4.1.2.jar:4.1.2]
    at org.apache.poi.ooxml.POIXMLDocument.load(POIXMLDocument.java:180) ~[poi-ooxml-4.1.2.jar:4.1.2]

请问我应该怎么做才能解决这个问题，我现在已经被阻止了有人可以帮我解决这个问题吗？

谢谢，阿米

Answer 1

一切看起来都很好，请尝试更新项目，因为库似乎未正确加载。右键单击项目并进行 Maven 更新即可转到 Maven。选中永久更新框，它应该可以工作