Spread ASP.NET 17
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

    Reference

    SheetView Class
    SheetView Members
    Rows Class

    User-Task Documentation

    Customizing the Appearance of Rows and Columns