导入excel hutool工具

第一步 : 导包

(需要注意这里包的版本号有很大问题需要注意 !!!)

<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>4.0.0</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>4.0.0</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml-schemas</artifactId>
<version>4.0.0</version>
</dependency>

接下来就简单了

第二步 : 不知道怎么描述了->看代码

首先 必须要有个和excel 标题对应的类

@Data
public class Student {

private String id;

private String name;

private String age;
}

其次

ExcelReader reader = ExcelUtil.getReader("d:\\aaa.xlsx");
reader.addHeaderAlias("编号","id");
reader.addHeaderAlias("姓名","name");
reader.addHeaderAlias("年龄","age");
List<Student> readAll = reader.readAll(Student.class);