easyexcel动态表头

<code class="java">import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.ExcelWriter;
import com.alibaba.excel.write.builder.ExcelWriterSheetBuilder;
import org.apache.poi.ss.usermodel.FillPatternType;
import org.apache.poi.ss.usermodel.IndexedColors;
import org.apache.poi.ss.usermodel.Row;

import java.util.List;

public class DynamicHeaderExample {

    public static void main(String[] args) {
        // 创建工作簿
        ExcelWriter writer = EasyExcel.write("dynamic_header.xlsx").build();
        ExcelWriterSheetBuilder sheetBuilder = writer.sheet();

        // 设置表头样式
        sheetBuilder.head(new String[]{"序号", "姓名", "年龄"},
                header -> header.fill(FillPatternType.SOLID_FOREGROUND, IndexedColors.LIGHT_YELLOW));

        // 写入数据
        sheetBuilder.doWrite(List.of(
                new Data("1", "张三", 20),
                new Data("2", "李四", 25),
                new Data("3", "王五", 30)
        ));

        // 关闭工作簿
        writer.finish();
    }

    public static class Data {
        private String id;
        private String name;
        private int age;

        public Data(String id, String name, int age) {
            this.id = id;
            this.name = name;
            this.age = age;
        }

        // getters and setters
    }
}</code>