java.lang.ClassNotFoundException: org.apache.poi.xssf.usermodel.XSSFWorkbook
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/26992908/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
java.lang.ClassNotFoundException: org.apache.poi.xssf.usermodel.XSSFWorkbook
提问by rajasekhar
when i tried to create a workbook in normal java class it is creating but when i tried to run the same on servlet it is throwing exceptions
当我尝试在普通 Java 类中创建工作簿时，它正在创建，但是当我尝试在 servlet 上运行相同的工作簿时，它抛出异常
Normal java class
普通java类
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class Sampleclass {
public static void main(String[] args) {
FileInputStream file;
try {
file = new FileInputStream(new File("C:\Users\Rajasekhar\Desktop\EmployeeDetails.xlsx"));
Workbook book=new XSSFWorkbook(file);
System.out.println(book);
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
Servlet
小服务程序
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
@SuppressWarnings("serial")
public class sampleServlet extends HttpServlet {
@Override
public void doGet(HttpServletRequest req, HttpServletResponse resp)
{
FileInputStream file;
try {
file = new FileInputStream(new File("C:\Users\Rajasekhar\Desktop\EmployeeDetails.xlsx"));
Workbook book=new XSSFWorkbook(file);
} catch (FileNotFoundException e) {
System.out.println("exception occured is "+e);
e.printStackTrace();
} catch (IOException e) {
System.out.println("exception occured is "+e);
e.printStackTrace();
}
}
}
the exception occured was
发生的异常是
SEVERE: Servlet.service() for servlet [upload] in context with path [/Temp2] threw exception [Servlet execution threw an exception] with root cause
java.lang.ClassNotFoundException: org.apache.poi.xssf.usermodel.XSSFWorkbook
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1718)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1569)
at sampleServlet.doGet(sampleServlet.java:23)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:620)
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:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
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:315)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
I have added all required apache poi jars.
我已经添加了所有必需的 apache poi 罐子。
回答by Jens
Download poi-ooxml.jarand add it to your classspath.
下载poi-ooxml.jar并将其添加到您的类路径中。
回答by soha samy
i know this may be late but the problem was that you may ignore the file xmlbeans-2.6.0.jarwhich is in separate file from other apache jar (ooxml-lib)
我知道这可能晚了，但问题是您可能会忽略与xmlbeans-2.6.0.jar其他 apache jar (ooxml-lib) 不同的文件中的文件
回答by Edgard Leal
You need the file poi-ooxml.jarin your classpath as @Jenssaid.
poi-ooxml.jar正如@Jens所说，您需要类路径中的文件。
You are using the correct importstatement but it seems that you don't have the file poi-ooxml.jarin the class path of your web container.
您使用的是正确的import语句，但poi-ooxml.jar您的 Web 容器的类路径中似乎没有该文件。
If you are using maven, you should put this dependency in your pom.xmlinside the <dependencies>tag:
如果你使用maven，你应该把这个依赖放在你pom.xml的<dependencies>标签里面：
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.15</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.15</version>
</dependency>
