EasyPoi导入和导出Excel
1.easypoi 导包
<dependency>
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-base</artifactId>
<version>3.2.0</version>
</dependency>
<dependency>
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-web</artifactId>
<version>3.2.0</version>
</dependency>
<dependency>
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-annotation</artifactId>
<version>3.2.0</version>
</dependency>
2.easypoi导出Excel;
2.1在需要导出的实体字段上加上@Excel(name=”“)的注解,name后为你要导出字段在Excel中的名称
导出的Excel的参数设置,"员工信息"为Excel的标题,"小姑娘"为表名sheet
ExcelType.XSSF 为导出的Excel类型
ExportParams params = new ExportParams("员工信息", "小姑娘", ExcelT