easyExcel 动态列以及自适应列宽的实现步骤
1.在pom.xml文件中添加依赖
<!-- excel导出工具 -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>2.2.0-beta2</version>
</dependency>
2.创建EasyExcelUtils工具类;
这里主要是通过反射的方式获取动态的列名对应的数据;
public class EasyExcelUtils {
private static final Logger logger = LoggerFactory.getLogger(EasyExcelUtils.class);
public static void noModelWrite(String fileName, String sheetName, List data, List<String> headList, List<String> fileList){
EasyExcel.write(fileName).head(head(headList)).registerWriteHandler(new CustomCellWriteHandler()).sheet(sheetName).doWrite(dataList(data,fileList));
}
private static List<List<String>> head(List<String> headList) {
List<List<String>> list = new ArrayList<>();
for (String value : headList) {
List<String> head = new ArrayList<>();
head.add(value);
list.add(head);
}
return list;
}
private static List<List<Object>> dataList(List