## TableStyleCollection class

Represents all custom table styles.

## Methods

| Name | Description |
| --- | --- |
| [add()](#add) | Reserved for internal use. |
| [addPivotTableStyle(name)](#addpivottablestyle) | Adds a custom pivot table style. |
| [addTableStyle(name)](#addtablestyle) | Adds a custom table style. |
| [clear()](#clear) |  |
| [contains()](#contains) | Reserved for internal use. |
| [get(index)](#get) | Gets the table style by the index. |
| [get(name)](#get-1) | Gets the table style by the name. |
| [get()](#get-2) | Reserved for internal use. |
| [getBuiltinTableStyle(type)](#getbuiltintablestyle) | Gets the builtin table style |
| [getCount()](#getcount) |  |
| [getDefaultPivotStyleName()](#getdefaultpivotstylename) | Gets and sets the default style name of pivot table . |
| [getDefaultTableStyleName()](#getdefaulttablestylename) | Gets and sets the default style name of the table. |
| [indexOf()](#indexof) | Reserved for internal use. |
| [iterator()](#iterator) |  |
| [removeAt()](#removeat) |  |
| [setDefaultPivotStyleName()](#setdefaultpivotstylename) | Gets and sets the default style name of pivot table . |
| [setDefaultTableStyleName()](#setdefaulttablestylename) | Gets and sets the default style name of the table. |

### add() {#add}

Reserved for internal use.

### addPivotTableStyle(name) {#addpivottablestyle}

Adds a custom pivot table style.

| Parameter | Type | Description |
| --- | --- | --- |
| name | String | The pivot table style name. |

**Returns:** Number — `Number` The index of the pivot table style.

### addTableStyle(name) {#addtablestyle}

Adds a custom table style.

| Parameter | Type | Description |
| --- | --- | --- |
| name | String | The table style name. |

**Returns:** Number — `Number` The index of the table style.

### clear() {#clear}

### contains() {#contains}

Reserved for internal use.

### get(index) {#get}

Gets the table style by the index.

| Parameter | Type | Description |
| --- | --- | --- |
| index | Number | The position of the table style in the list. |

**Returns:** TableStyle — `TableStyle` The table style object.

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

Gets the table style by the name.

| Parameter | Type | Description |
| --- | --- | --- |
| name | String | The table style name. |

**Returns:** TableStyle — `TableStyle` The table style object.

### get() {#get-2}

Reserved for internal use.

### getBuiltinTableStyle(type) {#getbuiltintablestyle}

Gets the builtin table style

| Parameter | Type | Description |
| --- | --- | --- |
| type | Number | TableStyleType |

**Returns:** TableStyle — `TableStyle`

### getCount() {#getcount}

### getDefaultPivotStyleName() {#getdefaultpivotstylename}

Gets and sets the default style name of pivot table .

### getDefaultTableStyleName() {#getdefaulttablestylename}

Gets and sets the default style name of the table.

### indexOf() {#indexof}

Reserved for internal use.

### iterator() {#iterator}

### removeAt() {#removeat}

### setDefaultPivotStyleName() {#setdefaultpivotstylename}

Gets and sets the default style name of pivot table .

### setDefaultTableStyleName() {#setdefaulttablestylename}

Gets and sets the default style name of the table.