pivot table xml
 

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