TableStyleCollection

TableStyleCollection class

Represents all custom table styles.

Properties

NameTypeDescription
DefaultTableStyleNameStringGets and sets the default style name of the table.
DefaultPivotStyleNameStringGets and sets the default style name of pivot table .
Countint
Item (int)TableStyleGets the table style by the index.
Item (java.lang.String)TableStyleGets the table style by the name.

Methods

NameDescription
addTableStyleAdds a custom table style.
addPivotTableStyleAdds a custom pivot table style.
getBuiltinTableStyleGets the builtin table style
clear
removeAt
iterator
getReserved for internal use.
containsReserved for internal use.
addReserved for internal use.
indexOfReserved for internal use.

TableStyleCollection.DefaultTableStyleName property

Gets and sets the default style name of the table.

Type: String

TableStyleCollection.DefaultPivotStyleName property

Gets and sets the default style name of pivot table .

Type: String

TableStyleCollection.Count property

Type: int

TableStyleCollection.Item (int) property

Gets the table style by the index.

Type: TableStyle

TableStyleCollection.Item (java.lang.String) property

Gets the table style by the name.

Type: TableStyle

addTableStyle(name)

Adds a custom table style.

ParameterTypeDescription
nameStringThe table style name.

Returns: The index of the table style.

addPivotTableStyle(name)

Adds a custom pivot table style.

ParameterTypeDescription
nameStringThe pivot table style name.

Returns: The index of the pivot table style.

getBuiltinTableStyle(type)

Gets the builtin table style

ParameterTypeDescription
typeintA TableStyleType value. The builtin table style type.

clear()

removeAt(index)

iterator()

get(index)

Reserved for internal use.

contains(value)

Reserved for internal use.

add(value)

Reserved for internal use.

indexOf(value)

Reserved for internal use.