Index Property (Row)

Gets the index of this row, or the starting index for this range of rows.

Syntax

Visual Basic
C#

'Declaration
 
Public ReadOnly Property Index As Integer

'Usage
 
Dim instance As Row
Dim value As Integer
 
value = instance.Index

public int Index {get;}

Property Value

Integer index (zero-based) of the row at the start of the range

Remarks

If you are specifying a range of rows, use the Index2 property to specify the end index for the range.

Row objects returned by the Rows object's Default property always have an index of -1.

Example

This example creates a Row object and adjusts the alignment of the text in the second row. The width of the column is changed so that the alignment changes can be easily seen. The index of the row object is returned to a text box.

FpSpread1.ActiveSheetView.ColumnCount=10;
FpSpread1.ActiveSheetView.PageSize=20;
FpSpread1.ActiveSheetView.RowCount=20;
FarPoint.Web.Spread.Rowmyrow;
myrow=FpSpread1.ActiveSheetView.Rows[1];
myrow.HorizontalAlign=HorizontalAlign.Right;
myrow.VerticalAlign=VerticalAlign.Top;
For(inti=0;i&lt;FpSpread1.ActiveSheetView.RowCount;i++)
{
FpSpread1.ActiveSheetView.SetValue(i,1,"Alignment");
FpSpread1.ActiveSheetView.Columns[1].Width=140;
}
TextBox1.Text=Convert.ToString(myrow.Index);

Visual Basic

FpSpread1.ActiveSheetView.ColumnCount=10
FpSpread1.ActiveSheetView.PageSize=20
FpSpread1.ActiveSheetView.RowCount=20
DimmyrowAsFarPoint.Web.Spread.Row
Dimrow,iAsInteger
row=1
myrow=FpSpread1.ActiveSheetView.Rows(row)
myrow.HorizontalAlign=HorizontalAlign.Right
myrow.VerticalAlign=VerticalAlign.Top
Fori=0ToFpSpread1.ActiveSheetView.RowCount-1
FpSpread1.ActiveSheetView.SetValue(i,1,"Alignment")
FpSpread1.ActiveSheetView.Columns(1).Width=140
Nexti
TextBox1.Text=Convert.ToString(myrow.Index)

Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

Row Class
Row Members
Index2 Property
Default Property