easypoi 批量导出_使用EasyPoi快速实现Excel的导入导出

excel.jpg

近期完成了后管系统报表的导入导出，完成之后做下总结

1、首先我们对采用的插件进行了筛选，最后选择EasyPoi，用的人也很多，算是对poi的简单封装

这里项目用的springboot，所以只用pom引入配置即可

cn.afterturn

easypoi-base

3.0.3

cn.afterturn

easypoi-web

3.0.3

cn.afterturn

easypoi-annotation

3.0.3

2、根据配置编写实体类

先简单介绍一下关于@Excel注解的一些常用属性

name：列名

orderNum：第几列

replace：值得替换 例：replace = {"身份证_1"} 数据库值为"1"，导出时会自动被"身份证"代替

@Excel(name = "姓名", orderNum = "0")

private String name;

@Excel(name = "证件类型", replace = {"身份证_1"}, orderNum = "1")

private String identifyType;

@Excel(name = "证件号码", orderNum = "2")

private String identifyNo;

@Excel(name = "手机号1", orderNum = "3")

private String phoneA;

@Excel(name = "手机号2", orderNum = "4")

private String phoneB;

@Excel(name = "手机号3", orderNum = "5")

private String phoneC;

@Excel(name = "固定电话", orderNum = "6")

private String telephone;

@Excel(name = "电子邮箱", orderNum = "7")

private String email;

@Excel(name = "身份证地址", orderNum = "8")

private String idcardAdress;

@Excel(name = "户籍地址", orderNum = "9")

private String h