Spread ASP.NET 17
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / FpSpread Class / ActiveSheetViewIndex Property
Example


In This Topic
    ActiveSheetViewIndex Property
    In This Topic
    Gets or sets the currently selected sheet in the Spread component.
    Syntax
    'Declaration
 

    Public Property ActiveSheetViewIndex As Integer
    'Usage
 

    Dim instance As FpSpread
Dim value As Integer
 
instance.ActiveSheetViewIndex = value
 
value = instance.ActiveSheetViewIndex
    public int ActiveSheetViewIndex {get; set;}

    Property Value

    Integer index of the currently selected sheet
    Remarks

    Use this property to specify the sheet number of the active sheet. The active sheet is displayed on top of the other sheets. Sheets are zero-based (the first sheet is worksheet 0).

    Use the SheetViewCollection Add method to add sheets to the component.

    Example
    This example creates a spreadsheet with three sheets, sets the second sheet to be the active sheet and changes the BackColor of the AlternatingRows.
    FpSpread1.Sheets.Count=3;
FpSpread1.ActiveSheetViewIndex=1;
FpSpread1.ActiveSheetView.AlternatingRows[0].BackColor=Color.Yellow;
FpSpread1.ActiveSheetView.AlternatingRows[1].BackColor=Color.YellowGreen;
    FpSpread1.Sheets.Count=3
FpSpread1.ActiveSheetViewIndex=1
FpSpread1.ActiveSheetView.AlternatingRows(0).BackColor=Color.Yellow
FpSpread1.ActiveSheetView.AlternatingRows(1).BackColor=Color.YellowGreen
    See Also

    Reference

    FpSpread Class
    FpSpread Members
    ActiveSheetView Property
    Add (Sheet) Method

    User-Task Documentation

    Working with the Active Sheet