Hi
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.
Josh
Hi,
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.
Hi,
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.