// 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" } }); }