General Information
.NET Subscription
Desktop
Web
Controls and Extensions
Mainteinance Mode
Enterprise and Analytic Tools
Quality Assurance and Productivity
Frameworks and Libraries
Table.Style Property
Gets or sets the style applied to the table.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v19.2.Core.dll
Declaration
Property Value
| Type | Description |
|---|---|
| TableStyle | A TableStyle object that specifies the table style. |
Property Value
| Type | Description |
|---|---|
| TableStyle | A TableStyle object that specifies the table style. |
Property Value
| Type | Description |
|---|---|
| TableStyle | A TableStyle object that specifies the table style. |
Remarks
When you create a new table, the default table style (TableStyleCollection.DefaultStyle) is automatically applied to the created table. Use the Style property to format a table with any style from the TableStyleCollection collection. By default, the style collection contains a set of built-in styles similar to Microsoft Excel and the None style, which specifies clear table formatting. Built-in styles are defined with the BuiltInTableStyleId enumeration.
Examples
The following code applies the BuiltInTableStyleId.TableStyleDark9 built-in style to a Table in a worksheet.
Note
A complete sample project is available at https://github.com/DevExpress-Examples/how-to-format-tables-e4909
spreadsheetControl1.BeginUpdate()
' Access the workbook's collection of table styles.
Dim tableStyles As TableStyleCollection = spreadsheetControl1.Document.TableStyles
' Access the built-in table style from the collection by its Id.
Dim tableStyle As TableStyle = tableStyles(BuiltInTableStyleId.TableStyleDark9)
' Apply the table style to the existing table.
Dim myTable As Table = spreadsheetControl1.ActiveWorksheet.Tables(0)
myTable.Style = tableStyle
' Show header and total rows.
myTable.ShowHeaders = True
myTable.ShowTotals = True
' Apply banded column formatting to the table.
myTable.ShowTableStyleRowStripes = False
myTable.ShowTableStyleColumnStripes = True
spreadsheetControl1.EndUpdate()