TableStyleElementType

TableStyleElementType enumeration

Represents the Table or PivotTable style element type.

Values

Name	Value	Description
BlankRow	18	Table style element that applies to PivotTable’s blank rows.
FirstColumn	8	Table style element that applies to table’s first column.
FirstColumnStripe	3	Table style element that applies to table’s first column stripes.
FirstColumnSubheading	22	Table style element that applies to PivotTable’s first column subheading.
FirstHeaderCell	11	Table style element that applies to table’s first header row cell.
FirstRowStripe	5	Table style element that applies to table’s first row stripes.
FirstRowSubheading	25	Table style element that applies to PivotTable’s first row subheading.
FirstSubtotalColumn	15	Table style element that applies to PivotTable’s first subtotal column.
FirstSubtotalRow	19	Table style element that applies to pivot table’s first subtotal row.
GrandTotalColumn	28	Table style element that applies to pivot table’s grand total column.
GrandTotalRow	29	Table style element that applies to pivot table’s grand total row.
FirstTotalCell	13	Table style element that applies to table’s first total row cell.
HeaderRow	9	Table style element that applies to table’s header row.
LastColumn	7	Table style element that applies to table’s last column.
LastHeaderCell	12	Table style element that applies to table’s last header row cell.
LastTotalCell	14	Table style element that applies to table’s last total row cell.
PageFieldLabels	1	Table style element that applies to pivot table’s page field labels.
PageFieldValues	2	Table style element that applies to pivot table’s page field values.
SecondColumnStripe	4	Table style element that applies to table’s second column stripes.
SecondColumnSubheading	23	Table style element that applies to pivot table’s second column subheading.
SecondRowStripe	6	Table style element that applies to table’s second row stripes.
SecondRowSubheading	26	Table style element that applies to pivot table’s second row subheading.
SecondSubtotalColumn	16	Table style element that applies to PivotTable’s second subtotal column.
SecondSubtotalRow	20	Table style element that applies to PivotTable’s second subtotal row.
ThirdColumnSubheading	24	Table style element that applies to PivotTable’s third column subheading.
ThirdRowSubheading	27	Table style element that applies to PivotTable’s third row subheading.
ThirdSubtotalColumn	17	Table style element that applies to pivot table’s third subtotal column.
ThirdSubtotalRow	21	Table style element that applies to PivotTable’s third subtotal row.
TotalRow	10	Table style element that applies to table’s total row.
WholeTable	0	Table style element that applies to table’s entire content.