EasyExcel多sheet页导入、导出、导出图片

1.EasyExcel多sheet页导出

public static <T> void writes(HttpServletResponse response, String filename,List<ExcelVo> list) throws IOException {
        // 输出 Excel
        ExcelWriter excelWriter  = EasyExcel.write(response.getOutputStream())
                .autoCloseStream(false) // 不要自动关闭，交给 Servlet 自己处理
                .registerWriteHandler(new LongestMatchColumnWidthStyleStrategy()).build();// 基于 column 长度，自动适配。最大 255 宽度
        list.stream().forEach(t ->{
            WriteSheet writeSheet = EasyExcel.writerSheet(t.getIndex(),t.getSheetName()).head(t.getHead()).build();
            excelWriter.write(t.getData(), writeSheet);
        });
        excelWriter.finish();
        // 设置 header 和 contentType。写在最后的原因是，避免报错时，响应 contentType 已经被修改了
        response.addHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(filename, "UTF-8"));
        response.setContentType("application/vnd.ms-excel;charset=UTF-8");
    }

 2.调用

 @GetMapping("/export-excel")
    @Operation(summary = "导出")
    @OperateLog(type = EXPORT)
    public void report01Export(@Valid Report01Dto reqVO,
                               HttpServletResponse response) throws IOException {
        // 导出 Excel
        Report01Vo report01Vo = reportFormService.report01(reqVO);

        List<QxMerchantOrderRespVO> orderRespVOS = report01Vo.getOrderDetail().getList();
        List<Report01DetailVo> totalVo = report01Vo.getTotalVo();

        List<Report01CertExcelVO> datas1 = BeanUtil.copyToList(orderRespVOS, Report01CertExcelVO.class);
        List<Report01DetaiExcellVo> datas2 = BeanUtil.copyToList(totalVo, Report01DetaiExcellVo.class);

        List<ExcelVo> excelVoList = new ArrayList<>();
        excelVoList.add(new ExcelVo(0,"汇总", Report01DetaiExcellVo.class, datas2));
        excelVoList.add(new ExcelVo(1,"充值明细", Report01CertExcelVO.class, datas1));
        ExcelUtils.writes(response, "财务对账.xls", excelVoList);
    }

3.支持类

@Data
@RequiredArgsConstructor
@AllArgsConstructor
public class ExcelVo {

    int index;
    String sheetName;
    Class head;
    List data;
}

@Data
public class Report01DetaiExcellVo {
   
    @ExcelProperty("类型")
    private String typeStr;
    @ExcelProperty("次数")
    private Integer num;
    @ExcelProperty("金额")
    private BigDecimal amount;
}

@Data
public class Report01CertExcelVO {

    @ExcelProperty("名称")
    private String Name;

    //.......任意

}