Hutool 操做excel 导出大数据 到excel

1. hutool的版本： hutool-all.4.5.15

2. POI 的版本： 3.17

<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>3.17</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>3.17</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml-schemas</artifactId>
    <version>3.17</version>
</dependency>

<dependency>
	<groupId>cn.hutool</groupId>
	<artifactId>hutool-all</artifactId>
	<version>4.5.15</version>
</dependency>

3. Controller:

@GetMapping("/export")
@ApiOperation(
       value = "导出  所有数据",
       notes = "导出  所有数据",
       response = ResponseMessage.class
)
public void export(HttpServletRequest request, HttpServletResponse response) {
	log.info("######导出  所有数据");
	manageService.export(request, response);
}

4.service:

@Override
public void export(HttpServletRequest request, HttpServletResponse response) {
	try {
		ExcelWriter writer = ExcelUtil.getBigWriter();
		writer.renameSheet("所有数据");     //甚至sheet的名称
        writer.addHeaderAlias("id", "数据ID");   //设置head的名称， 此时的顺寻就是导出的顺序， key就是RecordInfoDetailsDTO的属性名称， value就是别名
        writer.addHeaderAlias("name", "名称");
        writer.addHeaderAlias("provinceName", "所属区域");
        writer.addHeaderAlias("groupId", "所属组ID");
        writer.addHeaderAlias("groupName", "所属组名称");
        writer.addHeaderAlias("status_name", "状态");
        writer.addHeaderAlias("approvalStatus_name", "审核状态");
        
        List<RecordInfoDetailsDTO> list = query(); //查询出所有的需要导出的数据
        writer.write(list, true);
        writer.setOnlyAlias(true);
        response.reset();
        response.setContentType("application/vnd.ms-excel;charset=utf-8");
        response.setHeader("Content-Disposition", "attachment; filename="+URLEncoder.encode("所有数据", "UTF-8")+".xlsx");   //中文名称需要特殊处理
        writer.flush(response.getOutputStream());
		
        writer.close();
	} catch (Exception e) {
        //如果导出异常，则生成一个空的文件
		log.info("######导出  excel异常  ：{}",e.getMessage());
		try (ByteArrayOutputStream outputStream2 = new ByteArrayOutputStream()) {
			Workbook workbook = new XSSFWorkbook();
			workbook.createSheet("生成数据异常");
        	StringBuilder fileName = new StringBuilder("所有数据").append(".xlsx");
	        workbook.write(outputStream2);
	        outputStream2.flush();
	        AasExcelUtils.export(request, response, outputStream2.toByteArray(), fileName.toString());
        }catch (Exception e2) {}
	} 
}

5. postman测试 结果