Save workbook into a stream instead of a file

Question

Is it possible (and how) to save an Microsoft Excel workbook into a stream instead of a file?

what I have now is:

using System.Runtime.InteropServices; // Microsoft Excel 14.0 Object Library
.......
workbook.SaveAs(Filename: fileName, FileFormat: XlFileFormat.xlWorkbookNormal);

But both documentation as intellisense give me no clue how to put this in a stream and write it with a BinaryWriter e.g. to output it via the browser.

similar: http://stackoverflow.com/questions/560435/read-excel-file-from-a-stream — , Jul 06 '11 at 12:47
@0A0D thanks for the tip ;) but I don't have a stream like in that question ( the OP has a stream from an upload) So that question is quite the opposite, still very a helpful reference. — Caspar Kleijne, Jul 06 '11 at 12:49
Hoping that something in that answer will pique your interest. — , Jul 06 '11 at 12:51

score 1 · Accepted Answer · answered Jul 06 '11 at 12:58

1

Office Automation provides an API to control tge office UI. It does not provide a way to store a workbook to a stream. To do that you need something lower level like a binary writer (POI) or Office Open XML SDK.

answered Jul 06 '11 at 12:58

Samuel Neff

73,278
17
138
182

The irony is, I just switched from Office Open XML to PO-Excel and never realized this would be an issue. sigh :(.... – Caspar Kleijne Jul 06 '11 at 13:02
@Caspar Kleijne, why in tbe world would you swith to automation if ooxml was working for you? Automation should be the absolute last resort and in many cases is a huge problem (ie ASP.NET). – Samuel Neff Jul 06 '11 at 13:28
Because I am stupid. And I wanted to know how it worked. Lesson learned. 2 hours wasted. – Caspar Kleijne Jul 06 '11 at 15:24
@Caspar Kleijne, 2 hours isn't bad at all for that lesson. – Samuel Neff Jul 06 '11 at 16:17

Save workbook into a stream instead of a file

1 Answers1