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 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6
See Also
Reference
FpSpread ClassFpSpread Members
ActiveSheetView Property
Add (Sheet) Method