pivot table xml

R

Radu Colceriu

HI,

I want to save a pivot table from excel (office xp) to a database and then
to restore it back. One posibility is to save each property (PivotFields,
CubeFields a.s.o) to a string and then save the string to the db but this is
not so nice. It will be nice to have a serialize() metod on the pivottable
or a "serializator" object that is able to create a xml/string out of the
properties of the object.
When you save the pivot table as HTML it is created an xml inside the html
with all the properties. This xml string then is passed to the Office Web
Components Pivot table (OWC10.PivotTable) and this control is able to build
back a pivot table from it.

My question is, having this XML string how it is possible to create in EXCEL
the pivot table out of it in an appropiate manner like OWC10.PivotTable it
is doing...

Thanx,

-radix
 

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

Save as word to xml is splitting place holders ex: $abc.xyz$ 0
Dealing with a Pivot Table (when I don't want to) 0
Dates In Excel 5
Write back from pivot table 1
Write back from pivot table 0
Doughnut Chart linked with the slicer in the pivot table 0
Changing pivot table ADO recordset 0
Pivot Table cell values 1

Top