将大型(>500000行)数据集导出到xlsx

import pandas as pd

# 假设数据集存储在DataFrame对象df中
df.to_excel('output.xlsx', index=False)

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

// 假设数据集存储在Workbook对象workbook中
Workbook workbook = new XSSFWorkbook();
Sheet sheet = workbook.createSheet("Sheet1");

// 假设数据集存储在二维数组data中
for (int i = 0; i < data.length; i++) {
    Row row = sheet.createRow(i);
    for (int j = 0; j < data[i].length; j++) {
        Cell cell = row.createCell(j);
        cell.setCellValue(data[i][j]);
    }
}

// 将Workbook对象写入xlsx文件
try (FileOutputStream outputStream = new FileOutputStream("output.xlsx")) {
    workbook.write(outputStream);
}