从DTO在C#中使用OpenXML写入单元格

using DocumentFormat.OpenXml;
using DocumentFormat.OpenXml.Packaging;
using DocumentFormat.OpenXml.Spreadsheet;

// 创建Excel文档
using (SpreadsheetDocument document = SpreadsheetDocument.Create("Sample.xlsx", SpreadsheetDocumentType.Workbook))
{
    // 添加Workbook部分
    WorkbookPart workbookPart = document.AddWorkbookPart();
    workbookPart.Workbook = new Workbook();

    // 添加Worksheet部分
    WorksheetPart worksheetPart = workbookPart.AddNewPart<WorksheetPart>();
    worksheetPart.Worksheet = new Worksheet(new SheetData());

    // 添加Sheet部分
    Sheets sheets = workbookPart.Workbook.AppendChild(new Sheets());
    Sheet sheet = new Sheet() { Id = workbookPart.GetIdOfPart(worksheetPart), SheetId = 1, Name = "Sheet1" };
    sheets.Append(sheet);

    // 保存文档
    workbookPart.Workbook.Save();
}

// 打开Excel文档
using (SpreadsheetDocument document = SpreadsheetDocument.Open("Sample.xlsx", true))
{
    // 获取Worksheet部分
    WorksheetPart worksheetPart = document.WorkbookPart.WorksheetParts.First();
    SheetData sheetData = worksheetPart.Worksheet.GetFirstChild<SheetData>();

    // 创建行和单元格
    Row row = new Row();
    Cell cell = new Cell();

    // 设置单元格值
    cell.DataType = CellValues.String;
    cell.CellValue = new CellValue("Hello World");

    // 将单元格添加到行
    row.Append(cell);

    // 将行添加到SheetData
    sheetData.Append(row);

    // 保存文档
    worksheetPart.Worksheet.Save();
}