List<ToxicInformationOpenExport> exports = toxicInformationOpenService.exportToxicInformationOpen(toxicInformationOpenExport);
// 通过工具类创建writer,默认创建xls格式
ExcelWriter writer = ExcelUtil.getWriter();
//自定义标题别名
writer.addHeaderAlias("infoTitle", "文章标题");
writer.addHeaderAlias("reader", "编写人");
writer.addHeaderAlias("reviewer", "审核人");
writer.addHeaderAlias("createTime", "提交时间");
writer.addHeaderAlias("openChannel", "发布渠道");
writer.setColumnWidth(0,30);
writer.setColumnWidth(3,20);
//sheet重命名
writer.renameSheet("信息公开");
writer.write(exports,true);
String filename = "信息公开.xls";
serverResponse.getHeaders().set(org.springframework.http.HttpHeaders.CONTENT_DISPOSITION,
"attachment;filename=".concat(String.valueOf(URLEncoder.encode(filename, "UTF-8"))));
serverResponse.getHeaders().add("Accept-Ranges"
WebFlux使用Hutool导出excel
最新推荐文章于 2024-06-12 01:40:07 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)