easyExcel 复杂表头导出

import com.alibaba.excel.EasyExcel; import com.alibaba.excel.write.style.column.AbstractColumnWidthStyleStrategy; import com.alibaba.excel.write.style.column.LongestMatchColumnWidthStyleStrategy; import java.util.ArrayList; import java.util.Arrays; import java.util.List; public static void main(String[] args) { String fileName = "E:\\test\\excel2.xlsx"; // 模拟数据 List<List<String>> data = new ArrayList<>(); data.add(Arrays.asList("复杂表头1", "复杂表头2", "复杂表头3", "复杂表头4")); data.add(Arrays.asList("数据1", "数据2", "数据3", "数据4")); data.add(Arrays.asList("数据5", "数据6", "数据7", "数据8")); // 设置表头 List<List<String>> head = new ArrayList<>(); head.add(Arrays.asList("填报状态", "表头1")); head.add(Arrays.asList("填报状态", "表头2")); head.add(Arrays.asList("填报状态", "表头3")); head.add(Arrays.asList("填报状态", "表头4")); // 创建并设置自适应列宽样式 AbstractColumnWidthStyleStrategy columnWidthStyleStrategy = new LongestMatchColumnWidthStyleStrategy(); // 写入Excel EasyExcel.write(fileName) .head(head) .registerWriteHandler(columnWidthStyleStrategy) .sheet("Sheet1") .doWrite(data); } }