java.lang.NoClassDefFoundError: Could not initialize class org.a*.poi.xssf.model.SharedStringsTable

异常

You need to add dependency of 'poi-ooxml' to your project, and version >= 3.17

cn.hutool.core.exceptions.DependencyException: You need to add dependency of 'poi-ooxml' to your project, and version >= 3.17
        at cn.hutool.poi.excel.ExcelUtil.getReader(ExcelUtil.java:310)
        at cn.hutool.poi.excel.ExcelUtil.getReader(ExcelUtil.java:261)
        at c.h.u.a.c.UC.impoetFile(UC.java:306)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.base/java.lang.reflect.Method.invoke(Method.java:566)
        at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
        at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
        at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)
        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878)
        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792)
        at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
        at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:652)
        at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        ...
Caused by: java.lang.NoClassDefFoundError: Could not initialize class org.apache.poi.xssf.model.SharedStringsTable
        at org.apache.poi.ooxml.POIXMLFactory.createDocumentPart(POIXMLFactory.java:61)
        at org.apache.poi.ooxml.POIXMLDocumentPart.read(POIXMLDocumentPart.java:660)
        at org.apache.poi.ooxml.POIXMLDocument.load(POIXMLDocument.java:165)
        at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:278)
        at org.apache.poi.xssf.usermodel.XSSFWorkbookFactory.createWorkbook(XSSFWorkbookFactory.java:118)
        at org.apache.poi.xssf.usermodel.XSSFWorkbookFactory.create(XSSFWorkbookFactory.java:98)
        at org.apache.poi.xssf.usermodel.XSSFWorkbookFactory.create(XSSFWorkbookFactory.java:36)
        at org.apache.poi.ss.usermodel.WorkbookFactory.lambda$create$2(WorkbookFactory.java:199)
        at org.apache.poi.ss.usermodel.WorkbookFactory.wp(WorkbookFactory.java:295)
        at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:199)
        at cn.hutool.poi.excel.WorkbookUtil.createBook(WorkbookUtil.java:88)
        at cn.hutool.poi.excel.WorkbookUtil.createBook(WorkbookUtil.java:74)
        at cn.hutool.poi.excel.ExcelReader.<init>(ExcelReader.java:85)
        at cn.hutool.poi.excel.ExcelUtil.getReader(ExcelUtil.java:308)

jar版本 

 <!--hutool-->

<dependency>
    <groupId>cn.hutool</groupId>
    <artifactId>hutool-all</artifactId>
    <version>4.5.10</version>
</dependency>

<!--poi-->
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>5.0.0</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml-schemas</artifactId>
    <version>4.1.2</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>5.0.0</version>
</dependency>

原因 

hutool-all版本太低,升级到5.*

后续问题

hutool-all升级后,报

SEVERE: Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Handler dispatch failed; nested exception is java.lang.NoSuchMethodError: 'org.apache.xmlbeans.XmlOptions org.apache.xmlbeans.XmlOptions.setUseDefaultNamespace(boolean)'] with root cause
java.lang.NoSuchMethodError: 'org.apache.xmlbeans.XmlOptions org.apache.xmlbeans.XmlOptions.setUseDefaultNamespace(boolean)'
        at org.apache.poi.xssf.model.SharedStringsTable.<clinit>(SharedStringsTable.java:96)
        at org.apache.poi.ooxml.POIXMLFactory.createDocumentPart(POIXMLFactory.java:61)
        at org.apache.poi.ooxml.POIXMLDocumentPart.read(POIXMLDocumentPart.java:660)
        at org.apache.poi.ooxml.POIXMLDocument.load(POIXMLDocument.java:165)
        at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:278)
        at org.apache.poi.xssf.usermodel.XSSFWorkbookFactory.createWorkbook(XSSFWorkbookFactory.java:118)
        at org.apache.poi.xssf.usermodel.XSSFWorkbookFactory.create(XSSFWorkbookFactory.java:98)
        at org.apache.poi.xssf.usermodel.XSSFWorkbookFactory.create(XSSFWorkbookFactory.java:36)
        at org.apache.poi.ss.usermodel.WorkbookFactory.lambda$create$2(WorkbookFactory.java:199)
        at org.apache.poi.ss.usermodel.WorkbookFactory.wp(WorkbookFactory.java:295)
        at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:199)
        at cn.hutool.poi.excel.WorkbookUtil.createBook(WorkbookUtil.java:110)
        at cn.hutool.poi.excel.WorkbookUtil.createBook(WorkbookUtil.java:97)
        at cn.hutool.poi.excel.ExcelReader.<init>(ExcelReader.java:86)
        at cn.hutool.poi.excel.ExcelUtil.getReader(ExcelUtil.java:208)
        at cn.hutool.poi.excel.ExcelUtil.getReader(ExcelUtil.java:195)
        at c.h.u.a.c.UC.impoetFile(UC.java:306)
...

原因

poi-ooxml-schemas包引入错误,poi包5.*版本更改了名称:poi-ooxml-schemas 改为 poi-ooxml-lite/full;

删除poi-ooxml-schemas包,poi-ooxml-lite包已经在poi包里,所以只添加poi-ooxml-full

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

 解析Excel正常;

参考(poi官方文档5.0.0栏):History of Changes

  • 1
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
java.lang.NoClassDefFoundError: Could not initialize class异常通常是由于类的静态初始化块或静态变量的初始化过程中发生了异常导致的。这个异常表示在类加载过程中,虚拟机无法找到或初始化指定的类。 对于引用中的异常"java.lang.NoClassDefFoundError: Could not initialize class xxx",其中的"xxx"是指具体的类名。这个异常的原因可能是以下几种情况之一: 1. 缺少相关的依赖库或jar包。 2. 类的静态初始化块或静态变量的初始化过程中发生了异常。 3. 类的初始化过程中发生了其他异常,例如访问权限问题或反射异常等。 解决这个异常的方法可以尝试以下几种方式: 1. 检查相关的依赖库或jar包是否存在,并确保它们的版本和路径正确。 2. 检查类的静态初始化块或静态变量的初始化过程中是否有异常抛出,并修复这些异常。 3. 检查类的初始化过程中是否有其他异常抛出,并修复这些异常。 4. 检查类的访问权限是否正确,并确保没有其他限制导致类无法被初始化。 5. 如果使用了反射相关的代码,检查反射相关的异常,并修复这些异常。 以下是一个示例代码,演示了如何处理java.lang.NoClassDefFoundError异常: ```java try { // 尝试初始化类 Class.forName("org.mockito.Mockito"); } catch (ClassNotFoundException e) { // 类未找到异常 e.printStackTrace(); } catch (ExceptionInInitializerError e) { // 类的静态初始化过程中发生了异常 e.printStackTrace(); } catch (Throwable t) { // 其他异常 t.printStackTrace(); } ```

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值