导出excel文件主要使用了easyExcel中的相关方法:
public ByteFile exportList() {
List<ExportVo> list = Service.queryExportList();
ByteFile export;
try {
export = byteFileByExport(list);
} catch (IOException e) {
throw new BizException("导出失败:" + e.getMessage());
}
export.setFileName("excel文件名称" + TimeUtils.format(new Date(), DateFormat.NUMDATE) + ".xlsx");
return export;
}
private ByteFile byteFileByExport(List<ExportVo> dataList) throws IOException {
PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
Resource resource = resolver.getResource("classpath:excel/exportExcel.xlsx");
// 这里 会填充到第一个sheet, 然后文件流会自动关闭
ByteArrayOutputStream baos = new ByteArrayOutputStream();
InputStream inputSt