EasyExcel封装下载导出多sheet表格--根据某个字段分类

最新推荐文章于 2024-07-23 17:07:58 发布

Gentle weirdo α

最新推荐文章于 2024-07-23 17:07:58 发布

阅读量101

点赞数 1

文章标签： java excel

本文链接：https://blog.csdn.net/weixin_53759341/article/details/134506319

版权

工具类 ExcelUtils 名称自定义

public class ExcelUtils {
  public static <T> void exportExcel(Map<String, List<T>> departmentData, String sheetName, Class<T> clazz, HttpServletResponse response) {
    exportExcel(departmentData, sheetName, clazz, false, response);
  }


  public static <T> void exportExcel(Map<String, List<T>> departmentData,String sheetName, Class<T> clazz, boolean merge, HttpServletResponse response) {
    try {
      resetResponse(sheetName, response);
      ServletOutputStream os = response.getOutputStream();
      ExcelWriterBuilder writerBuilder = EasyExcel.write(os, clazz).autoCloseStream(false)
              .registerWriteHandler(new LongestMatchColumnWidthStyleStrategy())
              .registerConverter(new ExcelBigNumberConvert());
      // 构建 ExcelWriter 对象
      ExcelWriter excelWriter = writerBuilder.build();
      for (Map.Entry<String, List<T>> entry : departmentData.entrySet()) {
        String departmentName = entry.getKey();
        List<T> departmentList = entry.getValue();

        ExcelWriterSheetBuilder sheetBuilder = writerBuilder.sheet(departmentName);

        if (merge) {
          sheetBuilder.registerWriteHandler(new CellMergeStrategy(departmentList, true));
        }

        WriteSheet sheet = sheetBuilder.head(clazz).build();
        excelWriter.write( departmentList, sheet);
      }

      // 关闭 ExcelWriter 对象
      excelWriter.finish();
    } catch (IOException e) {
      throw new RuntimeException("导出Excel异常", e);
    }
  }




  /**
   * Excel名称自定义
   * @param sheetName
   * @param response
   * @throws UnsupportedEncodingException
   */

  private static void resetResponse(String sheetName, HttpServletResponse response) throws UnsupportedEncodingException {
    String filename = encodingFilename(sheetName);
    FileUtils.setAttachmentResponseHeader(response, filename);
    response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=UTF-8");
  }

  public static String encodingFilename(String filename) {
    SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd");
    return sdf.format(new Date()) + filename + ".xlsx";
  }

  private ExcelUtils() {
  }
}