用netcore语言写一个Excel导出功能

以下是一个使用.NET Core语言编写的Excel导出功能的示例代码：

using OfficeOpenXml;
using System;
using System.Collections.Generic;
using System.IO;

public class ExcelExporter
{
    public void ExportToExcel(List<Person> persons, string filePath)
    {
        using (var package = new ExcelPackage())
        {
            var worksheet = package.Workbook.Worksheets.Add("Sheet1");

            // 设置表头
            worksheet.Cells[1, 1].Value = "姓名";
            worksheet.Cells[1, 2].Value = "年龄";
            worksheet.Cells[1, 3].Value = "性别";

            // 填充数据
            for (int i = 0; i < persons.Count; i++)
            {
                worksheet.Cells[i + 2, 1].Value = persons[i].Name;
                worksheet.Cells[i + 2, 2].Value = persons[i].Age;
                worksheet.Cells[i + 2, 3].Value = persons[i].Gender;
            }

            // 自动调整列宽
            worksheet.Cells.AutoFitColumns();

            // 保存Excel文件
            FileInfo file = new FileInfo(filePath);
            package.SaveAs(file);
        }
    }
}

public class Person
{
    public string Name { get; set; }
    public int Age { get; set; }
    public string Gender { get; set; }
}

使用示例：

var persons = new List<Person>
{
    new Person { Name = "张三", Age = 20, Gender = "男" },
    new Person { Name = "李四", Age = 25, Gender = "女" },
    new Person { Name = "王五", Age = 30, Gender = "男" }
};

var exporter = new ExcelExporter();
exporter.ExportToExcel(persons, "output.xlsx");

上述代码使用了EPPlus库来处理Excel文件的导出。首先创建一个ExcelPackage对象，然后在其中创建一个工作表，并设置表头。接着遍历数据列表，将数据填充到工作表中。最后调用SaveAs方法保存Excel文件