Specifies the table style element used.

Version Information
Version Added: Excel

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