xlTableStyleElementType

Specifies the table style element used.

xlBlankRowBlank row (19)
xlColumnStripe1Column Stripe1 (7)
xlColumnStripe2Column Stripe2 (8)
xlColumnSubheading1Column Subheading1 (20)
xlColumnSubheading2Column Subheading2 (21)
xlColumnSubheading3Column Subheading3 (22)
xlFirstColumnFirst column (3)
xlFirstHeaderCellFirst header cell (9)
xlFirstTotalCellFirst total cell (11)
xlGrandTotalColumnGrand total column (4)
xlGrandTotalRowGrand total row (2)
xlHeaderRowHeader row (1)
xlLastColumnLast column (4)
xlLastHeaderCellLast header cell (10)
xlLastTotalCellLast total cell (12)
xlPageFieldLabelsPage field labels (26)
xlPageFieldValuesPage field values (27)
xlRowStripe1Row Stripe1 (5)
xlRowStripe2Row Stripe2 (6)
xlRowSubheading1Row Subheading1 (23)
xlRowSubheading2Row Subheading2 (24)
xlRowSubheading3Row Subheading3 (25)
xlSlicerHoveredSelectedItemWithData(Added in 2010) (33)
xlSlicerHoveredSelectedItemWithNoData(Added in 2010) (35)
xlSlicerHoveredUnselectedWithData(Added in 2010) (32)
xlSlicerHoveredUnselectedWithNoData(Added in 2010) (34)
xlSlicerSelectedWithData(Added in 2010) (30)
xlSlicerSelectedWithNoData(Added in 2010) (31)
xlSlicerUnselectedItemWithData(Added in 2010) (28)
xlSlicerUnselectedItemWithNoData(Added in 2010) (29)
xlSubtotalColumn1Subtotal Column1 (13)
xlSubtotalColumn2Subtotal Column2 (14)
xlSubtotalColumn3Subtotal Column3 (15)
xlSubtotalRow1Subtotal Row1 (16)
xlSubtotalRow2Subtotal Row2 (17)
xlSubtotalRow3Subtotal Row3 (18)
xlTimelinePeriodLabels1(Added in 2013) (38)
xlTimelinePeriodLabels2(Added in 2013) (39)
xlTimelineSelectedTimeBlock(Added in 2013) (40)
xlTimelineSelectedTimeBlockSpace(Added in 2013) (36)
xlTimelineSelectionLabel(Added in 2013) (37)
xlTimelineTimeLevel(Added in 2013) (41)
xlTimelineUnselectedTimeBlock(Added in 2013) (42)
xlTotalRowTotal Row (2)
xlWholeTableWhole Table (0)

REMARKS
* Added in 2007.

© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top