.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

TableStyle.Duplicate() Method

Creates a copy of this table or PivotTable style.

Namespace: DevExpress.Spreadsheet

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


TableStyle Duplicate()


Type Description

A copy of the current style.


You can create a custom style based on an existing table or PivotTable style (for example, a built-in style). Call the TableStyle.Duplicate method to create a copy of the specified style. This method returns a TableStyle object that allows you to define format settings for the new style.


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

// 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;

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

Custom Spreadsheet Table Style

See Also