easyexcel报错：com.alibaba.excel.exception.ExcelAnalysisException: java.lang.NoClassDefFoundError: org/

最新推荐文章于 2024-07-10 16:10:01 发布

Super.D

最新推荐文章于 2024-07-10 16:10:01 发布

阅读量1.8k

点赞数

文章标签： excel java 开发语言

本文链接：https://blog.csdn.net/qq_16843563/article/details/132336401

版权

【日常POC问题记录，easyexcel报错】
【报错信息】

com.alibaba.excel.exception.ExcelAnalysisException: java.lang.NoClassDefFoundError: org/apache/poi/poifs/filesystem/FileMagic

【问题代码】

@PostMapping("/testExcel22")
public Payload testExcel(MultipartFile file) {
    try {
        EasyExcel.read(file.getInputStream(), TestExcel.class,new ExcelImportMemberAddressListener()).sheet().doRead();
    } catch (Exception e) {
        e.printStackTrace();
        throw new ApplicationException("XXXXXexcel解析失败");
    }
    return new Payload();
}

【原因】缺少依赖或者依赖冲突，导致找不到类
【解决办法1】引包

<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>easyexcel</artifactId>
    <version>2.2.6</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>3.17</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-scratchpad</artifactId>
    <version>3.17</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>3.17</version>
</dependency>