## PivotCacheCollection class

Represents the collection of memory caches from the PivotTable reports in a workbook.

```javascript
class PivotCacheCollection;
```


## Methods

| Method | Description |
| --- | --- |
| [get(number)](#get-number-)| Gets the pivot table cache at the specified index. |
| [dispose()](#dispose--)| Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. |


### get(number) {#get-number-}

Gets the pivot table cache at the specified index.

```javascript
get(index: number) : PivotCache;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| index | number |  |

**Returns**

[PivotCache](../pivotcache/)

### dispose() {#dispose--}

Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.

```javascript
dispose() : void;
```