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);