POI 上传文件坑解决方案，Caused by: java.lang.NoClassDefFoundError: org/apache/commons/compress/utils/InputStre

最新推荐文章于 2024-08-14 17:21:44 发布

我吃两碗粉就只给一碗的钱

最新推荐文章于 2024-08-14 17:21:44 发布

阅读量1.1w

点赞数 13

分类专栏： Danny5 文章标签： java poi

本文链接：https://blog.csdn.net/m0_48120149/article/details/112596380

版权

Caused by: java.lang.NoClassDefFoundError: org/apache/commons/compress/utils/InputStreamStatistics

POI 上传文件坑，找了两个小时终于找到解决方案了

结论：org.apache.commons
POI 需要依赖commons 而commons 版本太低，缺失util导致，
解决办法：更换 org.apache.commons 高版本依赖即可

报错信息



java.io.IOException: org/apache/commons/compress/utils/InputStreamStatistics
	at org.apache.poi.ss.usermodel.WorkbookFactory.createWorkbook(WorkbookFactory.java:351)
	at org.apache.poi.ss.usermodel.WorkbookFactory.createXSSFWorkbook(WorkbookFactory.java:314)
	at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:232)
	at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:198)
	at cn.afterturn.easypoi.excel.imports.ExcelImportService.importExcelByIs(ExcelImportService.java:423)
	at cn.afterturn.easypoi.excel.ExcelImportUtil.importExcel(ExcelImportUtil.java:83)
	at com.hzins.wp.aggregation.excel.UploadUtils.importExcel(UploadUtils.java:60)
	at com.hzins.wp.aggregation.controller.counselor.CounselorController.importEmployeeDetail(CounselorController.java:189)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.huize.polaris.colletion.aspect.PolarisLogMethodInterceptor.intercept(PolarisLogMethodInterceptor.java:49)
	at com.hzins.wp.aggregation.controller.counselor.CounselorController$$EnhancerByCGLIB$$d9b4e327.importEmployeeDetail(<generated>)
	at com.hzins.wp.aggregation.controller.counselor.CounselorController$$FastClassBySpringCGLIB$$554c650e.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:720)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
	at com.hzins.wp.aggregation.controller.counselor.CounselorController$$EnhancerBySpringCGLIB$$68d40e16.importEmployeeDetail(<generated>)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:220)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:134)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:116)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFi