Version

WorksheetTableStyleArea Enumeration

Represents the various areas which can have a format applied at the table style level.
Syntax
'Declaration
 
Public Enum WorksheetTableStyleArea 
   Inherits System.Enum
public enum WorksheetTableStyleArea : System.Enum 
Members
MemberDescription
AlternateColumnStripeThe format is applied to the even numbered column stripes in the table.
AlternateRowStripeThe format is applied to the even numbered row stripes in the table.
ColumnStripeThe format is applied to the odd numbered column stripes in the table.
FirstColumnThe format is applied to the first column in the table.
FirstHeaderCellThe format is applied to the first header cell in the table.
FirstTotalCellThe format is applied to the first total cell in the table.
HeaderRowThe format is applied to the header row in the table.
LastColumnThe format is applied to the last column in the table.
LastHeaderCellThe format is applied to the last header cell in the table.
LastTotalCellThe format is applied to the last total cell in the table.
RowStripeThe format is applied to the odd numbered row stripes in the table.
TotalRowThe format is applied to the totals row in the table.
WholeTableThe 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:

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 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

See Also