BuiltInTableStyleId Enum

Lists built-in styles similar to Excel’s built-in table styles.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v22.1.Core.dll

Declaration

C#

public enum BuiltInTableStyleId

VB.NET

Public Enum BuiltInTableStyleId

Members

Name	Description
TableStyleLight1
TableStyleLight2
TableStyleLight3
TableStyleLight4
TableStyleLight5
TableStyleLight6
TableStyleLight7
TableStyleLight8
TableStyleLight9
TableStyleLight10
TableStyleLight11
TableStyleLight12
TableStyleLight13
TableStyleLight14
TableStyleLight15
TableStyleLight16
TableStyleLight17
TableStyleLight18
TableStyleLight19
TableStyleLight20
TableStyleLight21
TableStyleMedium1
TableStyleMedium2
TableStyleMedium3
TableStyleMedium4
TableStyleMedium5
TableStyleMedium6
TableStyleMedium7
TableStyleMedium8
TableStyleMedium9
TableStyleMedium10
TableStyleMedium11
TableStyleMedium12
TableStyleMedium13
TableStyleMedium14
TableStyleMedium15
TableStyleMedium16
TableStyleMedium17
TableStyleMedium18
TableStyleMedium19
TableStyleMedium20
TableStyleMedium21
TableStyleMedium22
TableStyleMedium23
TableStyleMedium24
TableStyleMedium25
TableStyleMedium26
TableStyleMedium27
TableStyleMedium28
TableStyleDark1
TableStyleDark2
TableStyleDark3
TableStyleDark4
TableStyleDark5
TableStyleDark6
TableStyleDark7
TableStyleDark8
TableStyleDark9
TableStyleDark10
TableStyleDark11

Remarks

Use the TableStyleCollection.Item to obtain the built-in style by its Id. To apply the style to a table, use the Table.Style method.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the BuiltInTableStyleId enum.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

VB.NET

spreadsheet-document-api-examples-part-2-t217615/VB/SpreadsheetDocServerAPIPart2/CodeExamples/TableActions.vb#L19

            ' Format the table by applying a built-in table style.
            table.Style = workbook.TableStyles(BuiltInTableStyleId.TableStyleMedium20)
'            #End Region ' #CreateTable

how-to-format-tables-e4909/VB/TableBuiltInStyleExample/Form1.vb#L88

Try
    Dim builtInTableStyleIds As Array = System.Enum.GetValues(GetType(BuiltInTableStyleId))
    For i As Integer = 0 To builtInTableStyleIds.Length - 1

how-to-bind-a-worksheet-to-a-generic-list-or-a-bindinglist-data-source-t480285/VB/DataBindingToListExample/Form1.vb#L77

Dim sheetDataBinding As WorksheetTableDataBinding = sheet.DataBindings.BindTableToDataSource(weatherDatasource, bindingRange, dsOptions)
sheetDataBinding.Table.Style = spreadsheetControl1.Document.TableStyles(BuiltInTableStyleId.TableStyleMedium14)

wpf-spreadsheetcontrol-api-part-2-e4944/VB/SpreadsheetControl_WPF_API_Part02/SpreadsheetActions/TableActions.vb#L31

' Format the table by applying a built-in table style.
table.Style = workbook.TableStyles(BuiltInTableStyleId.TableStyleMedium27)

how-to-import-data-to-worksheet-cells-from-different-data-sources-and-use-tables-e4751/VB/DataImportExample/Form1.vb#L95

' Format the table by applying a built-in table style.
table.Style = spreadsheetControl1.Document.TableStyles(BuiltInTableStyleId.TableStyleMedium27)

C#

spreadsheet-document-api-examples-part-2-t217615/CS/SpreadsheetDocServerAPIPart2/CodeExamples/TableActions.cs#L18

// Format the table by applying a built-in table style.
table.Style = workbook.TableStyles[BuiltInTableStyleId.TableStyleMedium20];
#endregion #CreateTable

how-to-format-tables-e4909/CS/TableBuiltInStyleExample/Form1.cs#L88

try {
    Array builtInTableStyleIds = Enum.GetValues(typeof(BuiltInTableStyleId));
    for (int i = 0; i < builtInTableStyleIds.Length; i++) {

how-to-bind-a-worksheet-to-a-generic-list-or-a-bindinglist-data-source-t480285/CS/DataBindingToListExample/Form1.cs#L76

WorksheetTableDataBinding sheetDataBinding = sheet.DataBindings.BindTableToDataSource(weatherDatasource, bindingRange, dsOptions);
sheetDataBinding.Table.Style = spreadsheetControl1.Document.TableStyles[BuiltInTableStyleId.TableStyleMedium14];

wpf-spreadsheetcontrol-api-part-2-e4944/CS/SpreadsheetControl_WPF_API_Part02/SpreadsheetActions/TableActions.cs#L30

// Format the table by applying a built-in table style.
table.Style = workbook.TableStyles[BuiltInTableStyleId.TableStyleMedium27];

how-to-import-data-to-worksheet-cells-from-different-data-sources-and-use-tables-e4751/CS/DataImportExample/Form1.cs#L100

// Format the table by applying a built-in table style.
table.Style = spreadsheetControl1.Document.TableStyles[BuiltInTableStyleId.TableStyleMedium27];