ActiveSheetViewIndex Property

Gets or sets the currently selected sheet in the Spread component.

Syntax

Visual Basic
C#

'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;

Visual Basic

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 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

FpSpread Class
FpSpread Members
ActiveSheetView Property
Add (Sheet) Method

User-Task Documentation

Working with the Active Sheet