How to: Set Default Table Style

• Nov 13, 2018

This example demonstrates how to specify the default table style. This style is used in the following cases.

• If you create a table and do not explicitly specify a style to be applied to this table, the default style will be automatically applied to the created table.
• If you remove a table style that has been previously applied to a table, the table style will be changed to the default style.

Note

A complete sample project is available at https://github.com/DevExpress-Examples/how-to-format-tables-e4909

Form1.cs

void ChangeDefaultTableStyle(IWorkbook workbook, string styleName) {
    // Set the style to be applied to created tables by default.
    workbook.TableStyles.DefaultStyle = workbook.TableStyles[styleName];
}

Form1.vb

Private Sub ChangeDefaultTableStyle(ByVal workbook As IWorkbook, ByVal styleName As String)
    ' Set the style to be applied to created tables by default.
    workbook.TableStyles.DefaultStyle = workbook.TableStyles(styleName)
End Sub