EasyPoi
一、基本配置
1. 引入依赖
<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>
二、注解
-
ExcelTarget 要导出的目标对象
-
@Excel:映射属性名
id @Excel(name = "学号",orderNum = "0")//order定义列数 name @Excel(name = "姓名",width = 35,format = "",orderNum = "0") age add
-
ExcelIgnore:忽略某个字段
-
ExcelCollection:表示集合
-
ExcelEntity:
-
[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-EWsPUsIZ-1621478283102)(C:\Users\51144\AppData\Roaming\Typora\typora-user-images\image-20210420170014058.png)]
7.导出list集合
.(img-EWsPUsIZ-1621478283102)]
7.导出list集合