PivotCacheCollection
Contents
[
Hide
]PivotCacheCollection class
Represents the collection of memory caches from the PivotTable reports in a workbook.
class PivotCacheCollection implements Iterable<PivotCache>;
Methods
| Method | Description |
|---|---|
| get(number) | Gets the pivot table cache at the specified index. |
| dispose() | Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. |
| getCount() | @deprecated. Please use the ‘count’ property instead. Gets the number of elements contained in. |
| isNull() | Checks whether the implementation object is null. |
[Symbol.iterator](): Iterator<PivotCache>
Returns an iterator over the items in the collection. Enables use of for...of, spread syntax, and Array.from().
get(number)
Gets the pivot table cache at the specified index.
get(index: number) : PivotCache;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| index | number |
Returns
dispose()
Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.
dispose() : void;
getCount()
@deprecated. Please use the ‘count’ property instead. Gets the number of elements contained in.
getCount() : number;
isNull()
Checks whether the implementation object is null.
isNull() : boolean;