EasyExcel 是阿里巴巴的一个基于Java的简单方便省内存的读写Excel开源项目。
常用方法,见官方文档:https://easyexcel.opensource.alibaba.com/docs/current/
下面介绍,Alibaba EasyExcel:多Sheet操作,不同Sheet注册不同样式执行器版本 2.2.6+
一、构建 ExcelWriter 对象,用来添加Sheet,及结束操作:
ExcelWriterBuilder excelWriterBuilder = EasyExcel.write(response.getOutputStream());
excelWriterBuilder.registerWriteHandler(。。。);
excelWriterBuilder.registerWriteHandler(。。。);
ExcelWriter excelWriter = excelWriterBuilder.build();
二、构建 Sheet 对象 WriteSheet:
List<List<String>> head = Lists.newArrayList(
Lists.newArrayList("序号"),
Lists.newArrayList("名称"),
Lists.newArrayList("联系人"),
Lists.newArrayList("手机号"),
Lists.newArrayList("性别"),
Lists.newArrayList("年龄"));
ExcelWriterSheetBuilder excelWriterSheetBuilder = EasyExcel.writerSheet(0, "sheetName");
三、可以通过 ExcelWriterSheetBuilder 对象为每个Sheet单独注册 样式格式执行器:
excelWriterSheetBuilder.registerWriteHandler(。。。);
excelWriterSheetBuilder.registerWriteHandler(。。。);
excelWriterSheetBuilder.registerWriteHandler(。。。);
四、构建 Sheet 对象,并写入:
WriteSheet writeSheet = excelWriterSheetBuilder.head(head).build();
excelWriter.write(data, writeSheet);
五、完成并输出文件流:
excelWriter.finish();
注:其中 二、三、四,可以循环操作,写入多个Sheet。