officefileapi-devexpress-dot-spreadsheet-dot-cell-3b18b009.md
Gets the index of the row that contains the current cell.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
int RowIndex { get; }
ReadOnly Property RowIndex As Integer
| Type | Description |
|---|---|
| Int32 |
A zero-based integer value that specifies the index of the row containing the current cell.
|
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.
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.
winforms-spreadsheet-use-formula-engine/CS/FormulaEngineTest/Form1.cs#L65
int columnIndex = this.contextCell.ColumnIndex;
int rowIndex = this.contextCell.RowIndex;
// Create the expression context.
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/VB/FormulaEngineTest/Form1.vb#L61
Dim columnIndex As Integer = Me.contextCell.ColumnIndex
Dim rowIndex As Integer = Me.contextCell.RowIndex
' Create the expression context.
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
See Also