WorksheetTableStyleArea Enumeration

Represents the various areas which can have a format applied at the table style level.

Syntax

Visual Basic

'Declaration
 
Public Enum WorksheetTableStyleArea 
   Inherits System.Enum

C#

public enum WorksheetTableStyleArea : System.Enum 

Members

Member	Description
AlternateColumnStripe	The format is applied to the even numbered column stripes in the table.
AlternateRowStripe	The format is applied to the even numbered row stripes in the table.
ColumnStripe	The format is applied to the odd numbered column stripes in the table.
FirstColumn	The format is applied to the first column in the table.
FirstHeaderCell	The format is applied to the first header cell in the table.
FirstTotalCell	The format is applied to the first total cell in the table.
HeaderRow	The format is applied to the header row in the table.
LastColumn	The format is applied to the last column in the table.
LastHeaderCell	The format is applied to the last header cell in the table.
LastTotalCell	The format is applied to the last total cell in the table.
RowStripe	The format is applied to the odd numbered row stripes in the table.
TotalRow	The format is applied to the totals row in the table.
WholeTable	The format is applied to the entire table.

Remarks

Note: Only certain properties can be set on the table style are formats. The are as follows:

• BottomBorderColorInfo
• BottomBorderStyle
• IWorksheetCellFormat.Fill
• LeftBorderColorInfo
• LeftBorderStyle
• RightBorderColorInfo
• RightBorderStyle
• TopBorderColorInfo
• TopBorderStyle
• Font.Bold
• Font.ColorInfo
• Font.Italic
• Font.Strikeout
• Font.UnderlineStyle

Setting any other format or font properties on the table style areas will cause an exception.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2