officefileapi-devexpress-dot-spreadsheet-dot-stylecollection-dot-item-x28-devexpress-dot-spreadsheet-dot-builtinstyleid-x29.md
Provides access to individual built-in styles in the collection by their identifiers.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
Style this[BuiltInStyleId id] { get; }
ReadOnly Property Item(id As BuiltInStyleId) As Style
| Name | Type | Description |
|---|---|---|
| id | BuiltInStyleId |
An identifier of the built-in style to return.
|
| Type | Description |
|---|---|
| Style |
The built-in style with the specified identifier.
|
The IWorkbook.Styles collection contains built-in cell styles similar to Microsoft® Excel®. You can obtain these styles by their identifiers (the BuiltInStyleId enumeration members).
You can also access a style by its name or index in the collection.
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 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;
' Access the built-in "Good" MS Excel style from the Styles collection of the workbook.
Dim styleGood As Style = 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.
Dim customStyle As Style = 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
How to: Apply a Style to a Cell or Range of Cells