Gets the ending index for this range of rows.
Syntax
| Visual Basic (Declaration) | |
|---|
Public ReadOnly Property Index2 As Integer |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As Row
Dim value As Integer
value = instance.Index2 |
| C# | |
|---|
public int Index2 {get;} |
Property Value
Integer index (zero-based) of the row at the end of the range
Remarks
Example
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# | Copy Code |
|---|
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<FpSpread1.ActiveSheetView.RowCount;i++)
{
FpSpread1.ActiveSheetView.SetValue(i,1,"Alignment");
}
TextBox1.Text=Convert.ToString(myrow.Index2); |
| Visual Basic | Copy Code |
|---|
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) |
Requirements
Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family
See Also
