Java 错误提示org.apache.poi.POIXMLEx

java 操作excel文件 发布后报错

org.apache.poi.POIXMLException: java.lang.reflect.InvocationTargetException

XSSFWorkbook xwb = new XSSFWorkbook(fileName);

这句报错

使用的poi版本 3.8

网上提供的解决方案很多，一一试下，也没有解决。

后经过各种调查后，终于找到了解决办法。

此问题的确是jar包冲突。

只需要将里面的引用的 xbean-2.2.0.jar删除

bweb\WEB-INF\lib\xbean-2.2.0.jar 此目录下的xbean-2.2.0.jar包删除 即可

错误详情

org.apache.poi.POIXMLException: java.lang.reflect.InvocationTargetException
at org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFact
ory.java:62)
at org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:403)
at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:155)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:1

90. at com.hp.bpdp.integrated.common.ExcelOperate.getData(ExcelOperate.java:
    

91. at com.hp.bpdp.ass.service.impl.AssInfoSecurityTaskServiceImpl.antiFraud
    

Complaint(AssInfoSecurityTaskServiceImpl.java:2296)
at com.hp.bpdp.ass.service.impl.AssInfoSecurityTaskServiceImplFastClas
sBySpringCGLIBd7aa56ae.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:2

4. at org.springframework.aop.framework.CglibAopProxyCglibMethodInvocation
   

.invokeJoinpoint(CglibAopProxy.java:708)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:157)
at org.springframework.transaction.interceptor.TransactionInterceptor1.
proceedWithInvocation(TransactionInterceptor.java:98)
at org.springframework.transaction.interceptor.TransactionAspectSupport.
invokeWithinTransaction(TransactionAspectSupport.java:262)
at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:95)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:179)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invok
e(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.CglibAopProxyDynamicAdvisedInterce
ptor.intercept(CglibAopProxy.java:644)
at com.hp.bpdp.ass.service.impl.AssInfoSecurityTaskServiceImplEnhancer
BySpringCGLIB1ff8283d.antiFraudComplaint(<generated>)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.scheduling.support.ScheduledMethodRunnable.run(Sc
heduledMethodRunnable.java:65)
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnabl
e.run(DelegatingErrorHandlingRunnable.java:54)
at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(Re
schedulingRunnable.java:81)
at java.util.concurrent.ExecutorsRunnableAdapter.call(Executors.java:47

1.  at java.util.concurrent.FutureTask.run(FutureTask.java:262)
    at java.util.concurrent.ScheduledThreadPoolExecutorScheduledFutureTask.
   

access201(ScheduledThreadPoolExecutor.java:178)
at java.util.concurrent.ScheduledThreadPoolExecutorScheduledFutureTask.
run(ScheduledThreadPoolExecutor.java:292)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
java:1145)
at java.util.concurrent.ThreadPoolExecutorWorker.run(ThreadPoolExecutor
.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct

orAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
onstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFact
ory.java:60)
... 31 more
Caused by: java.lang.ExceptionInInitializerError
at sun.misc.Unsafe.ensureClassInitialized(Native Method)
at sun.reflect.UnsafeFieldAccessorFactory.newFieldAccessor(UnsafeFieldAc
cessorFactory.java:43)
at sun.reflect.ReflectionFactory.newFieldAccessor(ReflectionFactory.java
:140)
at java.lang.reflect.Field.acquireFieldAccessor(Field.java:1057)
at java.lang.reflect.Field.getFieldAccessor(Field.java:1038)
at java.lang.reflect.Field.get(Field.java:379)
at org.apache.xmlbeans.XmlBeans.typeSystemForClassLoader(XmlBeans.java:7

70. at org.openxmlformats.schemas.drawingml.x2006.main.ThemeDocument.<clinit
    

(Unknown Source)
at org.openxmlformats.schemas.drawingml.x2006.main.ThemeDocument$Factory
.parse(Unknown Source)
at org.apache.poi.xssf.model.ThemesTable.<init>(ThemesTable.java:44)
... 36 more
Caused by: java.lang.RuntimeException: Could not instantiate SchemaTypeSystemImp
l (java.lang.reflect.InvocationTargetException): is the version of xbean.jar cor
rect?
at schemaorg_apache_xmlbeans.system.sE130CAA0A01A7CDE5A2B4FEB8B311707.Ty
peSystemHolder.loadTypeSystem(Unknown Source)
at schemaorg_apache_xmlbeans.system.sE130CAA0A01A7CDE5A2B4FEB8B311707.Ty
peSystemHolder.<clinit>(Unknown Source)
... 46 more
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct

orAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
onstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
... 48 more
Caused by: org.apache.xmlbeans.SchemaTypeLoaderException: XML-BEANS compiled sch
ema: Incompatible minor version - expecting up to 23, got 24 (schemaorg_apache_x
mlbeans.system.sE130CAA0A01A7CDE5A2B4FEB8B311707.index) - code 3
at org.apache.xmlbeans.impl.schema.SchemaTypeSystemImpl$XsbReader.<init>
(SchemaTypeSystemImpl.java:1522)
at org.apache.xmlbeans.impl.schema.SchemaTypeSystemImpl.initFromHeader(S
chemaTypeSystemImpl.java:260)
at org.apache.xmlbeans.impl.schema.SchemaTypeSystemImpl.<init>(SchemaTyp
eSystemImpl.java:183)