Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
automatically appending newly added data on worksheet to a master list worksheet | Links and Linking in Excel | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | New Users to Excel | |||
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
Attaching a JET database to an Excel Worksheet OR storing large binary data in a worksheet | Excel Programming |