@Data
@EqualsAndHashCode
public class FillData {@ExcelProperty(value = "姓名", index = 0)private String name;@ExcelProperty(value = "数值", index = 1)private double number;@ExcelProperty(value = "日期", index = 2)private Date date;
}

package com.syfpc.common.utils.gxfc;import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.ExcelWriter;
import com.alibaba.excel.util.MapUtils;
import com.alibaba.excel.write.builder.ExcelWriterBuilder;
import com.alibaba.excel.write.metadata.WriteSheet;
import com.alibaba.excel.write.metadata.fill.FillConfig;import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;public class ExcelFillUtil {public static void main(String[] args) {// useTemplate();complexFillSimpleNew();}/*** 填充模板2的例子.*/public static void complexFillSimpleNew() {String templateFileName = "D:\\template1.xlsx";String outputFileName = "D:\\templateOut1.xlsx";//定义list数据List<FillData> yourDataList = new ArrayList<>();for (int i = 0; i < 10; i++) {yourDataList.add(dataNew());}//定义map数据Map<String, Object> map = MapUtils.newHashMap();map.put("projectName", "2019年10月9日13:28:28");map.put("subName", 1000);complexFillNew(templateFileName,outputFileName,yourDataList,map);}public static void complexFillNew(String templateFileName, String outputFileName, List<FillData> yourDataList,  Map<String, Object> map) {//定义excel写builderExcelWriterBuilder excelWriterBuilder = EasyExcel.write(outputFileName, FillData.class).withTemplate(templateFileName);//定义excelWriterExcelWriter excelWriter = excelWriterBuilder.build();//定义writeSheetWriteSheet writeSheet = excelWriterBuilder.sheet().build();//定义填充配置FillConfig fillConfig = FillConfig.builder().forceNewRow(Boolean.TRUE).build();//写map数据excelWriter.fill(map, fillConfig, writeSheet);//写list数据excelWriter.fill(yourDataList, fillConfig, writeSheet);//关闭写入excelWriter.finish();}/*** 填充模板1的例子** @since 2.1.1*/public static void complexFill() {// 模板注意 用{} 来表示你要用的变量 如果本来就有"{","}" 特殊字符 用"\{","\}"代替// {} 代表普通变量 {.} 代表是list的变量String templateFileName = "D:\\template.xlsx";String fileName = "D:\\aa_" + System.currentTimeMillis() + ".xlsx";// 方案1try (ExcelWriter excelWriter = EasyExcel.write(fileName).withTemplate(templateFileName).build()) {WriteSheet writeSheet = EasyExcel.writerSheet().build();// 这里注意 入参用了forceNewRow 代表在写入list的时候不管list下面有没有空行 都会创建一行，然后下面的数据往后移动。默认 是false，会直接使用下一行，如果没有则创建。// forceNewRow 如果设置了true,有个缺点 就是他会把所有的数据都放到内存了，所以慎用// 简单的说 如果你的模板有list,且list不是最后一行，下面还有数据需要填充 就必须设置 forceNewRow=true 但是这个就会把所有数据放到内存 会很耗内存// 如果数据量大 list不是最后一行 参照下一个FillConfig fillConfig = FillConfig.builder().forceNewRow(Boolean.TRUE).build();excelWriter.fill(dataNew(), fillConfig, writeSheet);excelWriter.fill(dataNew(), fillConfig, writeSheet);Map<String, Object> map = MapUtils.newHashMap();map.put("projectName", "2019年10月9日13:28:28");map.put("subName", 1000);excelWriter.fill(map, writeSheet);}}private static FillData dataNew() {FillData fillData = new FillData();fillData.setName("张三"+Math.random());fillData.setNumber(5.2);fillData.setDate(new Date());return fillData;}/*** 简单列子*/public static void simpleFill( List<FillData> yourDataList) {String templateFileName = "你的模板文件路径.xlsx";String outputFileName = "输出文件的路径.xlsx";EasyExcel.write(outputFileName, FillData.class).withTemplate(templateFileName).sheet().doWrite(yourDataList);}
}