easyexcel和poi同时使用报错

小妖别跑

于 2024-07-10 16:10:01 发布

阅读量340

点赞数 4

文章标签： java

本文链接：https://blog.csdn.net/qq_43048011/article/details/140326802

版权

报错：

com.alibaba.excel.exception.ExcelGenerateException: java.lang.NoSuchFieldError: Factory
	at com.alibaba.excel.write.ExcelBuilderImpl.<init>(ExcelBuilderImpl.java:42)
	at com.alibaba.excel.ExcelWriter.<init>(ExcelWriter.java:39)
	at com.alibaba.excel.write.builder.ExcelWriterBuilder.build(ExcelWriterBuilder.java:133)
	at com.alibaba.excel.write.builder.ExcelWriterBuilder.sheet(ExcelWriterBuilder.java:149)
	at com.alibaba.excel.write.builder.ExcelWriterBuilder.sheet(ExcelWriterBuilder.java:145)
	at com.zmaxx.framework.excel.core.util.ExcelUtils.write(ExcelUtils.java:41)

使用场景同时使用poi和easyexcel

        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>easyexcel</artifactId>
            <version>3.1.1</version>
        </dependency>
        <!--xls(03版本)-->
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi</artifactId>
            <version>5.2.2</version>
        </dependency>
        <!--xlsx(07版本)-->
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
            <version>5.2.2</version>
        </dependency>

导致最开始的报错

解决方案

easyexcel已经包含 poi和poi-ooxml包了
删除poi和poi-ooxml依赖，保留easyexcel依赖即可。

        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>easyexcel</artifactId>
            <version>3.1.1</version>
        </dependency>