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 DataContext())
    {
        data.Add(db.Users.OrderBy(x => x.Name).ToList());
        data.Add(db.Orders.OrderByDescending(x => x.Date).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:

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; }

    public string Item { get; set; }

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

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

    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.

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