import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.ExcelWriter;
import com.alibaba.excel.write.metadata.WriteSheet;

import java.util.ArrayList;
import java.util.List;

public class WriteMultipleSheets {

    public static void main(String[] args) {
        String fileName = "output.xlsx";

        // 准备数据
        List<Person> groupA = new ArrayList<>();
        groupA.add(new Person("John", 30));
        List<Person> groupB = new ArrayList<>();
        groupB.add(new Person("Alice", 25));

        // 写入 Excel 文件
        try (ExcelWriter excelWriter = EasyExcel.write(fileName).build()) {
            WriteSheet sheetA = EasyExcel.writerSheet(0, "A组").head(Person.class).build();
            excelWriter.write(groupA, sheetA);

            WriteSheet sheetB = EasyExcel.writerSheet(1, "B组").head(Person.class).build();
            excelWriter.write(groupB, sheetB);
        }
    }

    // POJO 类
    public static class Person {
        private String name;
        private int age;

        // 构造函数、getter 和 setter 方法
    }
}