Sheets Property (SpreadView)

Gets the sheets in the view.

Syntax

Visual Basic
C#

'Declaration
 
Public ReadOnly Property Sheets As SheetViewCollection

'Usage
 
Dim instance As SpreadView
Dim value As SheetViewCollection
 
value = instance.Sheets

public SheetViewCollection Sheets {get;}

Property Value

SheetViewCollection object containing the collection of sheets

Remarks

Use this property to work with individual sheets by specifying the sheet index, then setting properties for the specified object. The sheet index is zero-based; the first sheet is index 0.

Within a sheet object, use these properties (corresponding to shortcut objects) with indexes to set properties for those objects

Example

This example sets the Sheets property.

FarPoint.Win.Spread.SpreadView sv = fpSpread1.GetRootWorkbook();
sv.Sheets.Count = 3;
sv.ActiveSheetIndex = 2;

VB.NET

Dim sv As FarPoint.Win.Spread.SpreadView = FpSpread1.GetRootWorkbook
sv.Sheets.Count = 3
sv.ActiveSheetIndex = 2

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Reference

SpreadView Class
SpreadView Members

User-Task Documentation

Customizing the Appearance of a Sheet
Customizing Interaction with a Sheet