Update source data range of existing pivot table using Aspose.Cells Cloud API

Aspose.Cells Cloud Product Family
1

Hi,


I have a requirement : i am creating a workbook from existing template which has a pivot table in “Pivotdata” sheet. i am adding data to “data” sheet and depending on number of rows i add in the “data” sheet i want to update source range of my pivot table.

I am currently using : PutWorksheetPivotTable() but it is creating a new pivot table for me, i dont want new pivot table i want to update existing one.

Kindly suggest.

Thanks and Regards,
Amey Sawant
2

Hi,


Thanks for your posting and using Aspose.Cells for Cloud.

Please provide us your source excel file and the expected output excel file which you can create manually using Microsoft Excel. We will use them to test your issue in Cells Cloud environment and update you asap.