Class PivotCache

PivotCache class

Represents the memory cache for some PivotTable reports.

public abstract class PivotCache : IDisposable

Properties

NameDescription
abstract SourceType { get; }Gets the PivotTableSourceType.

Methods

NameDescription
abstract Dispose()Release all resource.
GetPivotTables()Gets all pivot tables with 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.
Refresh(PivotTableRefreshOption)Refreshes data from the data source and calculates data for the view of all pivottables which data source is 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