Spread for ASP.NET 8.0 Product Documentation
ActiveSheetViewIndex Property
Example 


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
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 Class
FpSpread Members
ActiveSheetView Property
Add (Sheet) Method

User-Task Documentation

Working with the Active Sheet

 

 


Copyright © GrapeCity, inc. All rights reserved.