MVC Extensions for ClosedXML
To install ClosedXML.Extensions.Mvc for .NET Core, run the following command in the Package Manager Console
PM> Install-Package ClosedXML.Extensions.Mvc
If you're using .NET Framework, please install v0.2.2
PM> Install-Package ClosedXML.Extensions.Mvc -Version 0.2.2
In your MVC controller define an action that will generate and download your file:
private ClosedXML.Excel.XLWorkbook GenerateClosedXMLWorkbook()
{
var wb = new ClosedXML.Excel.XLWorkbook();
var ws = wb.AddWorksheet();
ws.FirstCell().SetValue("Hello world!");
ws.FirstCell().CellBelow().FormulaA1 = "RAND()";
return wb;
}
public ActionResult Download()
{
using (var wb = GenerateClosedXMLWorkbook())
{
// Add ClosedXML.Extensions in your using declarations
return wb.Deliver("generatedfile.xlsx");
// or specify the content type:
return wb.Deliver("generatedFile.xlsx", "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
}
}
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4