一、安装依赖
推荐使用最新版本,可通过文章末尾官方文档链接跳转查看
<dependency>
<groupId>cn.gjing</groupId>
<artifactId>tools-excel</artifactId>
<version>2.2.8</version>
</dependency>
二、Excel导出
定义Excel映射实体, @Data是lombok的注解
/**
* @author Gjing
**/
@Data
@Excel("单级表头")
public class SingleHead {
@ExcelField("姓名")
private String userName;
@ExcelField(value = "年龄", format = "0")
private Integer userAge;
@ExcelField("性别")
private Gender gender;
@ExcelField("爱好")
private String favorite;
}
/**
* @author Gjing
**/
@RestController
public class UserController {
@GetMapping("/test_export")
@ApiOperation("导出一级表头")
public void testExport(HttpServletResponse response) {
//指定映射的实体为刚刚定义的
ExcelFactory.createWriter(SingleHead.class, response)
.write(null)
.flush();
}
}