Excel Interop with in-memory document - no file system -- dotnet interop

mj2736 NO[at]SPAM yahoo.com
6/29/2007 7:34:31 AM

I have Excel 2003 documents stored in a SQL 2005 database,
VARBINARY(MAX) column. I need to read the documents out of the table,
open them up, modify their header, and write them back to another
table. In .Net 2.0 is it possible to do all of this in memory using
the Excel interop interface, without writing the documents to the file
system? Thanks.

NickHK
7/3/2007 12:00:00 AM

Depends what you mean by "modify their header" ?
If you understand the binary format of the Excel file then yes anything is
possible, maybe using one of the BIFF Reader/Writer classes available as a
starting point.
Otherwise (and IMHO certainly the easier) is to use automation/interop and
allow Excel to make the changes, which will involve writing the file to disk
somewhere, then use Workbooks.Open

NickHK

[quoted text, click to view]

dotnet interop : Excel Interop with in-memory document - no file system