XlTableStyleElementType enumeration
Office 2013 and later
Specifies the table style element used.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
| Member name | Description | |
|---|---|---|
| xlWholeTable | Whole Table | |
| xlHeaderRow | Header row | |
| xlTotalRow | Total Row | |
| xlGrandTotalRow | Grand total row | |
| xlFirstColumn | First column | |
| xlLastColumn | Last column | |
| xlGrandTotalColumn | Grand total column | |
| xlRowStripe1 | Row Stripe1 | |
| xlRowStripe2 | Row Stripe2 | |
| xlColumnStripe1 | Column Stripe1 | |
| xlColumnStripe2 | Column Stripe2 | |
| xlFirstHeaderCell | First header cell | |
| xlLastHeaderCell | Last header cell | |
| xlFirstTotalCell | First total cell | |
| xlLastTotalCell | Last total cell | |
| xlSubtotalColumn1 | Subtotal Column1 | |
| xlSubtotalColumn2 | Subtotal Column2 | |
| xlSubtotalColumn3 | Subtotal Column3 | |
| xlSubtotalRow1 | Subtotal Row1 | |
| xlSubtotalRow2 | Subtotal Row2 | |
| xlSubtotalRow3 | Subtotal Row3 | |
| xlBlankRow | Blank row | |
| xlColumnSubheading1 | Column Subheading1 | |
| xlColumnSubheading2 | Column Subheading2 | |
| xlColumnSubheading3 | Column Subheading3 | |
| xlRowSubheading1 | Row Subheading1 | |
| xlRowSubheading2 | Row Subheading2 | |
| xlRowSubheading3 | Row Subheading3 | |
| xlPageFieldLabels | Page field labels | |
| xlPageFieldValues | Page field values | |
| xlSlicerUnselectedItemWithData | An item that is not selected that contains data. | |
| xlSlicerUnselectedItemWithNoData | An item that is not selected that does not contain data. | |
| xlSlicerSelectedItemWithData | A selected item that contains data. | |
| xlSlicerSelectedItemWithNoData | A selected item that does not contain data. | |
| xlSlicerHoveredUnselectedItemWithData | An item, hovered over by the user, that is not selected and that contains data. | |
| xlSlicerHoveredSelectedItemWithData | A selected item, hovered over by the user, that contains data. | |
| xlSlicerHoveredUnselectedItemWithNoData | A selected item, hovered over by the user, that is not selected and that does not contain data. | |
| xlSlicerHoveredSelectedItemWithNoData | A selected item, hovered over by the user, that does not contain data. | |
| xlTimelineSelectionLabel | Timeline Selection Label | |
| xlTimelineTimeLevel | Timeline Level | |
| xlTimelinePeriodLabels1 | Timeline Period Label | |
| xlTimelinePeriodLabels2 | Additional Timeline Period Label | |
| xlTimelineSelectedTimeBlock | Selected Timeline Time Block | |
| xlTimelineUnselectedTimeBlock | Unselected Timeline Time Block | |
| xlTimelineSelectedTimeBlockSpace | Selected Timeline Time Block space |
Show: