How to save pivot table and reopen

R

Rycho

We have been using office web components for olap analysis, most of our
questions have been answered by the excellent "Black Book" BUT....

We now want to do something which we thought would be simple...

To save a setup from the pivot table into a file (not excel) and then
be able to reopen the file in the web component.

Can anyone help ??
 
A

Antoine Prevot

[Rycho]
To save a setup from the pivot table into a file (not excel) and then
be able to reopen the file in the web component.

Can anyone help ??
Click to expand...

Hi Rycho,

Try working with the "XMLData" property.
It's a (read/write) string containing most of the PivotTable structure. Save
it to a file (or a database), then restore it as you wish.
I guess you'll have to save manually a few properties since some are missing
in the XML model, ie: drop zones visibility
(PT.ActiveView.ColumnAxis.Label.Visible, ...RowAxis..., ...FilterAxis...) etc.

Hope this helps,

Tonio
 
Top