Spread for ASP.NET 8.0 Product Documentation
Index Property (Row)
Example 


Gets the index of this row, or the starting index for this range of rows.
Syntax
'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<FpSpread1.ActiveSheetView.RowCount;i++)
{
FpSpread1.ActiveSheetView.SetValue(i,1,"Alignment");
FpSpread1.ActiveSheetView.Columns[1].Width=140;
}
TextBox1.Text=Convert.ToString(myrow.Index);
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 Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

Row Class
Row Members
Index2 Property
Default Property

 

 


Copyright © GrapeCity, inc. All rights reserved.