java.lang.ClassNotFoundException: org.apache.xmlbeans.XmlOptions [英] java.lang.ClassNotFoundException: org.apache.xmlbeans.XmlOptions

问题描述

我正在尝试在 servlet 中使用 POI 将上传的文件处理为 Excel 文件:

I am trying to use POI in a servlet to process an uploaded file as Excel file:

public static String readExcel(InputStream inp) {
    // InputStream inp = null;
    StringBuilder excelDataBuilder = new StringBuilder();
    try {
        Workbook wb = WorkbookFactory.create(inp);
        Sheet sheet = wb.getSheetAt(0);
        Header header = sheet.getHeader();

        int rowsCount = sheet.getLastRowNum();
        for (int rowCounter = 0; rowCounter <= rowsCount; rowCounter++) {
            Row row = sheet.getRow(rowCounter);
            int colCounts = row.getLastCellNum();
            for (int colCounter = 0; colCounter < colCounts; colCounter++) {
                Cell cell = row.getCell(colCounter);
                excelDataBuilder.append(cell.getStringCellValue());
                if (colCounter < colCounts)
                    excelDataBuilder.append(",");
            }
            if (rowCounter <= rowsCount) {
                excelDataBuilder.append("\n");
            }
        }
        return excelDataBuilder.toString();

    } catch (Exception ex) {
        LOG.error("Exception", ex);
    } finally {
        try {
            inp.close();
        } catch (IOException ex) {
            LOG.error("IOException", ex);
        }
    }
    return excelDataBuilder.toString();
}

但是，它在以下行抛出异常:

However, it threw an exception at the following line:

Workbook wb = WorkbookFactory.create(inp);

这是堆栈跟踪:

SEVERE: Servlet.service() for servlet [com.bhrt93.excel.servlet.UploadProcessExcel] in context with path [/ExcelServletProcessCommons] threw exception [Servlet execution threw an exception] with root cause
java.lang.ClassNotFoundException: org.apache.xmlbeans.XmlOptions
    at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1720)
    at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1571)
    at org.apache.poi.POIXMLDocumentPart.<clinit>(POIXMLDocumentPart.java:59)
    at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:78)
    at com.bhrt93.excel.service.ExcelReaderService.readExcel(ExcelReaderService.java:22)
    at com.bhrt93.excel.servlet.UploadProcessExcel.doPost(UploadProcessExcel.java:69)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.lang.Thread.run(Unknown Source)

这是怎么引起的，我该如何解决?

How is this caused and how can I solve it?

推荐答案

详见 Apache POI关于组件及其依赖项的页面...

如果您想使用通用 SS 代码，例如 WorkbookFactory，则您的类路径中需要 poi 和 poi-ooxml POI jar.此外，您还需要它们的依赖项.列出的依赖项 之一是 xmlbeans，顺便提一下您缺少的课程来自

If you want to use Common SS code, such as WorkbookFactory, you need both the poi and poi-ooxml POI jars on your classpath. In addition, you also need their dependencies too. One of the listed dependencies is xmlbeans, which incidentally is where your missing class comes from

因此，您只需要查看组件和依赖项页面，然后确保您在类路径中包含来自 Apache POI 二进制包的适当 jar.(或者使用 Maven，让它为你担心)

So, you just need to review the Components and Dependencies page, then make sure you include the appropriate jars from the binary package of Apache POI on your classpath. (Or use Maven and let it worry about that for you)

这篇关于java.lang.ClassNotFoundException: org.apache.xmlbeans.XmlOptions的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！