Refresh pivottable

jeffry · August 24, 2006, 12:55am

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

Laurence · August 24, 2006, 1:42am

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

jeffry · August 24, 2006, 2:59am

Thanks, I found the option!