pom导入
<dependency>
<groupId>cn.hutool</groupId>
<artifactId>hutool-poi</artifactId>
<version>5.8.11</version>
</dependency>
java控制层
@ApiOperation(value = "hutool导出",produces = "application/octet-stream")
@GetMapping("/hutool/export")
public void hutoolExport(ExcelDTO excelDTO, HttpServletResponse response) throws IOException {
Map<String, Object> row1 = new LinkedHashMap<>();
row1.put("username", "张三");
row1.put("password", 23);
row1.put("nickname", 88.32);
row1.put("email", true);
Map<String, Object> row2 = new LinkedHashMap<>();
row2.put("username", "李四");
row2.put("password", 33);
row2.put("nickname", 59.50);
row2.put("email", false);
ArrayList<Map<String, Object>> rows = CollUtil.newArrayList(row1, row2);
ExcelWriter writer= cn.hutool.poi.excel.ExcelUtil.getWriter(true);
writer.addHeaderAlias("username","姓名");
writer.addHeaderAlias("password","年龄");
writer.addHeaderAlias("nickname","成绩");
writer.addHeaderAlias("email","是否合格");
writer.write(rows,true);
response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset:utf-8");
String fileName="测试1";
response.setHeader("Content-Disposition","attachment;filename="+fileName+".xlsx");
ServletOutputStream outputStream= response.getOutputStream();
writer.flush(outputStream,true);
outputStream.close();
}
swagger导出样子