closedxml

The SaveAs() method supports stream, so to get the ClosedXml workbook as a stream I use: public Stream GetStream(XLWorkbook excelWorkbook) { Stream fs = new MemoryStream(); excelWorkbook.SaveAs(fs); fs.Position = 0; return fs; } And then for downloading the file: string myName = Server.UrlEncode(ReportName + “_” + DateTime.Now.ToShortDateString() + “.xlsx”); MemoryStream stream = GetStream(ExcelWorkbook); Response.Clear(); Response.Buffer … Read more