com.alibaba.easyexcel导出EXCEL文件
1.POM.XML
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>2.2.8</version>
<exclusions>
<exclusion>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-api</artifactId>
</exclusion>
</exclusions>
</dependency>
2.创建导出实体
@Data
public class XXXX{
@ExcelProperty("主键ID")
private Integer id;
@ExcelProperty("用户ID")
private String userId;
@ExcelProperty("姓名")
private String userName;
3.接口
@RequestMapping("/toExcel.do")
public void toExcel(@RequestBody XXX param,HttpServletRequest request, HttpServletResponse response)throws Exception{
String sheetName = "";
List<XXXX> resultList = toExcel(param, response);
String fileName = URLEncoder.encode(sheetName, "UTF-8");
response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
response.setCharacterEncoding("utf-8");
response.addHeader("Content-Disposition", "attachment;filename=" + fileName + ".xlsx");
EasyExcel.write(response.getOutputStream(), XXX.class) .sheet(sheetName) .doWrite(resultList);
}
参考官方文档:https://alibaba-easyexcel.github.io/index.html