使用EasyExcel报错：Found interface org.apache.poi.util.POILogger, but class was expected

红太狼 2022-12-18 09:58 222阅读 0赞

### 原因：jar包冲突 ###

1.项目中引入了easyexcel，在使用的时候直接报下面的错

com.alibaba.excel.exception.ExcelGenerateException: Can not close IO
    
    Caused by: java.lang.IncompatibleClassChangeError: Found interface org.apache.poi.util.POILogger, but class was expected

2.原因是因为项目中已经引入了easypoi，此时又引入了easyexcel便会引起冲突

<dependency>
                <groupId>cn.afterturn</groupId>
                <artifactId>easypoi-base</artifactId>
                <version>4.1.2</version>
            </dependency>
            <dependency>
                <groupId>cn.afterturn</groupId>
                <artifactId>easypoi-web</artifactId>
                <version>4.1.2</version>
            </dependency>
            <dependency>
                <groupId>cn.afterturn</groupId>
                <artifactId>easypoi-annotation</artifactId>
                <version>4.1.2</version>
            </dependency>
            <dependency>
                <groupId>cn.afterturn</groupId>
                <artifactId>easypoi-spring-boot-starter</artifactId>
                <version>4.1.2</version>
            </dependency>

3.进入easyexcel查看附带的依赖，使用ctrl + alt + B快捷键进入  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTQ0NTg3OQ_size_16_color_FFFFFF_t_70_pic_center]4.你会发现有一个 poi-ooxml 版本是 3.17  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTQ0NTg3OQ_size_16_color_FFFFFF_t_70_pic_center 1]5.进入easypoi-base查看附带的依赖，使用ctrl + alt + B快捷键进入  
![在这里插入图片描述][20201026152615597.png_pic_center]  
6.你会发现有一个 poi-ooxml 版本是 4.1.2  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTQ0NTg3OQ_size_16_color_FFFFFF_t_70_pic_center 2]

7.结论：因为存在两个版本的 poi-ooxml ，所以当我们调用方法后，他不知道使用那个一个依赖，造成了冲突

8.解决方案：排除 easyexcel 里的 poi-ooxml,之后问题就解决了

<dependency>
         <groupId>com.alibaba</groupId>
         <artifactId>easyexcel</artifactId>
         <version>2.1.0-beta1</version>
         <exclusions>
           <exclusion>
              <groupId>org.apache.poi</groupId>
              <artifactId>poi-ooxml</artifactId>
           </exclusion>
         </exclusions>
    </dependency>

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTQ0NTg3OQ_size_16_color_FFFFFF_t_70_pic_center]: /images/20221122/dc4235f2c735469ead75a67539b2d287.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTQ0NTg3OQ_size_16_color_FFFFFF_t_70_pic_center 1]: /images/20221122/8f90060486f449dc85fd8b7475558e35.png
[20201026152615597.png_pic_center]: /images/20221122/52a3343fddb74c1eb056800abd600eb1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTQ0NTg3OQ_size_16_color_FFFFFF_t_70_pic_center 2]: /images/20221122/73cebeb0ada440a885d9b817df877335.png