Aspose::Cells::Pivot::PivotTable::RefreshData method

PivotTable::RefreshData() method

Refreshes data from it’s data source to pivot cache.

Deprecated

Use PivotCache.RefreshData() method instead.

PivotRefreshState Aspose::Cells::Pivot::PivotTable::RefreshData()

Remarks

We will gather data from data source to a pivot cache ,then calculate the data in the cache to the cells. And it’s better that you can simply call Workbook.RefreshAll() to refresh and calculate all pivot tables in the file, not to refresh one by one. NOTE: This method is now obsolete. Instead, please use PivotCache.Refresh() method and remove followed PivotTable.CalculateData() because this pivot table will be caclualted when refreshing PivotCache. This method will be removed 12 months later since June 2026. Aspose apologizes for any inconvenience you may have experienced.

See Also

PivotTable::RefreshData(const PivotTableRefreshOption&) method

Refreshes pivottable’s data and setting from it’s data source with options.

Deprecated

Use PivotCache.RefreshData() method instead.

PivotRefreshState Aspose::Cells::Pivot::PivotTable::RefreshData(const PivotTableRefreshOption &option)
ParameterTypeDescription
optionconst PivotTableRefreshOption&The options for refreshing data source of pivot table.

Remarks

We will gather data from data source to a pivot cache ,then calculate the data in the cache to the cells. And it’s better that you can simply call Workbook.RefreshAll() to refresh and calculate all pivot tables in the file, not to refresh one by one. NOTE: This method is now obsolete. Instead, please use PivotCache.Refresh() method and remove followed PivotTable.CalculateData() because this pivot table will be caclualted when refreshing PivotCache This method will be removed 12 months later since June 2026. Aspose apologizes for any inconvenience you may have experienced.

See Also

Aspose::Cells::Pivot::PivotTable::GetSource method Aspose::Cells::Pivot::PivotTable::CalculateData method