Index2 Property (Row)

Visual Basic
C#

'Declaration
 
Public ReadOnly Property Index2 As Integer

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

public int Index2 {get;}

Property Value

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

Use the Index property to specify the starting index for the range.

This example creates a Row object with multiple columns and rows, and adjusts the alignment of the text in some of the rows. The width of the column is changed so that the alignment changes can be easily seen. The Index2 of the Row object is returned to a text box.

C#

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

Visual Basic

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

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

Row Class
Row Members
Index Property