EPPlus - 用于 .NET 的 Excel 电子表格

var file = new FileInfo(@"D:\gdhu\personalgit\dotnetdev\excel\ExcelDemo\test.xlsx");
var people = GetSetupData();
await SaveExcelFile(people, file);
static List<PersonModel> GetSetupData(){    List<PersonModel> output = new()    {        new() { Id = 1, FirstName = "Tim", LastName = "Corey" },        new() { Id = 2, FirstName = "Sue", LastName = "Storm" },        new() { Id = 3, FirstName = "Jane", LastName = "Smith" },    };    return output;}
static async Task SaveExcelFile(List<PersonModel> people, FileInfo file){    DeleteIfExists(file);
    //using (var package = new ExcelPackage())    //{
    //}// dispose
    // 在方法的结尾会调用 dispose    using var package = new ExcelPackage(file);
    // work sheet    var ws = package.Workbook.Worksheets.Add("MainReport");
    //var range = ws.Cells["A1"].LoadFromCollection(people, true);
    var range = ws.Cells["A2"].LoadFromCollection(people, true);
    // width height    range.AutoFitColumns();

    ws.Cells["A1"].Value = "Our cool Report";    ws.Cells["A1:C1"].Merge = true;
    ws.Column(1).Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
    ws.Row(1).Style.Font.Size = 24;    ws.Row(1).Style.Font.Color.SetColor(Color.Blue);
    ws.Column(2).Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;    ws.Column(2).Style.Font.Bold = true;
    ws.Column(3).Width = 30;
    // work sheet    var wsDetail = package.Workbook.Worksheets.Add("Detail");
    range = wsDetail.Cells["A2"].LoadFromCollection(people, true);
    await package.SaveAsync();
}