java - Apache POI ClassNotFoundException 异常

Question

我正在使用 eclipse 尝试从 excel 电子表格中获取工作表列表，但是当我运行它时，Java 会抛出异常。

这是代码；

File myFile = new File("excel.xlsx");
    Workbook wb = null;
    try {
        wb = WorkbookFactory.create(myFile);
    } catch (EncryptedDocumentException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    } catch (InvalidFormatException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    } catch (IOException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }

    List<String> sheetNames = new ArrayList<String>();
    for (int i=0; i<wb.getNumberOfSheets(); i++) {
        sheetNames.add( wb.getSheetName(i) );
    }
    System.out.println(sheetNames);

这是日志；

Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/xmlbeans/XmlObject
    at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:293)
    at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:252)
    at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:231)
    at com.cogentautomation.view.View.main(View.java:19)
Caused by: java.lang.ClassNotFoundException: org.apache.xmlbeans.XmlObject
    at java.net.URLClassLoader.findClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    ... 4 more

我已将以下内容作为库包含在 eclipse java 构建路径中；

• 公共(public)编解码器
• 公共(public)日志
• 联合
• log4j
• 兴趣点
• poi-ooxml
• poi-scratchpad

我知道解决方案很简单，但我的脑子一片空白。我没有使用行家。

Answer 1

您将需要添加 XMLBeans 依赖项。您可以从这里添加依赖项 https://mvnrepository.com/artifact/org.apache.xmlbeans/xmlbeans/2.6.0