Methods

add()

Reserved for internal use.

addPivotTableStyle(name) → Number

Adds a custom pivot table style.

Parameter

Name Type Optional Description

name

String

 

The pivot table style name.

Returns

Number The index of the pivot table style.

addTableStyle(name) → Number

Adds a custom table style.

Parameter

Name Type Optional Description

name

String

 

The table style name.

Returns

Number The index of the table style.

clear()

contains()

Reserved for internal use.

get(index) → TableStyle

Gets the table style by the index.

Parameter

Name Type Optional Description

index

Number

 

The position of the table style in the list.

Returns

TableStyle The table style object.

get(name) → TableStyle

Gets the table style by the name.

Parameter

Name Type Optional Description

name

String

 

The table style name.

Returns

TableStyle The table style object.

get()

Reserved for internal use.

getBuiltinTableStyle(type) → TableStyle

Gets the builtin table style

Parameter

Name Type Optional Description

type

Number

 

TableStyleType

Returns

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.