ClosedXML.Extensions.AspNet

ASP.NET Extensions for ClosedXML

Install via NuGet

To install ClosedXML.Extensions.AspNet, run the following command in the Package Manager Console

PM> Install-Package ClosedXML.Extensions.AspNet

Usage

There are two extension methods: one for HttpResponse and one for XLWorkbook. Both deliver the relevant ClosedXML workbook to the response stream.

using (var wb = GenerateClosedXMLWorkbook())
{
    var response = this.Response;
    response.DeliverWorkbook(wb, "generatedFile.xlsx");
    
    // or specify the content type:
    response.DeliverWorkbook(wb, "generatedFile.xlsx", "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
}

or

using (var wb = GenerateClosedXMLWorkbook())
{
    wb.DeliverToHttpResponse(this.Response, "generatedFile.xlsx");
    
    // or specify the content type:
    wb.DeliverToHttpResponse(this.Response, "generatedFile.xlsx", "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
}