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

using DocumentFormat.OpenXml;
using DocumentFormat.OpenXml.Packaging;
using DocumentFormat.OpenXml.Spreadsheet;
using System.IO;

public class EmployeeDTO
{
    public string Name { get; set; }
    public int Age { get; set; }
    public string Position { get; set; }
}

public void WriteEmployeeDataToExcel(List<EmployeeDTO> employees, string filePath)
{
    using (var spreadsheetDocument = SpreadsheetDocument.Create(filePath, SpreadsheetDocumentType.Workbook))
    {
        var workbookPart = spreadsheetDocument.AddWorkbookPart();
        workbookPart.Workbook = new Workbook();

        var worksheetPart = workbookPart.AddNewPart<WorksheetPart>();
        var sheetData = new SheetData();
        worksheetPart.Worksheet = new Worksheet(sheetData);

        var sheets = spreadsheetDocument.WorkbookPart.Workbook.AppendChild(new Sheets());
        sheets.Append(new Sheet()
        {
            Id = spreadsheetDocument.WorkbookPart.GetIdOfPart(worksheetPart),
            SheetId = 1,
            Name = "Employees"
        });

        var headerRow = new Row();
        headerRow.Append(new Cell() { DataType = CellValues.String, CellValue = new CellValue("Name") });
        headerRow.Append(new Cell() { DataType = CellValues.String, CellValue = new CellValue("Age") });
        headerRow.Append(new Cell() { DataType = CellValues.String, CellValue = new CellValue("Position") });
        sheetData.Append(headerRow);

        foreach (var employee in employees)
        {
            var row = new Row();
            row.Append(new Cell() { DataType = CellValues.String, CellValue = new CellValue(employee.Name) });
            row.Append(new Cell() { DataType = CellValues.Number, CellValue = new CellValue(employee.Age.ToString()) });
            row.Append(new Cell() { DataType = CellValues.String, CellValue = new CellValue(employee.Position) });
            sheetData.Append(row);
        }
    }
}

// 使用流式处理的示例代码较为复杂，需要使用OpenXML的Streaming API。
// 这里仅提供一个概念性的解决方案，具体实现需要参考OpenXML的官方文档。