PivotCache class

PivotCache class

Represents the memory cache for some PivotTable reports.

The PivotCache type exposes the following members:

Properties

PropertyDescription
source_typeGets the PivotTableSourceType.

Methods

MethodDescription
refresh(self, option)Refreshes data from the data source and calculates data for the view of all pivottables which data source is this pivot cache.
refresh(self)Refreshes data from the data source and calculates data for the view of all pivottables which data source is this pivot cache.
get_pivot_tables(self)Gets all pivot tables with this pivot cache.

Remarks

All data will be gathered into this cache,and the pivot table only get data from this cache,not directly access data source. If data source of some PivotTables are same, they will use a pivot cache.

See Also