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();// 写入ExcelEasyExcel.write(fileName).head(head).registerWriteHandler(columnWidthStyleStrategy).sheet("Sheet1").doWrite(data);}
}

效果图

https://www.baidu.com/s?wd=easyexcel%20%E5%A4%8D%E6%9D%82%E8%A1%A8%E5%A4%B4&rsv_spt=1&rsv_iqid=0x8e01b40100168b4b&issp=1&f=8&rsv_bp=1&rsv_idx=2&ie=utf-8&tn=57095150_7_oem_dg&rsv_enter=1&rsv_dl=tb&rsv_sug3=23&rsv_sug1=21&rsv_sug7=100&rsv_sug2=0&rsv_btype=i&prefixsug=easyexcel%2520%25E5%25A4%258D%25E6%259D%2582%25E8%25A1%25A8%25E5%25A4%25B4&rsp=4&inputT=7789&rsv_sug4=10211