Skip to main content
.NET Framework 4.5.2+

WorksheetCollection.Item[String] Property

Gets a worksheet by its name.

Namespace: DevExpress.Spreadsheet

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


Worksheet this[string name] { get; }


Name Type Description
name String

A String value that specifies the name of the worksheet to get.

Property Value

Type Description

A Worksheet object that is the worksheet with the specified name.


Use the Item property to obtain a worksheet by its name from the workbook’s collection of worksheets. When searching, the name parameter value is compared to the Worksheet.Name property of worksheet objects. If no matches are found, an exception is thrown. To check whether a worksheet with the specified name exists in the collection, use the Contains property.

A worksheet can be also accessed by its index in the collection.


This example demonstrates how to access worksheets in a workbook. Use the Workbook.Worksheets property to get a collection of worksheets contained in a workbook (the WorksheetCollection object).

To get an individual worksheet by its index or name, use the WorksheetCollection.Item property.

using DevExpress.Spreadsheet;
// ...

Workbook workbook = new Workbook();

// Access a collection of worksheets.
WorksheetCollection worksheets = workbook.Worksheets;

// Access a worksheet by its index.
Worksheet worksheet1 = workbook.Worksheets[0];

// Access a worksheet by its name.
Worksheet worksheet2 = workbook.Worksheets["Sheet2"];
See Also