Skip to main content
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

RowCollection.Item[Int32] Property

Provides indexed access to individual rows in the collection.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

Row this[int rowIndex] { get; }

#Parameters

Name Type Description
rowIndex Int32

A zero-based integer specifying the desired row’s position within the collection. If it’s negative or exceeds the last available index (a worksheet limits the number of rows to 1048576), an exception is raised.

#Property Value

Type Description
Row

A Row object which specifies the row at the specified position.

#Remarks

Use the Item property to access individual rows using index notation.

Row_Column_Indexes

#Example

This example demonstrates how to access rows in a worksheet. Use the Worksheet.Rows property to get a collection of rows contained in a worksheet (the RowCollection object). To get an individual row by its index (zero-based) or heading (“1”, “2”, “3”, etc.), use the RowCollection.Item property.

using DevExpress.Spreadsheet;
// ...

Workbook workbook = new Workbook();

// Access a collection of rows.
RowCollection rows = workbook.Worksheets[0].Rows;

// Access the first row by its index in the collection of rows.
Row firstRow_byIndex = rows[0];

// Access the first row by its unique name.
Row firstRow_byName = rows["1"];
See Also