TableStyleElement.Clear() Method

Clears formatting for the table style element.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v23.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

void Clear()

VB.NET

Sub Clear

Example

The code snippet below creates a copy of a predefined table style and changes the header row color for the new style.

View Example: Create and Format Spreadsheet Tables

Form1.cs

// Access worksheet tables.
Table table1 = worksheet.Tables[0];
Table table2 = worksheet.Tables[1];

// Return a table style you want to duplicate.
TableStyle sourceTableStyle = workbook.TableStyles[BuiltInTableStyleId.TableStyleMedium17];

// Duplicate the table style.
TableStyle newTableStyle = sourceTableStyle.Duplicate();

// Modify the new table style.
// Change background color for the header row.
newTableStyle.TableStyleElements[TableStyleElementType.HeaderRow].Fill.BackgroundColor = Color.FromArgb(0xA7, 0xEA, 0x52);

table1.Style = sourceTableStyle;
table2.Style = newTableStyle;

Form1.vb

' Access worksheet tables.
Dim table1 As Table = worksheet.Tables(0)
Dim table2 As Table = worksheet.Tables(1)

' Return a table style you want to duplicate.
Dim sourceTableStyle As TableStyle = workbook.TableStyles(BuiltInTableStyleId.TableStyleMedium17)

' Duplicate the table style.
Dim newTableStyle As TableStyle = sourceTableStyle.Duplicate()

' Modify the new table style.
' Change background color for the header row.
newTableStyle.TableStyleElements(TableStyleElementType.HeaderRow).Fill.BackgroundColor = Color.FromArgb(&HA7, &HEA, &H52)

table1.Style = sourceTableStyle
table2.Style = newTableStyle

The image below shows the built-in TableStyleMedium17 style and its modified copy (the workbook is opened in Microsoft® Excel®).