Expand Minimize
This topic has not yet been rated - Rate this topic

XlTableStyleElementType Enumeration

Specifies the table style element used.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
public enum XlTableStyleElementType
Member nameDescription
xlWholeTableWhole Table
xlHeaderRowHeader row
xlTotalRowTotal Row
xlGrandTotalRowGrand total row
xlFirstColumnFirst column
xlLastColumnLast column
xlGrandTotalColumnGrand total column
xlRowStripe1Row Stripe1
xlRowStripe2Row Stripe2
xlColumnStripe1Column Stripe1
xlColumnStripe2Column Stripe2
xlFirstHeaderCellFirst header cell
xlLastHeaderCellLast header cell
xlFirstTotalCellFirst total cell
xlLastTotalCellLast total cell
xlSubtotalColumn1Subtotal Column1
xlSubtotalColumn2Subtotal Column2
xlSubtotalColumn3Subtotal Column3
xlSubtotalRow1Subtotal Row1
xlSubtotalRow2Subtotal Row2
xlSubtotalRow3Subtotal Row3
xlBlankRowBlank row
xlColumnSubheading1Column Subheading1
xlColumnSubheading2Column Subheading2
xlColumnSubheading3Column Subheading3
xlRowSubheading1Row Subheading1
xlRowSubheading2Row Subheading2
xlRowSubheading3Row Subheading3
xlPageFieldLabelsPage field labels
xlPageFieldValuesPage field values
xlSlicerUnselectedItemWithDataAn item that is not selected that contains data.
xlSlicerUnselectedItemWithNoDataAn item that is not selected that does not contain data.
xlSlicerSelectedItemWithDataA selected item that contains data.
xlSlicerSelectedItemWithNoDataA selected item that does not contain data.
xlSlicerHoveredUnselectedItemWithDataAn item, hovered over by the user, that is not selected and that contains data.
xlSlicerHoveredSelectedItemWithDataA selected item, hovered over by the user, that contains data.
xlSlicerHoveredUnselectedItemWithNoDataA selected item, hovered over by the user, that is not selected and that does not contain data.
xlSlicerHoveredSelectedItemWithNoDataA selected item, hovered over by the user, that does not contain data.

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.