- 导入maven
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>2.1.1</version>
</dependency>
<!--xls-->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.17</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.17</version>
</dependency>
- 创建entity (可以使用index表示表格每个字段对应的位置)
导出信息完全匹配entity对象生成
public class EasyEntityDemo {
@ExcelProperty(value = "班级",index = 0)
private Integer sno;