将IEnumerable <T>导出到Excel

Install-Package ClosedXML

using System.Collections.Generic;
using System.IO;
using ClosedXML.Excel;

public static class ExcelExporter
{
    public static XLWorkbook ToExcel<T>(this IEnumerable<T> items, string sheetName = "Sheet1")
    {
        var workbook = new XLWorkbook();
        var worksheet = workbook.Worksheets.Add(sheetName);

        var properties = typeof(T).GetProperties();

        // Add header row
        var headerRow = worksheet.Row(1);
        var colIndex = 1;
        foreach (var property in properties)
        {
            headerRow.Cell(colIndex).Value = property.Name;
            colIndex++;
        }

        // Add data rows
        var rowIndex = 2;
        foreach (var item in items)
        {
            var dataRow = worksheet.Row(rowIndex);
            colIndex = 1;
            foreach (var property in properties)
            {
                dataRow.Cell(colIndex).Value = property.GetValue(item);
                colIndex++;
            }
            rowIndex++;
        }

        return workbook;
    }
}

var items = new List<Person>
{
    new Person { Name = "John Doe", Age = 30 },
    new Person { Name = "Jane Doe", Age = 25 }
};

var workbook = items.ToExcel();
workbook.SaveAs("ExportedItems.xlsx");