XlTableStyleElementType XlTableStyleElementType XlTableStyleElementType Enum

Definition

Specifies the table style element used.

public enum class XlTableStyleElementType
public enum XlTableStyleElementType
Public Enum XlTableStyleElementType
Inheritance
XlTableStyleElementTypeXlTableStyleElementTypeXlTableStyleElementType

Fields

xlBlankRow xlBlankRow xlBlankRow 19

Blank row

xlColumnStripe1 xlColumnStripe1 xlColumnStripe1 7

Column Stripe1

xlColumnStripe2 xlColumnStripe2 xlColumnStripe2 8

Column Stripe2

xlColumnSubheading1 xlColumnSubheading1 xlColumnSubheading1 20

Column Subheading1

xlColumnSubheading2 xlColumnSubheading2 xlColumnSubheading2 21

Column Subheading2

xlColumnSubheading3 xlColumnSubheading3 xlColumnSubheading3 22

Column Subheading3

xlFirstColumn xlFirstColumn xlFirstColumn 3

First column

xlFirstHeaderCell xlFirstHeaderCell xlFirstHeaderCell 9

First header cell

xlFirstTotalCell xlFirstTotalCell xlFirstTotalCell 11

First total cell

xlGrandTotalColumn xlGrandTotalColumn xlGrandTotalColumn 4

Grand total column

xlGrandTotalRow xlGrandTotalRow xlGrandTotalRow 2

Grand total row

xlHeaderRow xlHeaderRow xlHeaderRow 1

Header row

xlLastColumn xlLastColumn xlLastColumn 4

Last column

xlLastHeaderCell xlLastHeaderCell xlLastHeaderCell 10

Last header cell

xlLastTotalCell xlLastTotalCell xlLastTotalCell 12

Last total cell

xlPageFieldLabels xlPageFieldLabels xlPageFieldLabels 26

Page field labels

xlPageFieldValues xlPageFieldValues xlPageFieldValues 27

Page field values

xlRowStripe1 xlRowStripe1 xlRowStripe1 5

Row Stripe1

xlRowStripe2 xlRowStripe2 xlRowStripe2 6

Row Stripe2

xlRowSubheading1 xlRowSubheading1 xlRowSubheading1 23

Row Subheading1

xlRowSubheading2 xlRowSubheading2 xlRowSubheading2 24

Row Subheading2

xlRowSubheading3 xlRowSubheading3 xlRowSubheading3 25

Row Subheading3

xlSlicerHoveredSelectedItemWithData xlSlicerHoveredSelectedItemWithData xlSlicerHoveredSelectedItemWithData 33

A selected item, hovered over by the user, that contains data.

xlSlicerHoveredSelectedItemWithNoData xlSlicerHoveredSelectedItemWithNoData xlSlicerHoveredSelectedItemWithNoData 35

A selected item, hovered over by the user, that does not contain data.

xlSlicerHoveredUnselectedItemWithData xlSlicerHoveredUnselectedItemWithData xlSlicerHoveredUnselectedItemWithData 32

An item, hovered over by the user, that is not selected and that contains data.

xlSlicerHoveredUnselectedItemWithNoData xlSlicerHoveredUnselectedItemWithNoData xlSlicerHoveredUnselectedItemWithNoData 34

A selected item, hovered over by the user, that is not selected and that does not contain data.

xlSlicerSelectedItemWithData xlSlicerSelectedItemWithData xlSlicerSelectedItemWithData 30

A selected item that contains data.

xlSlicerSelectedItemWithNoData xlSlicerSelectedItemWithNoData xlSlicerSelectedItemWithNoData 31

A selected item that does not contain data.

xlSlicerUnselectedItemWithData xlSlicerUnselectedItemWithData xlSlicerUnselectedItemWithData 28

An item that is not selected that contains data.

xlSlicerUnselectedItemWithNoData xlSlicerUnselectedItemWithNoData xlSlicerUnselectedItemWithNoData 29

An item that is not selected that does not contain data.

xlSubtotalColumn1 xlSubtotalColumn1 xlSubtotalColumn1 13

Subtotal Column1

xlSubtotalColumn2 xlSubtotalColumn2 xlSubtotalColumn2 14

Subtotal Column2

xlSubtotalColumn3 xlSubtotalColumn3 xlSubtotalColumn3 15

Subtotal Column3

xlSubtotalRow1 xlSubtotalRow1 xlSubtotalRow1 16

Subtotal Row1

xlSubtotalRow2 xlSubtotalRow2 xlSubtotalRow2 17

Subtotal Row2

xlSubtotalRow3 xlSubtotalRow3 xlSubtotalRow3 18

Subtotal Row3

xlTimelinePeriodLabels1 xlTimelinePeriodLabels1 xlTimelinePeriodLabels1 38

Timeline Period Label

xlTimelinePeriodLabels2 xlTimelinePeriodLabels2 xlTimelinePeriodLabels2 39

Additional Timeline Period Label

xlTimelineSelectedTimeBlock xlTimelineSelectedTimeBlock xlTimelineSelectedTimeBlock 40

Selected Timeline Time Block

xlTimelineSelectedTimeBlockSpace xlTimelineSelectedTimeBlockSpace xlTimelineSelectedTimeBlockSpace 42

Selected Timeline Time Block space

xlTimelineSelectionLabel xlTimelineSelectionLabel xlTimelineSelectionLabel 36

Timeline Selection Label

xlTimelineTimeLevel xlTimelineTimeLevel xlTimelineTimeLevel 37

Timeline Level

xlTimelineUnselectedTimeBlock xlTimelineUnselectedTimeBlock xlTimelineUnselectedTimeBlock 41

Unselected Timeline Time Block

xlTotalRow xlTotalRow xlTotalRow 2

Total Row

xlWholeTable xlWholeTable xlWholeTable 0

Whole Table

Applies to