// 在導(dǎo)出工具類中設(shè)置
Workbook workbook = new SXSSFWorkbook(100); // 保留100行在內(nèi)存
Sheet sheet = workbook.createSheet("大數(shù)據(jù)報(bào)表");

public class BigDataExporter implements IExcelExportServer {
    @Override
    public List<Object> selectListForExcelExport(Object queryParams, int pageNo) {
        // 分頁查詢邏輯
        PageHelper.startPage(pageNo, 50000);
        return dataMapper.selectByCondition(queryParams);
    }
}

@Async
public CompletableFuture<String> asyncExport() {
    // 生成臨時(shí)文件
    File tempFile = File.createTempFile("export_", ".xlsx");
    Workbook workbook = ExcelExportUtil.exportBigExcel(...);
    FileOutputStream fos = new FileOutputStream(tempFile);
    workbook.write(fos);
    fos.close();
    return CompletableFuture.completedFuture(tempFile.getAbsolutePath());
}

# 內(nèi)存配置
-Xms4g -Xmx8g -XX:MaxMetaspaceSize=512m
# GC策略
-XX:+UseG1GC -XX:MaxGCPauseMillis=200

# 導(dǎo)出配置
easypoi.export.buffer-size=1048576  # 1MB緩沖區(qū)
easypoi.export.compressed=true      # 啟用壓縮
easypoi.export.auto-flush=true      # 自動(dòng)刷新緩沖區(qū)

@GetMapping("/export")
public void exportBigData(HttpServletResponse response) {
    ExportParams params = new ExportParams();
    params.setType(ExcelType.XSSF);  // 或 SXSSF
    params.setStyle(ExcelExportStylerImpl.class);  // 自定義樣式
    
    IExcelExportServer server = new BigDataExporter();
    Workbook workbook = ExcelExportUtil.exportBigExcel(params, DataEntity.class, server, queryParams);
    
    response.setHeader("Content-Disposition", "attachment;filename=report.xlsx");
    workbook.write(response.getOutputStream());
    ((SXSSFWorkbook) workbook).dispose();  // 清理臨時(shí)文件
}

public class MultiSheetExporter {
    public Workbook export(List<PageData> dataPages) {
        Workbook workbook = new SXSSFWorkbook();
        int sheetCount = dataPages.size();
        
        for (int i=0; i<sheetCount; i++) {
            Sheet sheet = workbook.createSheet("Sheet" + (i+1));
            List<DataEntity> pageData = dataPages.get(i);
            // 寫入表頭
            Row header = sheet.createRow(0);
            // 寫入數(shù)據(jù)
            int rowNum = 1;
            for (DataEntity entity : pageData) {
                Row row = sheet.createRow(rowNum++);
                // 填充單元格
            }
        }
        return workbook;
    }
}

FileChannel channel = new RandomAccessFile("temp.xlsx", "rw").getChannel();
MappedByteBuffer buffer = channel.map(FileChannel.MapMode.READ_WRITE, 0, 1024 * 1024 * 100);

response.setHeader("Content-Length", String.valueOf(file.length()));
FileChannel fileChannel = new FileInputStream(file).getChannel();
WritableByteChannel outChannel = Channels.newChannel(response.getOutputStream());
fileChannel.transferTo(0, fileChannel.size(), outChannel);