java.lang.NoClassDefFoundError: org/apache/poi/hssf/usermodel/HSSFWorkbook

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/6464919/
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

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-10-30 15:58:57  来源:igfitidea点击:

java.lang.NoClassDefFoundError: org/apache/poi/hssf/usermodel/HSSFWorkbook

javamavenclasspathapache-poinoclassdeffounderror

提问by link

java.lang.NoClassDefFoundError:org/apache/poi/hssf/usermodel/HSSFWorkbook

This is java web project. The java project is ok, but in web, I got this exception.

这是java web 项目。java 项目没问题,但是在 web 中,我遇到了这个异常。

Caused by: java.lang.ClassNotFoundException: org.apache.poi.hssf.usermodel.HSSFWorkbook
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1680)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1526)

maven dependency :

Maven 依赖:

<!-- apahce poi -->
    <dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi</artifactId>
        <version>3.7</version>
    </dependency>
    <dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi-scratchpad</artifactId>
        <version>3.7</version>
    </dependency>
    <dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi-ooxml</artifactId>
        <version>3.7</version>
    </dependency>
    <dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi-ooxml-schemas</artifactId>
        <version>3.7</version>
    </dependency>

回答by Mathias Schwarz

You need to put the Apache POI files in the WEB-INF/lib folder on the server.

您需要将 Apache POI 文件放在服务器上的 WEB-INF/lib 文件夹中。

回答by Sergii Zagriichuk

Check .m2directory and try to find class HSSFWorkbookif this class is present, check lib folder of your web app and try to find the same.

检查.m2目录并尝试查找类(HSSFWorkbook如果存在此类),检查您的 Web 应用程序的 lib 文件夹并尝试找到相同的。

回答by Ran Adler

<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>3.9</version>
</dependency>