Java——使用EasyExcel导出动态列的Excel

有些时候列表的列可能是动态的，需要根据动态表头导出Excel文件，这时候可以使用下面的方法解决：

1.  
   /**
2.  
   * 使用EasyExcel导出动态Excel
3.  
   * @param includeColumnFiledNames
4.  
   * @param fileName
5.  
   * @param list
6.  
   * @param clazz
7.  
   * @param response
8.  
   */
9.  
   public static void exportDynamicExcel(Set<String> includeColumnFiledNames, String fileName, List list, Class clazz, HttpServletResponse response) {
10.  
    try {
11.  
    ServletOutputStream os = response.getOutputStream();
12.  
    response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
13.  
    response.setCharacterEncoding("utf-8");
14.  
    String encodeFileName = new String(fileName.getBytes(), "ISO8859-1");
15.  
    response.setContentType("application/octet-stream;charset=UTF-8");
16.  
    response.setHeader("Content-Disposition", "attachment;filename=" encodeFileName ".xlsx");
17.  
     
18.  
    ExcelWriterBuilder excelBuilder = EasyExcel.write(os, clazz);
19.  
    excelBuilder = includeColumnFiledName(includeColumnFiledNames, excelBuilder);
20.  
    excelBuilder.useDefaultStyle(false).sheet(fileName).doWrite(list);
21.  
    os.close();
22.  
    } catch (IOException e) {
23.  
    e.printStackTrace();
24.  
    }
25.  
    }
26.  
     
27.  
    private static ExcelWriterBuilder includeColumnFiledName(Set<String> includeColumnFiledNames, ExcelWriterBuilder excelBuilder) {
28.  
    excelBuilder = excelBuilder.registerWriteHandler(new LongestMatchColumnWidthStyleStrategy());
29.  
    if (includeColumnFiledNames.size() > 0) {
30.  
    excelBuilder = excelBuilder.includeColumnFiledNames(includeColumnFiledNames);
31.  
    }
32.  
    excelBuilder = excelBuilder.registerWriteHandler(new LongestMatchColumnWidthStyleStrategy());
33.  
    return excelBuilder;
34.  
    }

扩展

静态列导出代码：

1.  
   /**
2.  
   * 使用EasyExcel导出Excel
3.  
   */
4.  
   public static void exportExcel(String fileName, List list, Class clazz, HttpServletResponse response) {
5.  
   try {
6.  
   String fileNameFull = fileName "(" TimeUtils.getTime() ")";
7.  
   ServletOutputStream os = response.getOutputStream();
8.  
   response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
9.  
   response.setCharacterEncoding("utf-8");
10.  
    String encodeFileName = URLEncoder.encode(fileNameFull, "UTF-8");
11.  
    response.setContentType("application/octet-stream;charset=UTF-8");
12.  
    response.setHeader("Content-Disposition", "attachment;filename=" encodeFileName ".xlsx");
13.  
    EasyExcel.write(os, clazz).useDefaultStyle(false).sheet(fileName).doWrite(list);
14.  
    os.close();
15.  
    } catch (IOException e) {
16.  
    e.printStackTrace();
17.  
    }
18.  
    }

这篇好文章是转载于：学新通技术网