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测试 结果
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)