.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

Style Interface

A named cell style.

Namespace: DevExpress.Spreadsheet

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

Declaration

public interface Style :
    Formatting
Public Interface Style
    Inherits Formatting
public interface Style :
    Formatting
Public Interface Style
    Inherits Formatting
public interface Style :
    Formatting
Public Interface Style
    Inherits Formatting

Remarks

A style is a named set of predefined cell format characteristics. When applying a style, all format settings are applied to a cell or cell range in a single step. Cell styles are represented by the Style objects and contained within the StyleCollection collection accessible via the IWorkbook.Styles property. This collection includes a set of built-in styles (similar to Microsoft® Excel®) that can be obtained by the corresponding BuiltInStyleId enumeration members and custom styles that can be accessed by their names (Style.Name). Built-in cell styles (including the Normal style, which is applied to all unformatted cells) are contained in the collection by default, while custom styles can be added via the StyleCollection.Add method.

A style object provides a set of properties inherited from the Formatting interface that allow you to modify format attributes of the style. For details, see the How to: Create or Modify a Style example.

To apply a style to a cell or range of cells, use the CellRange.Style property (see the How to: Apply a Style to a Cell or Range of Cells example).

Examples

This example demonstrates how to format a cell, a range of cells, an entire row or an entire column by applying a style.

  1. Access the Style object that specifies the style to be applied to a cell or a range of cells. This style should be added to the IWorkbook.Styles collection.
  2. Assign the required style object to the CellRange.Style property of the cell, cell range, row or column object.
// Access the built-in "Good" MS Excel style from the Styles collection of the workbook.
Style styleGood = workbook.Styles[BuiltInStyleId.Good];

// Apply the "Good" style to a range of cells.
worksheet.Range["A1:C4"].Style = styleGood;

// Access a custom style that has been previously created in the loaded document by its name.
Style customStyle = workbook.Styles["Custom Style"];

// Apply the custom style to the cell.
worksheet.Cells["D6"].Style = customStyle;

// Apply the "Good" style to the eighth row.
worksheet.Rows[7].Style = styleGood;

// Apply the custom style to the "H" column.
worksheet.Columns["H"].Style = customStyle;
See Also