Cell.RowIndex Property

Gets the index of the row that contains the current cell.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

int RowIndex { get; }

VB.NET

ReadOnly Property RowIndex As Integer

Property Value

Type	Description
Int32	A zero-based integer value that specifies the index of the row containing the current cell.

Remarks

Use the RowIndex and Cell.ColumnIndex properties to obtain indexes of the row and column at the intersection of which the current cell is located. To get row and column headings, use the Row.Heading and Column.Heading properties.

To get the string that specifies a cell reference, call the CellRange.GetReferenceA1 or CellRange.GetReferenceR1C1 method for this cell.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the RowIndex property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

winforms-spreadsheet-custom-draw-example/CS/WindowsFormsApp1/Form1.cs#L121

var dataRange = e.Cell.Worksheet.GetDataRange();
if (e.Cell.IsIntersecting(dataRange) && e.Cell.RowIndex % 2 != 0)
{

winforms-spreadsheet-use-formula-engine/CS/FormulaEngineTest/Form1.cs#L65

int columnIndex = this.contextCell.ColumnIndex;
int rowIndex = this.contextCell.RowIndex;
// Create the expression context.

VB.NET

winforms-spreadsheet-custom-draw-example/VB/CustomDrawExample/Form1.vb#L114

' Otherwise, paint the row header in white.
Dim backColor As Color = If(e.IsHovered OrElse (e.RowIndex = spreadsheetControl1.ActiveCell.RowIndex),
    Color.FromArgb(200, 44, 74), ' Color 1

winforms-spreadsheet-use-formula-engine/VB/FormulaEngineTest/Form1.vb#L61

Dim columnIndex As Integer = Me.contextCell.ColumnIndex
Dim rowIndex As Integer = Me.contextCell.RowIndex
' Create the expression context.