poi从3.6 升级为新版本5.2.2，导致 原先的代码 报错，替换方案

参考：https://blog.csdn.net/weixin_43976226/article/details/125449959

 

 

我的代码报：

java.lang.NoClassDefFoundError: Could not initialize class org.openxmlformats.schemas.spreadsheetml.x2006.main.CTWorkbook
at org.apache.poi.xssf.usermodel.XSSFWorkbook.onWorkbookCreate(XSSFWorkbook.java:475) ~[poi-ooxml-5.2.2.jar!/:5.2.2]
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:232) ~[poi-ooxml-5.2.2.jar!/:5.2.2]
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:226) ~[poi-ooxml-5.2.2.jar!/:5.2.2]
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:214) ~[poi-ooxml-5.2.2.jar!/:5.2.2]

 

添加jar包：

<dependency>
    <groupId>org.apache.xmlbeans</groupId>
    <artifactId>xmlbeans</artifactId>
    <version>5.1.0</version>
</dependency>
就可以了