getting pointer to Excel file binary
 

Hi!

I have a program in C# which populate an excel worksheet.
I'd like to get an IStream pointer to the worksheet so that I could
send it via TCP/IP to another program.

We are not able to do that. the closest we could come to is:
- populate spreadsheet
- ask excel to save the file
- open it,
- send it
- close the file
- erase the file on disk

it does work, but going to disk for temporary data is a bit clunky.
So I was thinking, there might be a way to get from excel some kind of
object that I could use to read the excel file in memory.

the pseudocode would become:
we'd like to do:
- populate spreadsheet
- ask excel for data pointer
- send it (using the data pointer)

No more problems with:
- saving file
- name clash
- not deleting files
etc...

Any idea on how I could do it.

Thanks


Wonixen