// GET: Report
public ActionResult CreateReport(string reportName = "Report")
{
XLWorkbook workbook = _reportingService.GenerateExcelReport(reportName);
string handle = Guid.NewGuid().ToString();
byte[] xlsInBytes;
using (MemoryStream memoryStream = new MemoryStream())
{
workbook.SaveAs(memoryStream);
memoryStream.Position = 0;
xlsInBytes = memoryStream.ToArray();
}
return(File(xlsInBytes, "application/vnd.ms-excel", $"Report.xlsx"));
}
public ActionResult SaveReport(ReportDto reportDto)
{
XLWorkbook workbook = _reporting.GenerateExcelReport(reportDto);
string handle = Guid.NewGuid().ToString();
using (MemoryStream memoryStream = new MemoryStream())
{
workbook.SaveAs(memoryStream);
memoryStream.Position = 0;
TempData[handle] = memoryStream.ToArray();
}
return(new JsonResult()
{
Data = new { FileGuid = handle, FileName = $"{reportDto.Name}.xlsx" }
});
}