How to write an Excel workbook to a MemoryStream in .NET?

Asked 2008-10-01T06:54:19.177

How do I write an Excel workbook to a MemoryStream without first saving it to the file system?

All options within the Microsoft.Office.Interop.Excel.WorkBook save options take a filename.

.net excel

Edit Report

1 Answer

If you only need basic functionality from Excel, you might want to create the Workbook as an Html stream. There is another question on SO that handless this.

This also solves some problems (you might not have yet) concerning the scalability of your solution.

answered 2008-10-01T07:14:31.297