Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / AlternatingRows Property
Example


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

    Property Value

    AlternatingRows object
    Remarks

    This property is available at run time only.

    Use this property to return the alternating rows settings object for the spreadsheet data area or the spreadsheet headers. The settings are returned in an AlternatingRows object.

    Example
    This example assigns a SheetView object to the active sheet and adds another Alternating Row to the default value of 2. The colors of the rows are each set to a new value.
    FarPoint.Web.Spread.SheetView sv = FpSpread1.ActiveSheetView;
    sv.AlternatingRows.Count = 3;
    sv.AlternatingRows[0].BackColor = Color.Yellow;
    sv.AlternatingRows[1].BackColor = Color.GreenYellow;
    sv.AlternatingRows[2].BackColor = Color.Tomato;
    
    Dim sv As FarPoint.Web.Spread.SheetView
    sv = FpSpread1.ActiveSheetView
    sv.AlternatingRows.Count = 3
    sv.AlternatingRows(0).BackColor = Color.Yellow
    sv.AlternatingRows(1).BackColor = Color.GreenYellow
    sv.AlternatingRows(2).BackColor = Color.Tomato
    See Also