Generating Xlsx file without writing to file system

Nov 11, 2010 at 8:31 AM

hi guyz,

i have a working sample for writting into an xlsx file using epplus, but how can i also do this without writting to file system?

am currently using this code segment

 

 Dim oFile As New IO.FileInfo("new of an xlsx file")

 

 Dim pck As New ExcelPackage(oFile)

.........

pck.Save()

 i want to bypass the xlsx file creation on disk

Coordinator
Nov 11, 2010 at 6:36 PM

Check out the web samples. Something like ...

ExcelPackage pck = new ExcelPackage();
//...
pck.SaveAs(Response.OutputStream);
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("content-disposition", "attachment;  filename=Sample1.xlsx");
Nov 12, 2010 at 5:26 AM

perfect...thanx