OpenXML - 如何将电子表格文档保存到流中

OpenXML - 如何将电子表格文档保存到流中？

csharp
using DocumentFormat.OpenXml;
using DocumentFormat.OpenXml.Packaging;
using DocumentFormat.OpenXml.Spreadsheet;
using System.IO;
public class ExcelWriter
{
    public void SaveToStream(Stream stream)
    {
        // 创建一个空的电子表格文档
        var spreadsheetDocument = SpreadsheetDocument.Create(stream, SpreadsheetDocumentType.Workbook);
        // 添加一个工作簿部件
        var workbookPart = spreadsheetDocument.AddWorkbookPart();
        workbookPart.Workbook = new Workbook();
        // 添加一个工作表部件
        var worksheetPart = workbookPart.AddNewPart();
        worksheetPart.Worksheet = new Worksheet(new SheetData());
        // 添加数据和格式到工作表部件
        var sheetData = worksheetPart.Worksheet.GetFirstChild();
        
        // 添加表头
        var row = new Row();
        row.Append(new Cell() { CellValue = new CellValue("姓名"), DataType = CellValues.String });
        row.Append(new Cell() { CellValue = new CellValue("年龄"), DataType = CellValues.Number });
        sheetData.AppendChild(row);
        
        // 添加数据行
        row = new Row();
        row.Append(new Cell() { CellValue = new CellValue("张三"), DataType = CellValues.String });
        row.Append(new Cell() { CellValue = new CellValue("25"), DataType = CellValues.Number });
        sheetData.AppendChild(row);
        // 保存文档到流中
        spreadsheetDocument.Save();
        // 关闭文档
        spreadsheetDocument.Close();
    }
}