refresh_data method

refresh_data

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

def refresh_data(self):
    ...

Remarks

We will gather data from data source to a pivot cache ,then calculate the data in the cache to the cells. This method is only used to gather all data to a pivot cache.

refresh_data

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

def refresh_data(self, option):
    ...
ParameterTypeDescription
optionPivotTableRefreshOptionThe options for refreshing data source of pivot table.

See Also