EasyExcel简单使用导入导出及配置

1--引入依赖

<!--EasyExcel依赖-->
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>easyexcel</artifactId>
    <version>2.2.7</version>
</dependency>

2--配置实体类

//主要两个注解 
//一：@ExcelProperty("账号") 写出的Excel表的表头名  
//二：@ExcelIgnore  忽略这个字段
public class SysUserExcel {
    @ExcelIgnore
    private Long id;
    @ExcelProperty("账号")
    private String userName;
}

 3--配置监听器

@Component
public class SysUserExcelListener extends AnalysisEventListener<SysUserExcel> {
    @Resource
    private SysUserExcelService service;
    private ArrayList<SysUserExcel> userList = new ArrayList<>();
    private static final int size = 3000;//长度为多少提交一次
    private static final SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd");

    @Override
    public voi