Refresh pivottable


#1
Hi,
Is there a way to refresh a pivot table programmatically? When using the Excel object library I used:

workSheet = (Excel.Worksheet)workBook.Worksheets["PIVOT"];

((Excel.PivotTable)workSheet.PivotTables("PivotTable1")).PivotCache().Refresh();

I can't find a pivottable object in Aspose.Cells. Is there a way?
Thanks,
Jeffry

#2

Aspose.Cells doesn’t support this feature yet. You can set “Refresh on open” option in your template file.


#3

Thanks, I found the option!