百万级别的大批量excel导出

1 导入pom

cn.hutool

hutool-all

4.6.1

2 主逻辑

@GetMapping("/test1")

public void test2(HttpServletResponse response) throws IOException {

ServletOutputStream outputStream = response.getOutputStream();

response.setContentType("application/vnd.ms-excel;charset=utf-8");

response.setHeader("Content-Disposition","attachment;filename=test.xlsx");

ExcelWriter bigWriter = ExcelUtil.getBigWriter();

List list1 = new ArrayList<>();

for (int i = 0; i < 1000000 ; i++) {

User user = new User(String.valueOf(i+1),String.valueOf(i));

list1.add(user);

}

bigWriter.write(list1);

bigWriter.flush(outputStream);

bigWriter.close();

return;

}