XlTableStyleElementType Enum
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Specifies the table style element used.
public enum class XlTableStyleElementTypepublic enum XlTableStyleElementTypePublic Enum XlTableStyleElementType- Inheritance
-
XlTableStyleElementType
Fields
| Name | Value | Description |
|---|---|---|
| xlWholeTable | 0 | Whole Table |
| xlHeaderRow | 1 | Header row |
| xlGrandTotalRow | 2 | Grand total row |
| xlTotalRow | 2 | Total Row |
| xlFirstColumn | 3 | First column |
| xlGrandTotalColumn | 4 | Grand total column |
| xlLastColumn | 4 | Last column |
| xlRowStripe1 | 5 | Row Stripe1 |
| xlRowStripe2 | 6 | Row Stripe2 |
| xlColumnStripe1 | 7 | Column Stripe1 |
| xlColumnStripe2 | 8 | Column Stripe2 |
| xlFirstHeaderCell | 9 | First header cell |
| xlLastHeaderCell | 10 | Last header cell |
| xlFirstTotalCell | 11 | First total cell |
| xlLastTotalCell | 12 | Last total cell |
| xlSubtotalColumn1 | 13 | Subtotal Column1 |
| xlSubtotalColumn2 | 14 | Subtotal Column2 |
| xlSubtotalColumn3 | 15 | Subtotal Column3 |
| xlSubtotalRow1 | 16 | Subtotal Row1 |
| xlSubtotalRow2 | 17 | Subtotal Row2 |
| xlSubtotalRow3 | 18 | Subtotal Row3 |
| xlBlankRow | 19 | Blank row |
| xlColumnSubheading1 | 20 | Column Subheading1 |
| xlColumnSubheading2 | 21 | Column Subheading2 |
| xlColumnSubheading3 | 22 | Column Subheading3 |
| xlRowSubheading1 | 23 | Row Subheading1 |
| xlRowSubheading2 | 24 | Row Subheading2 |
| xlRowSubheading3 | 25 | Row Subheading3 |
| xlPageFieldLabels | 26 | Page field labels |
| xlPageFieldValues | 27 | Page field values |
| xlSlicerUnselectedItemWithData | 28 | An item that is not selected that contains data. |
| xlSlicerUnselectedItemWithNoData | 29 | An item that is not selected that does not contain data. |
| xlSlicerSelectedItemWithData | 30 | A selected item that contains data. |
| xlSlicerSelectedItemWithNoData | 31 | A selected item that does not contain data. |
| xlSlicerHoveredUnselectedItemWithData | 32 | An item, hovered over by the user, that is not selected and that contains data. |
| xlSlicerHoveredSelectedItemWithData | 33 | A selected item, hovered over by the user, that contains data. |
| xlSlicerHoveredUnselectedItemWithNoData | 34 | A selected item, hovered over by the user, that is not selected and that does not contain data. |
| xlSlicerHoveredSelectedItemWithNoData | 35 | A selected item, hovered over by the user, that does not contain data. |
| xlTimelineSelectionLabel | 36 | Timeline Selection Label |
| xlTimelineTimeLevel | 37 | Timeline Level |
| xlTimelinePeriodLabels1 | 38 | Timeline Period Label |
| xlTimelinePeriodLabels2 | 39 | Additional Timeline Period Label |
| xlTimelineSelectedTimeBlock | 40 | Selected Timeline Time Block |
| xlTimelineUnselectedTimeBlock | 41 | Unselected Timeline Time Block |
| xlTimelineSelectedTimeBlockSpace | 42 | Selected Timeline Time Block space |