import com.alibaba.excel.ExcelWriter;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.write.builder.ExcelWriterBuilder;
import com.alibaba.excel.write.metadata.WriteSheet;
import org.apache.poi.ss.usermodel.HorizontalAlignment;
import org.apache.poi.ss.usermodel.VerticalAlignment;

import java.io.FileOutputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

public class ExcelExport {

    public static void main(String[] args) {
        // 创建测试数据
        List<TestData> dataList = generateTestData(50000);

        // 导出Excel
        exportExcel(dataList, "output.xlsx");
    }

    public static void exportExcel(List<TestData> dataList, String fileName) {
        try (FileOutputStream outputStream = new FileOutputStream(fileName)) {
            ExcelWriterBuilder writerBuilder = new ExcelWriterBuilder();
            ExcelWriter excelWriter = writerBuilder.file(outputStream).build();

            WriteSheet writeSheet = new WriteSheet();
            writeSheet.setSheetName("Sheet1");

            // 设置表头样式
            writeSheet.setHead(null);
            writeSheet.setHorizontalCellStyle(null);

            // 写入数据
            excelWriter.write(dataList, writeSheet);
            excelWriter.finish();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    public static List<TestData> generateTestData(int rowCount) {
        List<TestData> dataList = new ArrayList<>();
        for (int i = 0; i < rowCount; i++) {
            TestData testData = new TestData();
            testData.setId(i);
            testData.setName("Name " + i);
            testData.setValue("Value " + i);
            // 添加其他字段...
            dataList.add(testData);
        }
        return dataList;
    }

    public static class TestData {
        @ExcelProperty(index = 0)
        private Long id;

        @ExcelProperty(index = 1)
        private String name;

        @ExcelProperty(index = 2)
        private String value;

        // 其他字段...

        // 省略 getter 和 setter 方法
    }
}