POI使用XSSFWorkbook异常

使用poi创建XSSFWorkbook报错:

                        InputStream is = new FileInputStream(file);
// 构造 XSSFWorkbook 对象，strPath 传入文件路径
XSSFWorkbook xwb = new XSSFWorkbook(is);

异常信息:

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

java.lang.ClassNotFoundException: org.openxmlformats.schemas.wordprocessingml.x2006.main.impl.CTPIm.....

XML-BEANS compiled schema: Incompatible minor version - expecting up to 23, got 24 (schemaorg_apache_xmlbeans.system.sE130CAA0A01A7CDE5A2B4FEB8B311707.index) - code 3 at org.apache.xmlbeans.impl.schema.SchemaTypeSystemImpl$XsbReader.<init>(SchemaTypeSystemImpl.java:1522) at org.apache.xmlbeans.impl.schema.SchemaTypeSystem.....

原因:

jar包冲突项目中使用了xfire依赖的jar:

    xbean-2.2.0.jar

    xfire-xmlbeans-1.2.6

    xmlbeans-2.3.0.jar

解决方案:

    删除三个低版本的jar引入高版本的    xmlbeans-2.4.0.jar

            尝试在BuildPath中取消引用之后,依然报错(所以直接删除)

 找到其他几篇其他问题的解决方案,可以参考:

https://blog.csdn.net/lex1993/article/details/47062141

https://blog.csdn.net/seashouwang/article/details/24025871

https://blog.csdn.net/bbc2005/article/details/53783150