EPPlusEnumerable 5.0.0

Easily create multi-worksheet Excel documents from any .NET object collection.

Install-Package EPPlusEnumerable -Version 5.0.0
dotnet add package EPPlusEnumerable --version 5.0.0
<PackageReference Include="EPPlusEnumerable" Version="5.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add EPPlusEnumerable --version 5.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

EPPlusEnumerable

Easily create multi-worksheet Excel documents from any .NET object collection.

Usage

Let's say you're working on an ASP.NET web app and want to create a report of all users and orders.

public ActionResult DownloadReport()
{
    var data = new List<IEnumerable<object>>();
    
    using (var db = new SampleDataContext())
    {
        data.Add(db.Users.OrderBy(x => x.Name).ToList());

        foreach(var grouping in db.Orders.OrderBy(x => x.Date).GroupBy(x => x.Date.Month))
        {
            data.Add(grouping.ToList());
        }
    }
    
    var bytes = Spreadsheet.Create(data);
    return File(bytes, "application/vnd.ms-excel", "MySpreadsheet.xlsx");
}

That will give you a nicely-formatted Excel spreadsheet with tabs for both "Users" and "Orders," like so:

output

There's also a SpreadsheetLinkAttribute class which you can use to generate links between tabs on your spreadsheet.

[DisplayName("Orders"), SpreadsheetTableStyle(TableStyles.Medium16)]
public class Order
{
    public int Number { get; set; }

    [SpreadsheetCellStyle(bold: true, backgroundHtmlColor: "#00cc00", fontHtmlColor: "lime")]
    public string Item { get; set; }

    [SpreadsheetLink("Customers", "Name")]
    public string Customer { get; set; }

    [DisplayFormat(DataFormatString = "{0:c}")]
    public decimal Price { get; set; }

    [SpreadsheetTabName(FormatString = "{0:MMMM yyyy}")]
    public DateTime Date { get; set; }
}

In this example, the "Customer" values in the Orders tab will be linked to the corresponding Customers tab row where the Name is equal to the value of the Order object's Customer property.

In addition, the SpreadsheetTabName attribute specifies that the value of the given property should be used to name the tab in Excel. The first value of the collection will be used to generate the name of the tab. You can optionally specify a FormatString as above.

links

There's also a SpreadsheetExclude attribute you can use if you don't want to include a column for a given property in the generated spreadsheet.

P.S. DisplayName or Display(Name=&quot;&quot;) attributes will be used for worksheet names if used on the class, or column headers if used on a property.

EPPlusEnumerable

Easily create multi-worksheet Excel documents from any .NET object collection.

Usage

Let's say you're working on an ASP.NET web app and want to create a report of all users and orders.

public ActionResult DownloadReport()
{
    var data = new List<IEnumerable<object>>();
    
    using (var db = new SampleDataContext())
    {
        data.Add(db.Users.OrderBy(x => x.Name).ToList());

        foreach(var grouping in db.Orders.OrderBy(x => x.Date).GroupBy(x => x.Date.Month))
        {
            data.Add(grouping.ToList());
        }
    }
    
    var bytes = Spreadsheet.Create(data);
    return File(bytes, "application/vnd.ms-excel", "MySpreadsheet.xlsx");
}

That will give you a nicely-formatted Excel spreadsheet with tabs for both "Users" and "Orders," like so:

output

There's also a SpreadsheetLinkAttribute class which you can use to generate links between tabs on your spreadsheet.

[DisplayName("Orders"), SpreadsheetTableStyle(TableStyles.Medium16)]
public class Order
{
    public int Number { get; set; }

    [SpreadsheetCellStyle(bold: true, backgroundHtmlColor: "#00cc00", fontHtmlColor: "lime")]
    public string Item { get; set; }

    [SpreadsheetLink("Customers", "Name")]
    public string Customer { get; set; }

    [DisplayFormat(DataFormatString = "{0:c}")]
    public decimal Price { get; set; }

    [SpreadsheetTabName(FormatString = "{0:MMMM yyyy}")]
    public DateTime Date { get; set; }
}

In this example, the "Customer" values in the Orders tab will be linked to the corresponding Customers tab row where the Name is equal to the value of the Order object's Customer property.

In addition, the SpreadsheetTabName attribute specifies that the value of the given property should be used to name the tab in Excel. The first value of the collection will be used to generate the name of the tab. You can optionally specify a FormatString as above.

links

There's also a SpreadsheetExclude attribute you can use if you don't want to include a column for a given property in the generated spreadsheet.

P.S. DisplayName or Display(Name=&quot;&quot;) attributes will be used for worksheet names if used on the class, or column headers if used on a property.

Release Notes

- Targets .NET Standard 2.0
- Supports EPPlus 5.x
- Breaking change: removes support for MetadataTypeAttributes as they are not part of .NET Standard 2.0

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
5.0.0 2,523 3/28/2020
1.5.1 7,811 11/18/2019
1.5.0 128 11/17/2019
1.4.0.2 23,013 7/22/2016
1.4.0.1 4,570 4/7/2016
1.4.0 1,773 12/16/2015
1.3.4.1 1,806 8/21/2015
1.3.4 3,276 5/11/2015
1.3.3 447 5/11/2015
1.3.2 453 5/11/2015
1.3.1 480 5/11/2015
1.3.0 570 5/4/2015
1.2.0 891 4/14/2015
1.1.0 1,372 3/20/2015
1.0.0 1,798 1/21/2015