## PivotTableFormatCollection class

Represents the collection of formats applied to PivotTable.

## Methods

| Name | Description |
| --- | --- |
| [add()](#add) | Add a PivotTableFormat. |
| [add()](#add-1) | Reserved for internal use. |
| [clear()](#clear) |  |
| [contains()](#contains) | Reserved for internal use. |
| [formatArea(axisType, fieldPosition, subtotalType, selectionType, isGrandRow, isGrandColumn, style)](#formatarea) | Formats selected area. |
| [get(index)](#get) | Gets the format by the index. |
| [get()](#get-1) | Reserved for internal use. |
| [getCount()](#getcount) |  |
| [indexOf()](#indexof) | Reserved for internal use. |
| [iterator()](#iterator) |  |
| [removeAt()](#removeat) |  |

### add() {#add}

Add a PivotTableFormat.

**Returns:** Number — `Number` The index of new format.

### add() {#add-1}

Reserved for internal use.

### clear() {#clear}

### contains() {#contains}

Reserved for internal use.

### formatArea(axisType, fieldPosition, subtotalType, selectionType, isGrandRow, isGrandColumn, style) {#formatarea}

Formats selected area.

| Parameter | Type | Description |
| --- | --- | --- |
| axisType | Number | PivotFieldType |
| fieldPosition | Number | Position of the field within the axis to which this rule applies. |
| subtotalType | Number | PivotFieldSubtotalType |
| selectionType | Number | PivotTableSelectionType |
| isGrandRow | boolean | Indicates whether selecting grand total rows. |
| isGrandColumn | boolean | Indicates whether selecting grand total columns. |
| style | Style | The style which appies to the area of the pivot table. |

**Returns:** PivotTableFormat — `PivotTableFormat`

### get(index) {#get}

Gets the format by the index.

| Parameter | Type | Description |
| --- | --- | --- |
| index | Number | The index. |

**Returns:** PivotTableFormat — `PivotTableFormat`

### get() {#get-1}

Reserved for internal use.

### getCount() {#getcount}

### indexOf() {#indexof}

Reserved for internal use.

### iterator() {#iterator}

### removeAt() {#removeat}