R
rockdale
Hi all,
Not sure is it a proper forum to post my question.
I am coding an asp.net web application using OWC11 to show PivotTable
on web page,
following this example
http://msdn.microsoft.com/library/default.asp?url=/msdnmag/issues/03/10/olap/toc.asp
and everything works fine.
But my clients had more than a dozen PivotTable which are inside excel,
I want to export the metadata of those pivottables to xmlData so that I
can load them on my web page. This way, I do not need to insert
FielsSet in my coding. everytime the end user want to see the
pivottable, I can just load the xmlData and display the PivotTable as
the exactly layout as they see in the excel.
my question is: How can I export xmlData of the current pivottable
inside excel file?
I know maybe I need some VB programming, but I am not familar with
PivotTable properties.
Thanks a lot
-Phelix
Not sure is it a proper forum to post my question.
I am coding an asp.net web application using OWC11 to show PivotTable
on web page,
following this example
http://msdn.microsoft.com/library/default.asp?url=/msdnmag/issues/03/10/olap/toc.asp
and everything works fine.
But my clients had more than a dozen PivotTable which are inside excel,
I want to export the metadata of those pivottables to xmlData so that I
can load them on my web page. This way, I do not need to insert
FielsSet in my coding. everytime the end user want to see the
pivottable, I can just load the xmlData and display the PivotTable as
the exactly layout as they see in the excel.
my question is: How can I export xmlData of the current pivottable
inside excel file?
I know maybe I need some VB programming, but I am not familar with
PivotTable properties.
Thanks a lot
-Phelix