Free Support Forum - aspose.com

Update pivot table

Hi Aspose Team,

I've a workbook with an already defined pivot table.

I need to change some data of the pivot table data source, then recalculate the pivot table, and save the updated pivot table to Aspose.Pdf format.

How can I do this? I've followed the documentation but the pivot table seems to never be updated.

code :

Workbook wbk = new Workbook();

wbk.Open("e:\\test.xls");

//put data

wbk.Worksheets[0].Cells["B2"].PutValue(10);

wbk.CalculateFormula();

//update pivot table

Range range = wbk.Worksheets[0].Cells.CreateRange(0, 0, 5, 5);

range.Name = "data";

wbk.Save("e:\\test2.xls",FileFormatType.AsposePdf);

Hi,

Well, I 'm afraid the feature is not available, you cannot dynamically manipulate a pivot table using Aspose.Cells APIs. Actually Aspose.Cells does not process the pivot data rather only sets the data. Aspose.Cells forces MS Excel to refesh and process the pivot table when the output file is loaded with MS Excel.

Thank you.