1.引入jar包
com.alibaba easyexcel 3.0.5
3.处理导出列
private static final long serialVersionUID = -7892217094997331987L;
@ApiModelProperty(value = "ID")
@ExcelIgnore
private Long id;
@ApiModelProperty(value = "姓名")
@ExcelProperty("姓名")
private String name;
@ApiModelProperty(value = "性别")
@ExcelProperty("性别")
private String sex;
3.controller
@GetMapping("/exportExcel")
public WebResponse getExcel(HttpServletResponse response, EmployeeQuery employeeQuery) throws IOException {
List employeeQueryVOList = employeeService.getExportEmployeeInfo(employeeQuery);
//response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
response.setCharacterEncoding("utf-8");
String fileName = URLEncoder.encode("员工列表", "UTF-8");
response.setHeader("Access-Control-Expose-Headers", "Content-Disposition");
response.setHeader("Content-disposition", "attachment;fileName=" + fileName + ".xlsx");
try {
EasyExcel.write(response.getOutputStream(), EmployeeQueryVO.class)
.sheet("人员信息")
.doWrite(employeeQueryVOList);
} catch (Exception e) {
log.info("=============导出失败=============");
}
return WebResponseBuilder.success("导出成功");
}



