We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Change DataSource on Pivot Table

I am needing to update a number of existing pivot tables to point a different range.
Is there a way to change the source using Aspose.cells?
I so far having not seen a property on the pivot table that would allow me to change it.
Thanks for your help.


I am afraid, currently we do not support to directly change the source of a pivot table in the template file. As as workaround, you may try to create a named range as data source for the pivot table (something similar to the topic: Create Pivot Tables and Pivot Charts, and then change the area of the named range by using Aspose.Cells APIs, it may work for your needs.

A ticket is logged with an id: CELLSNET-40246. We will provide the APIs to set data source directly for the pivot table later on.

Thank you.


We have fixed this issue. Please download: Aspose.Cells for .NET (Latest Version)

Please use pivottable.ChangeDataSource method

The issues you have found earlier (filed as CELLSNET-40246) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.