SheetCollection.Item[String] Property
Provides access to an individual sheet in the collection by its name.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v24.1.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
Parameters
Name | Type | Description |
---|---|---|
name | String | A String value that specifies the name of the sheet to obtain. |
Property Value
Type | Description |
---|---|
Sheet | A worksheet or chart sheet with the specified name. |
Remarks
Use the Item property to obtain a sheet by its name from the workbook’s sheet collection. When searching, the name parameter value is compared to the Name property of worksheets and chart sheets contained in the workbook. If no matches are found, an exception is thrown. To check whether a sheet with the specified name exists in the collection, use the SheetCollection.Contains method.
A sheet can be also accessed by its index in the collection.