Version

Style Property (WorksheetTable)

Gets or sets the style to use on the WorksheetTable.
Syntax
'Declaration
 
Public Property Style As WorksheetTableStyle
public WorksheetTableStyle Style {get; set;}

Property Value

The WorksheetTableStyle instance which defines the various default table area formats.
Exceptions
ExceptionDescription
System.ArgumentExceptionThe value specified is not in the CustomTableStyles or StandardTableStyles collections.
Remarks

The WorksheetTableStyle defines formats to use in various areas of the table. These formats are used as defaults for cells which don't have their formatting properties already set.

The area formats specified in the WorksheetTableStyle are differential formats. In other words, only the properties that are set to non-default values will be applied to the appropriate cells. An area format can define only a background color or only font information and that format will be applied to the cells while all other formatting properties on the cells will be maintained.

If this value is set to null, the Style will be set to the Workbook.DefaultTableStyle.

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