Provides access to the collection of cell styles in the current workbook.
A StyleCollection collection containing cell styles.
By default, StyleCollection contains Microsoft® Excel® built-in styles, including the Normal style that is applied to cells by default (StyleCollection.DefaultStyle). You can create custom styles, as well as copy, modify or delete existing styles (see the How to: Create or Modify a Style example).
This example demonstrates how to format a cell, a range of cells, an entire row or an entire column by applying a style.
- 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.
- Assign the required style object to the CellRange.Style property of the cell, cell range, row or column object.
A complete sample project is available at https://github.com/DevExpress-Examples/winforms-spreadsheetcontrol-api-e4655
// 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.Style = styleGood; // Apply the custom style to the "H" column. worksheet.Columns["H"].Style = customStyle;