Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / Row Class / Index Property
Example


In This Topic
    Index Property (Row)
    In This Topic
    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)
    See Also