excel导入导出java报错汇总

核心解决问题：版本

涉及报错

NoClassDefFoundError

 

涉及依赖

poi,poi-ooxml,easyexcel,cglib,asm

版本对照链接：

https://easyexcel.opensource.alibaba.com/qa/

已验证过的组合

jdk8

3.16

 

 

springboot3.3.0+jdk17

<properties>
　　　　　<poi.version>4.1.2</poi.version>
        <easyexcel.version>3.3.4</easyexcel.version>
        <cglib.version>3.3.0</cglib.version>
        <asm.version>9.4</asm.version>
</properties>

<dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>easyexcel</artifactId>
            <exclusions>
                <exclusion>
                    <artifactId>poi-ooxml-schemas</artifactId>
                    <groupId>org.apache.poi</groupId>
                </exclusion>
            </exclusions>
        </dependency>
        <dependency>
            <groupId>cglib</groupId>
            <artifactId>cglib</artifactId>
        </dependency>
        <dependency>
            <groupId>org.ow2.asm</groupId>
            <artifactId>asm</artifactId>
        </dependency>