Free Support Forum - aspose.com

Retrieve the datasource property of my pivot tables

Hi,

I made a template that contains pivot tables, i would like to retrieve all datasource property of them (not the data).

Is it possible with Aspose.Cells and how ?

Thanks

Hi,

Thanks for considering Aspose.

You mean you want to retrieve the pivot table report data items, Well, Aspose.Cells actually sets the format for pivot table report and does not create the report. The component forces MS Excel to create the pivot table report based on data and the pivot table report is created when you open the output file in MS Excel. So, it is not possible to access/manipulate pivot tables in the template files.

Thank you.

Hi ,

Please use named range as your pivot table data source. Please check http://www.aspose.com/Wiki/default.aspx/Aspose.Cells/PivotTable.html. You can get data source by named range.