pom文件:
<dependency>
<groupId>cn.hutool</groupId>
<artifactId>hutool-all</artifactId>
<version>5.5.2</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>4.1.2</version>
</dependency>
创建实体类:
public class Member {
private String name;
private String sex;
private String y;
private String m;
private String d;
private String bir;
}
读取Excel表:
把别名映射到实体类上
getReader后面可以写sheet页数(-1:全部,默认第一页),也可以写sheet名。
ExcelReader reader = ExcelUtil.getReader(FileUtil.file("a.xlsx"),1);
reader.addHeaderAlias("性别","sex");
reader.addHeaderAlias("姓名","name");
reader.addHeaderAlias("生日","bir");
List<Member> members = reader.readAll(Member.class);
System.out.println("cc = " + members);
reader.close();
File file = FileUtil.file("2.xls");
ExcelReader reader1 = ExcelUtil.getReader(file);
reader1.addHeaderAlias("性别","sex");
reader1.addHeaderAlias("姓名","name");
reader1.addHeaderAlias("生日年份","y");
reader1.addHeaderAlias("生日月份","m");
reader1.addHeaderAlias("生日日期","d");
List<Member> members1 = reader1.readAll(Member.class);
System.out.println("cc = " + members1);
reader1.close();
注意:
- poi-ooxml 版本要在4.1.2以及以上
- xls和xlsx文件要用工具生成的不要手动改后缀名,否则会识别出错。