XlTableStyleElementType Enum

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

Specifies the table style element used.

public enum class XlTableStyleElementType

public enum XlTableStyleElementType

Public Enum XlTableStyleElementType

Inheritance

Enum

XlTableStyleElementType

Fields

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
xlSlicerHoveredSelectedItemWithData	33	A selected item, hovered over by the user, that contains data.
xlSlicerHoveredSelectedItemWithNoData	35	A selected item, hovered over by the user, that does not contain data.
xlSlicerHoveredUnselectedItemWithData	32	An item, hovered over by the user, that is not selected and that contains data.
xlSlicerHoveredUnselectedItemWithNoData	34	A selected item, hovered over by the user, that is not selected and that does not contain data.
xlSlicerSelectedItemWithData	30	A selected item that contains data.
xlSlicerSelectedItemWithNoData	31	A selected item that does not contain data.
xlSlicerUnselectedItemWithData	28	An item that is not selected that contains data.
xlSlicerUnselectedItemWithNoData	29	An item that is not selected that does not contain data.
xlSubtotalColumn1	13	Subtotal Column1
xlSubtotalColumn2	14	Subtotal Column2
xlSubtotalColumn3	15	Subtotal Column3
xlSubtotalRow1	16	Subtotal Row1
xlSubtotalRow2	17	Subtotal Row2
xlSubtotalRow3	18	Subtotal Row3
xlTimelinePeriodLabels1	38	Timeline Period Label
xlTimelinePeriodLabels2	39	Additional Timeline Period Label
xlTimelineSelectedTimeBlock	40	Selected Timeline Time Block
xlTimelineSelectedTimeBlockSpace	42	Selected Timeline Time Block space
xlTimelineSelectionLabel	36	Timeline Selection Label
xlTimelineTimeLevel	37	Timeline Level
xlTimelineUnselectedTimeBlock	41	Unselected Timeline Time Block
xlTotalRow	2	Total Row
xlWholeTable	0	Whole Table