Write Worksheet to MemoryStream in .NET 2.0

B

brenbesser

I am developing a windows forms application in .NET 2.0 using VS2005.

One of my forms has a grid that I want to convert to Excel and attach
to an email and send using System.Net.Mail.

..NET 2.0 has a MemoryStream class that can be attached to an email.

mail.Attachments.Add(New Attachment(attachmentStream1, "ExcelFile.xls",
"excel/xlsss"))

Using Excel Automation, I have created a Workbook. I can save the
workbook to disk, but I want to write it to the MemoryStream object to
use as the attachmentStream.

How can I get the Worksheet into to MemoryStream?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Write Worksheet to MemoryStream in .NET 2.0 1
Open an excel from a .NET stream 0
Unable to open attachments in a mail which are stored as Image in 0
Excel Programmatic (Existing) Workbook Access in .NET 2.0 0
The Current .Net Security Policy does not Permit... 0
.NET Framework 2.0 2
Excel to pdf 1
VBA to do a mailmerge from a Specific Excel worksheet 0

Top