Using EPPlus-Core to Export Excel Documents in .NET Core (C#)

First, install

Just install it via NuGet, super convenient.

How to use

There are many ways to export; this article only covers the most convenient one with the least code.

First, define an entity class, for example:

public class OutputData {
    public string Address { get; set; }
    public int Title { get; set; }
    public int Description { get; set; }
    public int Keywords { get; set; }
    public int Content { get; set; }
    public int Score { get; set; }
}

Then just pass a list of type OutputData and you can output an Excel file.

private static void ExportExcel(IEnumerable<OutputData> results) {
    using var package = new ExcelPackage();
    var worksheet = package.Workbook.Worksheets.Add("结果导出");
    worksheet.Cells.LoadFromCollection(results, true);
    package.SaveAs(new FileStream("output.xlsx", FileMode.Create));
}

Note: The second parameter of worksheet.Cells.LoadFromCollection() indicates outputting the header~

References

• Project homepage: https://github.com/EPPlusSoftware/EPPlus
• https://my.oschina.net/u/4380330/blog/3413607