Spread Windows Forms 7.0 Product Documentation
Sheets Property
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SpreadView Class : Sheets Property


Glossary Item Box

Gets the sheets in the view.

Syntax

Visual Basic (Declaration) 
Public ReadOnly Property Sheets As SheetViewCollection
Visual Basic (Usage)Copy Code
Dim instance As SpreadView
Dim value As SheetViewCollection
 
value = instance.Sheets
C# 
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.
C#Copy Code
FarPoint.Win.Spread.SpreadView sv = fpSpread1.GetRootWorkbook();
sv.Sheets.Count = 3;
sv.ActiveSheetIndex = 2;
VB.NETCopy Code
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

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.