OpenXML Sax 方法快速将 100K+ 行导出到 Excel

使用OpenXML Sax方法可以快速将包含100K+行数据的文件导出到Excel。OpenXML是一种用于处理Office文档的开放式标准，它提供了一组API和工具，可以让我们直接操作Office文档的内部结构，而无需依赖于安装Office软件。

csharp
using (SpreadsheetDocument document = SpreadsheetDocument.Create("output.xlsx", SpreadsheetDocumentType.Workbook))
{
    WorkbookPart workbookPart = document.AddWorkbookPart();
    workbookPart.Workbook = new Workbook();
    WorksheetPart worksheetPart = workbookPart.AddNewPart();
    worksheetPart.Worksheet = new Worksheet(new SheetData());
    Sheets sheets = workbookPart.Workbook.AppendChild(new Sheets());
    Sheet sheet = new Sheet() { Id = workbookPart.GetIdOfPart(worksheetPart), SheetId = 1, Name = "Sheet1" };
    sheets.Append(sheet);
    SheetData sheetData = worksheetPart.Worksheet.GetFirstChild();
    for (int i = 1; i <= 100000; i++)
    {
        Row row = new Row();
        Cell cell1 = new Cell();
        CellValue cellValue1 = new CellValue(i.ToString());
        cell1.Append(cellValue1);
        row.Append(cell1);
        sheetData.Append(row);
    }
    workbookPart.Workbook.Save();
    document.Close();
}

csharp
using (SpreadsheetDocument document = SpreadsheetDocument.Create("output.xlsx", SpreadsheetDocumentType.Workbook))
{
    // 创建WorkbookPart和WorksheetPart
    WorkbookPart workbookPart = document.AddWorkbookPart();
    workbookPart.Workbook = new Workbook();
    WorksheetPart worksheetPart = workbookPart.AddNewPart();
    worksheetPart.Worksheet = new Worksheet(new SheetData());
    // 创建Sheets和Sheet
    Sheets sheets = workbookPart.Workbook.AppendChild(new Sheets());
    Sheet sheet = new Sheet() { Id = workbookPart.GetIdOfPart(worksheetPart), SheetId = 1, Name = "Sheet1" };
    sheets.Append(sheet);
    SheetData sheetData = worksheetPart.Worksheet.GetFirstChild();
    // 生成数据行
    for (int i = 1; i <= 100000; i++)
    {
        Row row = new Row();
        Cell cell1 = new Cell();
        CellValue cellValue1 = new CellValue(i.ToString());
        cell1.Append(cellValue1);
        row.Append(cell1);
        sheetData.Append(row);
    }
    // 保存文档
    workbookPart.Workbook.Save();
    document.Close();
}