Class PivotCache
Contents
[
Hide
]PivotCache class
Represents the memory cache for some PivotTable reports.
public abstract class PivotCache : IDisposable
Properties
| Name | Description |
|---|---|
| MissingItemsLimit { get; set; } | Gets and sets the number of unused items to allow before discarding unused items. This value MUST be greater than -2 and less than 1048577. PivotCacheMissingItemsLimitConst; |
| abstract SourceType { get; } | Gets the PivotTableSourceType. |
Methods
| Name | Description |
|---|---|
| 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
- namespace Aspose.Cells.Pivot
- assembly Aspose.Cells
