SheetCollection.Item[String] Property

Provides access to an individual sheet in the collection by its name.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

Sheet this[string name] { get; }

VB.NET

ReadOnly Property Item(name As String) As Sheet

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.