officefileapi-devexpress-dot-spreadsheet-dot-tablestyleelement-f15ae4b0.md
Clears formatting for the table style element.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
void Clear()
Sub Clear
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
// 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;
' 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®).
See Also