Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Property ActiveSheetViewIndex As Integer | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As FpSpread Dim value As Integer instance.ActiveSheetViewIndex = value value = instance.ActiveSheetViewIndex | |
| C# | |
|---|---|
public int ActiveSheetViewIndex {get; set;} | |
Property Value
Integer index of the currently selected sheetRemarks
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.
| C# | Copy Code |
|---|---|
FpSpread1.Sheets.Count=3; FpSpread1.ActiveSheetViewIndex=1; FpSpread1.ActiveSheetView.AlternatingRows[0].BackColor=Color.Yellow; FpSpread1.ActiveSheetView.AlternatingRows[1].BackColor=Color.YellowGreen; | |
| Visual Basic | Copy Code |
|---|---|
FpSpread1.Sheets.Count=3 FpSpread1.ActiveSheetViewIndex=1 FpSpread1.ActiveSheetView.AlternatingRows(0).BackColor=Color.Yellow FpSpread1.ActiveSheetView.AlternatingRows(1).BackColor=Color.YellowGreen | |
Requirements
Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family
See Also
Reference
FpSpread ClassFpSpread Members
ActiveSheetView Property
Add (Sheet) Method