Spread for ASP.NET 11 Product Documentation
ActiveSheetViewIndex Property
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > FpSpread Class : ActiveSheetViewIndex Property
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