poi5.2.2+ 与easyexcel3.1.3jar包冲突

2024-05-27 09:11:33 1.3k 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

普通Java项目打包JAR后EasyExcel报错：POI依赖冲突的排查与解决本文详细分析了普通Java项目使用Maven打包成JAR后，运行EasyExcel时出现POI依赖冲突的根本原因。通过解析Maven依赖传递机制与JAR包合并原理，提供了两种核心解决方案：一是通过依赖排除与版本统一来根治冲突；二是优化打包插件配置，推荐使用maven-shade-plugin。文章还提供了使用mvn dependency:tree命令和IDEA Maven Helper插件进行快速诊断的实用技巧，帮助开发者彻底解决打包报错问题。阅读详情

触发场景描述

当使用poi读取有数据及样式的excel时，就会报错
触发Bug的代码

try (InputStream inputStream = classPathResource.getInputStream()){
Workbook wb = WorkbookFactory.create(inputStream);
｝

java.lang.NoSuchFieldError: Factory
  at org.apache.poi.xssf.model.ThemesTable.readFrom(ThemesTable.java:119)
  at org.apache.poi.xssf.model.ThemesTable.<init>(ThemesTable.java:87)
  at org.apache.poi.ooxml.POIXMLFactory.createDocumentPart(POIXMLFactory.java:61)
  at org.apache.poi.ooxml.POIXMLDocumentPart.read(POIXMLDocumentPart.java:661)
  at org.apache.poi.ooxml.POIXMLDocument.load(POIXMLDocument.java:165)
  at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:260)
  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:224)
  at org.apache.poi.ss.usermodel.WorkbookFactory.wp(WorkbookFactory.java:329)
  at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:224)
  at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:185)
  at com.daysuns.dams.utils.easypoi.util.ResourceLoader.getWorkbook(ResourceLoader.java:23)
  at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:102)
  at com.daysuns.dams.sys.aspect.TimeLimitTaskExecutorAspect$TimeoutCallable.call(TimeLimitTaskExecutorAspect.java:53)
  at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  at java.lang.Thread.run(Thread.java:748)

解决办法

POI 5.0+版本冲突，需要排除easyexcel的poi依赖

<dependency>
          <groupId>com.alibaba</groupId>
          <artifactId>easyexcel</artifactId>
          <version>${easyexcel.version}</version>
          <exclusions>
              <exclusion>
                  <groupId>org.apache.poi</groupId>
                  <artifactId>poi-ooxml</artifactId>
              </exclusion>
              <exclusion>
                  <groupId>org.apache.poi</groupId>
                  <artifactId>poi-ooxml-schemas</artifactId>
              </exclusion>
          </exclusions>
      </dependency>