Spread ASP.NET 18
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / Rows Property
Example


In This Topic
    Rows Property (SheetView)
    In This Topic
    Gets the rows in the data area of the sheet.
    Syntax
    'Declaration
     
    
    Public ReadOnly Property Rows As Rows
    'Usage
     
    
    Dim instance As SheetView
    Dim value As Rows
     
    value = instance.Rows
    public Rows Rows {get;}

    Property Value

    Rows object with the rows
    Remarks

    This property is available at run time only.

    This property allows reference to a row of cells or several rows of cells in the sheet.

    Example
    This example assigns a SheetView object to the active sheet and puts a border around all the cells in the first row.
    FarPoint.Web.Spread.SheetView sv=FpSpread1.ActiveSheetView;
    FarPoint.Web.Spread.Border bord=new FarPoint.Web.Spread.Border(BorderStyle.Dotted,Color.Teal,2);
    sv.Rows[0].Border=bord;
    Dim sv As FarPoint.Web.Spread.SheetView
    sv=FpSpread1.ActiveSheetView
    Dim bord As New FarPoint.Web.Spread.Border(BorderStyle.Dotted,Color.Teal,2)
    sv.Rows(0).Border=bord
    See Also