Worksheet Serialization - Is It Possible?

[Alejandro Calbazana]

Hello,

I was wondering if anyone has any techniques on serializing an Excel
worksheet.

What I would like to do is to grab the worksheet object in save it to
a file or a byte stream and reconstitute it in a later session. I've
tried spinning through the usedranges collection of a sheet and
writing Xml as an approach, but this performs poorly. Any other
techniques would be appreciated.

It looks like the typelib for Excel exposes some COM interfaces for
some level of persistence (File/Memory), but I am not clear how to get
at them. This would be the ideal approach!

Thanks,

Alejandro

 

[Tom Ogilvy]

In xl2002 and later, I believe you can do a file saveas and choose XML

http://support.microsoft.com/default.aspx?scid=kb;en-us;287734&Product=xlw
XL2002: Excel Saves XML Files in the XML Spreadsheet Format