easypoi导出excel表格数据

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
@ApiOperation(value = "列表数据导出")
@PostMapping(value = "/preFollowListExport", produces = "application/json;charset=UTF-8")
public void export(HttpServletResponse servletResponse) throws IOException {
String name = "数据表";
servletResponse.setHeader("content-Type", "application/vnd.ms-excel");
servletResponse.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(name + ".xls", "utf-8"));
servletResponse.setHeader("Access-Control-Expose-Headers", "ContentDisposition");
//获取数据源
List<DataBean> list = null;
ExportParams params = new ExportParams(name, "sheet1");
Workbook workbook = ExcelExportUtil.exportBigExcel(params, DataBean.class, list);
ExcelExportUtil.closeExportBigExcel();
try {
workbook.write(servletResponse.getOutputStream());
}catch (IOException e) {
e.printStackTrace();
}finally {
workbook.close();
}
}

1
2
3
4
5
6
7
8
@Data
@ExcelTarget(value = "dataBean")
public class DataBean implements Serializable {
@Excel(name = "序号")
private Integer sortNum;
@Excel(name = "姓名")
private String name;
}