//导出数据
try {
String fileName = "报价单详情" + LocalDate.now();
fileName = URLEncoder.encode(fileName, "UTF-8").replaceAll("\\+", "%20");
response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx");
ExcelWriter excelWriter = EasyExcel.write(response.getOutputStream()).build();
WriteSheet writeOneSheet;
WriteSheet writeTwoSheet;
// 构建sheet对象
writeOneSheet = EasyExcel.writerSheet("Standard Parts").head(EbdStandardPartsDataDTO.class).build();
writeTwoSheet = EasyExcel.writerSheet("Material and Processing").head(EbdMachinedPartsDTO.class).build();
// 写出sheet数据
excelWriter.write(ebdStandardPartsDataDTOList, writeOneSheet);
excelWriter.write(ebdMachinedPartsDTOList, writeTwoSheet);
// 关流
excelWriter.finish();
} catch (IOException e) {
throw new RuntimeException(e);
}
07-02
2553