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>
2.实体类
@Data
@ExcelTarget("user")
@AllArgsConstructor
@NoArgsConstructor
@TableName("user")
public class Users implements Serializable {
/**
* name 生成表格的列名
* orderNum 排序顺序
* needMerge 是否需要纵向合并单元格 (用于含有list,单个单元格,合并list创建的多个row)
* suffix 加后缀
* replace 替换{替换的值,原来的值}
* @ExcelIgnore 导出忽略
*/
@Excel(name = "序号", orderNum = "0",needMerge = true)
@TableId(value = "id")
private String id;
@Excel(name = "姓名", orderNum = "1",