有些时候列表的列可能是动态的,需要根据动态表头导出excel文件,这时候可以使用下面的方法解决: public static void exportDynamicExcel(Set includeColumnFiledNam
有些时候列表的列可能是动态的,需要根据动态表头导出excel文件,这时候可以使用下面的方法解决:
public static void exportDynamicExcel(Set includeColumnFiledNames, String fileName, List list, Class clazz, httpservletResponse response) { try { ServletOutputStream os = response.getOutputStream(); response.setContentType("application/vnd.openxmlfORMats-officedocument.spreadsheetml.sheet"); response.setCharacterEncoding("utf-8"); String encodeFileName = new String(fileName.getBytes(), "ISO8859-1"); response.setContentType("application/octet-stream;charset=UTF-8"); response.setHeader("Content-Disposition", "attachment;filename=" + encodeFileName + ".xlsx"); ExcelWriterBuilder excelBuilder = EasyExcel.write(os, clazz); excelBuilder = includeColumnFiledName(includeColumnFiledNames, excelBuilder); excelBuilder.useDefaultStyle(false).sheet(fileName).doWrite(list); os.close(); } catch (IOException e) { e.printStackTrace(); } } private static ExcelWriterBuilder includeColumnFiledName(Set includeColumnFiledNames, ExcelWriterBuilder excelBuilder) { excelBuilder = excelBuilder.registerWriteHandler(new LongestMatchColumnWidthStyleStrategy()); if (includeColumnFiledNames.size() > 0) { excelBuilder = excelBuilder.includeColumnFiledNames(includeColumnFiledNames); } excelBuilder = excelBuilder.reGISterWriteHandler(new LongestMatchColumnWidthStyleStrategy()); return excelBuilder; }
静态列导出代码:
public static void exportExcel(String fileName, List list, Class clazz, HttpServletResponse response) { try { String fileNameFull = fileName + "(" + TimeUtils.getTime() + ")"; ServletOutputStream os = response.getOutputStream(); response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"); response.setCharacterEncoding("utf-8"); String encodeFileName = URLEncoder.encode(fileNameFull, "UTF-8"); response.setContentType("application/octet-stream;charset=UTF-8"); response.setHeader("Content-Disposition", "attachment;filename=" + encodeFileName + ".xlsx"); EasyExcel.write(os, clazz).useDefaultStyle(false).sheet(fileName).doWrite(list); os.close(); } catch (IOException e) { e.printStackTrace(); } }
来源地址:https://blog.csdn.net/qq_26230421/article/details/130293297
--结束END--
本文标题: Java——使用EasyExcel导出动态列的Excel
本文链接: https://www.lsjlt.com/news/401052.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-04-03
2024-04-03
2024-04-01
2024-01-21
2024-01-21
2024-01-21
2024-01-21
2023-12-23
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0