PivotCache Class

• Open Markdown

• ---

• Open in ChatGPT
• Open in Claude
• Open in Perplexity

PivotCache class

Represents the memory cache for some PivotTable reports.

type PivotCache struct  {
	ptr unsafe.Pointer
}

Constructors

Method	Description

Methods

Method	Description
IsNull	Checks whether the implementation object is nullptr.
GetMissingItemsLimit	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;
SetMissingItemsLimit	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;
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.
Dispose	Release all resource.
GetSourceType	Gets the PivotTableSourceType.