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 |
| 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 |