ClosedXML.Extensions.Mvc

MVC Extensions forClosedXML

Install via NuGet

To install ClosedXML.Extensions.Mvc for.NET Core, run the following command in the Package Manager Console

PM>Install-PackageClosedXML.Extensions.Mvc

If you're using.NET Framework, please install v0.2.2

PM>Install-PackageClosedXML.Extensions.Mvc-Version0.2.2

Usage

In your MVC controller define an action that will generate and download your file:

privateClosedXML.Excel.XLWorkbookGenerateClosedXMLWorkbook()
{
varwb=newClosedXML.Excel.XLWorkbook();
varws=wb.AddWorksheet();
ws.FirstCell().SetValue("Hello world!");
ws.FirstCell().CellBelow().FormulaA1="RAND()";
returnwb;
}

publicActionResultDownload()
{
using(varwb=GenerateClosedXMLWorkbook())
{
// Add ClosedXML.Extensions in your using declarations

returnwb.Deliver("generatedfile.xlsx");

// or specify the content type:
returnwb.Deliver("generatedFile.xlsx","application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
}
}