Worksheet Serialization - Is It Possible?

  • Thread starter Thread starter Alejandro Calbazana
  • Start date Start date
A

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
 
Back
Top