XlTableStyleElementType Enumeration
Specifies the table style element used.
Version Information
Version Added: Excel 2007
Name |
Value |
Description |
|---|---|---|
xlBlankRow |
19 |
Blank row |
xlColumnStripe1 |
7 |
Column Stripe1 |
xlColumnStripe2 |
8 |
Column Stripe2 |
xlColumnSubheading1 |
20 |
Column Subheading1 |
xlColumnSubheading2 |
21 |
Column Subheading2 |
xlColumnSubheading3 |
22 |
Column Subheading3 |
xlFirstColumn |
3 |
First column |
xlFirstHeaderCell |
9 |
First header cell |
xlFirstTotalCell |
11 |
First total cell |
xlGrandTotalColumn |
4 |
Grand total column |
xlGrandTotalRow |
2 |
Grand total row |
xlHeaderRow |
1 |
Header row |
xlLastColumn |
4 |
Last column |
xlLastHeaderCell |
10 |
Last header cell |
xlLastTotalCell |
12 |
Last total cell |
xlPageFieldLabels |
26 |
Page field labels |
xlPageFieldValues |
27 |
Page field values |
xlRowStripe1 |
5 |
Row Stripe1 |
xlRowStripe2 |
6 |
Row Stripe2 |
xlRowSubheading1 |
23 |
Row Subheading1 |
xlRowSubheading2 |
24 |
Row Subheading2 |
xlRowSubheading3 |
25 |
Row Subheading3 |
xlSlicerHoveredSelectedItemWithData |
33 |
A selected item, hovered over by the user, that contains data. |
xlSlicerHoveredSelectedItemWithNoData |
35 |
A selected item, hovered over by the user, that does not contain data. |
xlSlicerHoveredUnselectedItemWithData |
32 |
An item, hovered over by the user, that is not selected and that contains data. |
xlSlicerHoveredUnselectedItemWithNoData |
34 |
A selected item, hovered over by the user, that is not selected and that does not contain data. |
xlSlicerSelectedItemWithData |
30 |
A selected item that contains data. |
xlSlicerSelectedItemWithNoData |
31 |
A selected item that does not contain data. |
xlSlicerUnselectedItemWithData |
28 |
An item that is not selected that contains data. |
xlSlicerUnselectedItemWithNoData |
29 |
An item that is not selected that does not contain data. |
xlSubtotalColumn1 |
13 |
Subtotal Column1 |
xlSubtotalColumn2 |
14 |
Subtotal Column2 |
xlSubtotalColumn3 |
15 |
Subtotal Column3 |
xlSubtotalRow1 |
16 |
Subtotal Row1 |
xlSubtotalRow2 |
17 |
Subtotal Row2 |
xlSubtotalRow3 |
18 |
Subtotal Row3 |
xlTotalRow |
2 |
Total Row |
xlWholeTable |
0 |
Whole Table |