Spread Windows Forms 10.0 Product Documentation
Sheets Property (SpreadView)
Example 


Gets the sheets in the view.
Syntax
'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;
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 Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

SpreadView Class
SpreadView Members

User-Task Documentation

Customizing the Appearance of a Sheet
Customizing Interaction with a Sheet

 

 


Copyright © GrapeCity, inc. All rights reserved.