import com.alibaba.excel.ExcelWriter;
import com.alibaba.excel.metadata.Sheet;
import com.alibaba.excel.support.ExcelTypeEnum;

import java.io.OutputStream;
import java.util.List;

public class ExcelExportService {

    public void exportData(List<MyData> dataList, OutputStream outputStream, boolean useStreamChunkedResponse) {
        // 创建ExcelWriter
        ExcelWriter excelWriter = new ExcelWriter(outputStream, ExcelTypeEnum.XLSX, useStreamChunkedResponse);

        // 定义Sheet
        Sheet sheet = new Sheet(1, 0, MyData.class);

        // 写入数据
        excelWriter.write(dataList, sheet);

        // 结束写入
        excelWriter.finish();
    }
}