Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / FpSpread Class / Rows Property
Example


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

    Property Value

    Rows object containing the rows in the data area of the currently selected sheet.
    Remarks
    This property is available at run time only.
    Example
    This example creates three row headers, displays letters in the first header and changes its background color to red. The first row displays a yellow border around its cells.
    FpSpread1.RowHeader.ColumnCount = 3;
    FpSpread1.RowHeader.AutoText = FarPoint.Web.Spread.HeaderAutoText.Letters;
    FpSpread1.RowHeader.AutoTextIndex = 0;
    FpSpread1.RowHeader.Columns[0].BackColor = Color.Red;
    FpSpread1.Rows[0].Border = new FarPoint.Web.Spread.Border(BorderStyle.Double, Color.Yellow, 2);
    
    FpSpread1.RowHeader.ColumnCount = 3
    FpSpread1.RowHeader.AutoText = FarPoint.Web.Spread.HeaderAutoText.Letters
    FpSpread1.RowHeader.AutoTextIndex = 0
    FpSpread1.RowHeader.Columns(0).BackColor = Color.Red
    FpSpread1.Rows(0).Border = New FarPoint.Web.Spread.Border(BorderStyle.Double, Color.Yellow, 2)
    
    See Also