GrapeCity.Documents.Excel.TableStyleElementType

TableStyleElementType Enum

Specifies the type of a table style element.

Use this enum to identify a specific part of a table, pivot table, slicer, or timeline style, such as the whole table, header row, total row, striped rows, or special selection states. It is typically used with this[TableStyleElementType] to access the corresponding ITableStyleElement.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public enum TableStyleElementType

Public Enum TableStyleElementType

Examples

ITableStyle tableStyle = workbook.TableStyles.Add("CustomStyle");
ITableStyleElement headerRow = tableStyle.TableStyleElements[TableStyleElementType.HeaderRow];
headerRow.Interior.Color = System.Drawing.Color.Blue;
System.Drawing.Color headerColor = headerRow.Interior.Color;

Fields

Name	Description
BlankRow	Specifies the style element for a blank row inserted in a PivotTable layout.
FirstColumn	Specifies the style element for the first column of a table when first-column formatting is enabled.
FirstColumnStripe	Specifies the first banded column stripe element in a table or pivot table style. This element defines the formatting applied to the first stripe in an alternating column banding pattern when column stripes are used.
FirstColumnSubheading	Specifies the style element for the first column subheading level in a PivotTable.
FirstHeaderCell	Specifies the first cell in the header area, used to apply a distinct style to the leading header cell of a table or pivot table.
FirstRowStripe	Specifies the first row stripe formatting element. This element defines the style applied to the first band in alternating row stripe patterns for a table or PivotTable style.
FirstRowSubheading	Specifies the style element applied to the first row subheading area in a PivotTable.
FirstSubtotalColumn	Specifies the table style element that applies formatting to the first subtotal column in a PivotTable.
FirstSubtotalRow	Specifies the first subtotal row in a PivotTable.
FirstTotalCell	Specifies the first cell in the total row of a table style.
GrandTotalColumn	Specifies the grand total column area in a pivot table style. This element is used to apply formatting to the column that displays grand total values in a pivot table.
GrandTotalRow	Specifies the grand total row area in a pivot table style. This element is used to define the formatting applied to the row that displays grand total values across the pivot table.
HeaderRow	Specifies the style element applied to the header row of a table.
HoveredSelectedItemWithData	Specifies a selected item, hovered over by the user, that contains data.
HoveredSelectedItemWithNoData	Specifies a selected item that does not contain data and is currently being hovered over by the user.
HoveredUnselectedItemWithData	Specifies a slicer item that contains data and is currently hovered over by the user but not selected.
HoveredUnselectedItemWithNoData	Specifies an item, hovered over by the user, that is not selected and that does not contain data.
LastColumn	Specifies the style element for the last column. This element represents the formatting applied to the rightmost column when a table or pivot table style is configured to highlight the last column.
LastHeaderCell	Specifies the style element for the last cell in a table header row. Use this value to identify or customize the formatting applied to the header cell of the last column in a table style.
LastTotalCell	Specifies the last cell in the total row of a table. This element is used to define the style applied specifically to the rightmost cell in the table's total row, allowing it to differ from the rest of the total row or from `FirstTotalCell`.
PageFieldLabels	Specifies the table style element that is applied to page field labels in a pivot table.
PageFieldValues	Specifies the values area of page fields in a PivotTable. This style element applies to the cells that display the current page field values, rather than the page field labels.
SecondColumnStripe	Specifies the second column stripe element in a table or pivot table style. This element is used to define the formatting applied to the second alternating column band when banded columns are enabled.
SecondColumnSubheading	Specifies the second column subheading in a PivotTable style.
SecondRowStripe	Specifies the second row stripe band.
SecondRowSubheading	Specifies the style element applied to the second row subheading area in a PivotTable.
SecondSubtotalColumn	Specifies the second subtotal column in a PivotTable style. This element identifies the style region applied to the second-level subtotal column when a PivotTable displays column subtotals.
SecondSubtotalRow	Specifies the table style element applied to the second subtotal row in a PivotTable.
SelectedItemWithData	Specifies the style element for a selected slicer item that contains data.
SelectedItemWithNoData	Specifies a selected slicer item that does not contain data.
ThirdColumnSubheading	Specifies the third column subheading in a PivotTable.
ThirdRowSubheading	Specifies the style element for the third row subheading in a PivotTable.
ThirdSubtotalColumn	Specifies the third subtotal column element in a PivotTable style. Use this element type to define the formatting applied to the third subtotal column in a PivotTable.
ThirdSubtotalRow	Specifies the style element for the third subtotal row in a pivot table.
TimelinePeriodLabels1	Specifies timeline period Label.
TimelinePeriodLabels2	Specifies additional timeline period label.
TimelineSelectedTimeBlock	Specifies selected timeline time block.
TimelineSelectedTimeBlockSpace	Specifies selected timeline time block space.
TimelineSelectionLabel	Specifies timeline selection label.
TimelineTimeLevel	Specifies timeline level.
TimelineUnselectedTimeBlock	Specifies unselected timeline time block.
TotalRow	Specifies the style element applied to the total row of a table. This element represents the row that displays summary or aggregate values at the bottom of a table and is used when defining formatting specifically for that row.
UnselectedItemWithData	Specifies a slicer item that contains data and is not selected.
UnselectedItemWithNoData	Specifies the style element for a slicer item that is not selected and does not contain data. Use this value to define the appearance of unavailable slicer items in their normal, unselected state.
WholeTable	Specifies the whole table area. This element is used to define the base formatting applied to the entire table, excluding more specific regions that can be styled separately, such as the header row, total row, or striped areas.