TableStyleCollection
TableStyleCollection class
Represents all custom table styles.
Methods
| Name | Description |
|---|---|
| add() | Reserved for internal use. |
| addPivotTableStyle(name) | Adds a custom pivot table style. |
| addTableStyle(name) | Adds a custom table style. |
| clear() | |
| contains() | Reserved for internal use. |
| get(index) | Gets the table style by the index. |
| get(name) | Gets the table style by the name. |
| get() | Reserved for internal use. |
| getBuiltinTableStyle(type) | Gets the builtin table style |
| getCount() | |
| getDefaultPivotStyleName() | Gets and sets the default style name of pivot table . |
| getDefaultTableStyleName() | Gets and sets the default style name of the table. |
| indexOf() | Reserved for internal use. |
| iterator() | |
| removeAt() | |
| setDefaultPivotStyleName() | Gets and sets the default style name of pivot table . |
| setDefaultTableStyleName() | Gets and sets the default style name of the table. |
add()
Reserved for internal use.
addPivotTableStyle(name)
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)
Adds a custom table style.
| Parameter | Type | Description |
|---|---|---|
| name | String | The table style name. |
Returns: Number — Number The index of the table style.
clear()
contains()
Reserved for internal use.
get(index)
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)
Gets the table style by the name.
| Parameter | Type | Description |
|---|---|---|
| name | String | The table style name. |
Returns: TableStyle — TableStyle The table style object.
get()
Reserved for internal use.
getBuiltinTableStyle(type)
Gets the builtin table style
| Parameter | Type | Description |
|---|---|---|
| type | Number | TableStyleType |
Returns: TableStyle — TableStyle
getCount()
getDefaultPivotStyleName()
Gets and sets the default style name of pivot table .
getDefaultTableStyleName()
Gets and sets the default style name of the table.
indexOf()
Reserved for internal use.
iterator()
removeAt()
setDefaultPivotStyleName()
Gets and sets the default style name of pivot table .
setDefaultTableStyleName()
Gets and sets the default style name of the table.