PivotCache
PivotCache class
Represents the memory cache for some PivotTable reports.
class PivotCache;
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.
Methods
| Method | Description |
|---|---|
| refresh(PivotTableRefreshOption) | Refreshes data from the data source and calculates data for the view of all pivottables which data source is this pivot cache. |
| refresh() | Refreshes data from the data source and calculates data for the view of all pivottables which data source is this pivot cache. |
| getPivotTables() | Gets all pivot tables with this pivot cache. |
| isNull() | Checks whether the implementation object is null. |
| getSourceType() | Gets the PivotTableSourceType. |
| dispose() | Release all resource. |
refresh(PivotTableRefreshOption)
Refreshes data from the data source and calculates data for the view of all pivottables which data source is this pivot cache.
refresh(option: PivotTableRefreshOption) : PivotRefreshState;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| option | PivotTableRefreshOption | The options for refreshing data source of pivot table. |
Returns
Remarks
It’s better that you can simply call Workbook.RefreshAll() to refresh all pivot tables and charts in the file.
refresh()
Refreshes data from the data source and calculates data for the view of all pivottables which data source is this pivot cache.
refresh() : PivotRefreshState;
Returns
Remarks
If both table1 and table2 use this cache, the two table will calculated. It’s better that you can simply call Workbook.RefreshAll() to refresh all pivot tables and charts in the file.
getPivotTables()
Gets all pivot tables with this pivot cache.
getPivotTables() : PivotTable[];
Returns
isNull()
Checks whether the implementation object is null.
isNull() : boolean;
getSourceType()
Gets the PivotTableSourceType.
getSourceType() : PivotTableSourceType;
Returns
dispose()
Release all resource.
dispose() : void;