Back to Devexpress

Row.Index Property

officefileapi-devexpress-dot-spreadsheet-dot-row-a83b616b.md

latest2.6 KB
Original Source

Row.Index Property

Gets the zero-based index of the row within the worksheet’s RowCollection.

Namespace : DevExpress.Spreadsheet

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

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp
int Index { get; }
vb
ReadOnly Property Index As Integer

Property Value

TypeDescription
Int32

An integer specifying the position of the row in the worksheet.

|

Remarks

Each worksheet contains 1,048,576 rows stored in the collection returned by the Worksheet.Rows property (the RowCollection object). You can access an individual row by its zero-based index or heading (see the How to: Access a Row or Column example).

The Index property returns the row index. To obtain the row heading displayed at the left of a worksheet, use the Row.Heading property.

To obtain the index of the row that contains the specified cell, use the Cell.RowIndex property. To get indexes of rows that border the cell range, use the CellRange.TopRowIndex and CellRange.BottomRowIndex properties.

See Also

Index

Rows and Columns in Spreadsheet Documents

How to: Access a Row or Column

Row Interface

Row Members

DevExpress.Spreadsheet Namespace