tableStyles (Table Styles)

This element represents a collection of Table style definitions for Table styles and PivotTable styles used in this workbook. It consists of a sequence of tableStyle records, each defining a single Table style.

A Table style is a collection of formatting that applies to structured regions of a Table or PivotTable [Example: make the header row & totals bold face, and apply light gray fill to alternating rows in the data portion of the table to achieve striped or banded rows. end example]

See the enumeration values in ST_TableStyleType for a listing of structured Table regions to which formatting can be applied, and which together make up a single Table style definition.

Parent Elements

styleSheet (§3.8.39)

 

Child Elements	Subclause
tableStyle (Table Style)	§3.8.40

 

Attributes	Description
count (Table Style Count)	Count of table styles defined in this collection.   The possible values for this attribute are defined by the XML Schema unsignedInt datatype.
defaultPivotStyle (Default Pivot Style)	Name of the default table style to apply to new PivotTables. This can be set by the user interface.   The possible values for this attribute are defined by the XML Schema string datatype.
defaultTableStyle (Default Table Style)	Name of default table style to apply to new Tables. This can be set by the user interface.   The possible values for this attribute are defined by the XML Schema string datatype.

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_TableStyles">

   <sequence>

   <element name="tableStyle" type="CT_TableStyle" minOccurs="0" maxOccurs="unbounded"/>

   </sequence>

   <attribute name="count" type="xsd:unsignedInt" use="optional"/>

   <attribute name="defaultTableStyle" type="xsd:string" use="optional"/>

   <attribute name="defaultPivotStyle" type="xsd:string" use="optional"/>

</complexType>