XlsPivotCache module

class XlsPivotCache.XlsPivotCache

Bases: XlsObject, IPivotCache

property CalculatedItemIndex: int

Clone

property CreatedVersion: int

<summary>

Specifies the version of the application that created the cache. This attribute is: application-dependent.

</summary>

property EnableRefresh: bool

<summary>: Specifies a boolean value that indicates whether the user can refresh the cache.

</summary>

property HasNamedRange: bool

<summary>: Indicates whether the pivot cache has named range

</summary>

static InRange(sourceRange: IXLSRange, worksheet: XlsWorksheet, index: int, count: int, isRow: bool) → bool

property Index: int

property IsBackgroundQuery: bool

<summary>

Specifies a boolean value that indicates whether the application should query and: retrieve records asynchronously from the cache.

</summary>

property IsInvalidData: bool

<summary>: Specifies a boolean value that indicates whether the cache needs to be refreshed.

</summary>

property IsOptimizedCache: bool

<summary>

Specifies a boolean value that indicates whether the application will apply optimizations: to the cache to reduce memory usage

</summary>

property IsRefreshOnLoad: bool

<summary>: Specifies a boolean value that indicates whether the application will refresh the cache

</summary>

property IsSaveData: bool

<summary>

Specifies a boolean value that indicates whether the pivot records are saved with the: cache.

</summary>

property IsSupportSubQuery: bool

<summary>: Specifies whether the cache’s data source supports subqueries

</summary>

property IsUpgradeOnRefresh: bool

<summary>

Specifies a boolean value that indicates whether the cache is scheduled for version: upgrade.

</summary>

property MinRefreshableVersion: int

<summary>: Specifies the earliest version of the application that is required to refresh the cache.

</summary>

property NeedDataArray: bool

property Parent: XlsPivotCachesCollection

property RangeName: str

<summary>: Contains the name of the pivot cache NamedRange

</summary>

property RefreshDate: DateTime

property RefreshedBy: str

property RefreshedVersion: int

<summary>

Specifies the version of the application that last refreshed the cache. This attribute: depends on whether the application exposes mechanisms via the user interface whereby the end-user can refresh the cache.

</summary>

property SourceRange: IXLSRange

property SourceType: DataSourceType

property SupportAdvancedDrill: bool