View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
keren keren is offline
external usenet poster
 
Posts: 3
Default Serialization of pivot table

Hi,

Is it possible to serialize and de-serialize the meta data of a pivot table
to/from an XML or any other format?

I saw that if I save a workbook that contains a pivot table as an XML
spreadsheet there is an xml representation for the pivot table, is there an
api for retrieving and setting that format?

If not, is there a way to set the MDX into a pivot table object and not just
getting it?

Thanks,
Keren