Excel导出相关

实体类：

@Data
@Builder
@HeadRowHeight(22)
@ContentFontStyle(fontName = "宋体", fontHeightInPoints = (short)14)
@HeadStyle(horizontalAlignment = HorizontalAlignment.CENTER)
@ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER)
@ColumnWidth(20)
public class AbilityExcel extends BaseRowModel {

    @ExcelProperty(value = "名称", index = 0)
    private String name;

    @ExcelProperty(value = "类型", index = 1)
    private String channelName;

    @ExcelProperty(value = "地址",index = 2)
    private String address;

}

导出到单个Sheet页：

 public static synchronized String exportExcel(List<? extends BaseRowModel> exportList, Class<? extends BaseRowModel> clazz, String fileName, String sheetName, HttpServletResponse response) {
        ExcelWriter writer = null;
        try {
            OutputStream outputStream = response.getOutputStream();
            //TODO
            String urlEncoderFileName = DateUtils.dateToString(new Date(), DateUtils.yyyyMMddHHmmss);
            log.info("exportExcel fileName【{}】, urlEncoderFileName 【{}】", fileName, urlEncoderFileName);

            response.setHeader("Content-disposition", "attachment; filename=" +urlEncoderFileName  + ".xlsx");
            response.setContentType("application/msexcel;charset=UTF-8");//设置类型
            response.setHeader("Pragma", "No-cache");//设置头
            response.setHeader("Cache-Control", "no-cache");//设置头
            response.setDateHeader("Expires", 0);//设置日期头

            //实例化 ExcelWriter
            writer = new ExcelWriter(outputStream, ExcelTypeEnum.XLSX, true);

            //实例化表单
            Sheet sheet = new Sheet(1, 0, clazz);
            sheet.setSheetName(sheetName);

            //输出
            writer.write(exportList, sheet);
            writer.finish();
            outputStream.flush();
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            try{
                response.getOutputStream().close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
        return "index";
    }

若存在多个List<AbilityExcel>，也可以导出到一个Excel文件的多个Sheet中：

 public static String exportExcelWithSheets (String fileName, List<List<AbilityExcel>> srcList ,HttpServletResponse response) {
        try {
            ExcelWriter excelWriter = EasyExcel.write(response.getOutputStream()).build();
            for (int i = 0; i < srcList.size(); i++) {
                List<AbilityExcel> tmpAbilityList = srcList.get(i);
                String sheetName = tmpAbilityList.get(0).getAbilityName();
                WriteSheet abilityExcelInfo = EasyExcel.writerSheet(i, StringUtil.isNotEmpty(sheetName) ? sheetName : "Sheet" + i)
                        .head(AbilityExcel.class)
                        .registerWriteHandler(new LongestMatchColumnWidthStyleStrategy())
                        .build();
                excelWriter.write(tmpAbilityList, abilityExcelInfo);
            }
            response.setContentType("application/vnd.ms-excel;charset=utf-8");
            response.setCharacterEncoding("UTF-8");
            response.setHeader("Content-Disposition","attachment;filename="+URLEncoder.encode(fileName, "UTF-8") + "_" + DateUtils.dateToString(new Date(), DateUtils.yyyyMMddHHmmss)+".xlsx");
            excelWriter.finish();
        } catch (Exception e) {
            log.error("exportExcelWithSheets error", e);
        }
        return "success";
    }