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

[全栈程序员]

触发场景描述

• 当使用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>