Spread Windows Forms 12.0 Product Documentation
Sheets Property (FpSpread)

FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > FpSpread Class : Sheets Property
Gets the sheets (SheetView objects) in the component.
Public ReadOnly Property Sheets As SheetViewCollection
Dim instance As FpSpread
Dim value As SheetViewCollection
value = instance.Sheets
public SheetViewCollection Sheets {get;}

Property Value

SheetViewCollection object containing the collection of sheets

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

This example sets the number of sheets for the Spread component and the amount of space the tab strip occupies.
FarPoint.Win.Spread.FpSpread fpSpread1 = new FarPoint.Win.Spread.FpSpread();
FarPoint.Win.Spread.SheetView shv = new FarPoint.Win.Spread.SheetView();
fpSpread1.Location = new Point(10, 10);
fpSpread1.Height = 200;
fpSpread1.Width = 400;
fpSpread1.TabStripPolicy = FarPoint.Win.Spread.TabStripPolicy.Always;
fpSpread1.TabStripRatio = 0.75;
fpSpread1.Sheets.Count = 3;
fpSpread1.TabStrip[0].BackColor = Color.LightBlue;
Dim fpSpread1 As New FarPoint.Win.Spread.FpSpread()
Dim shv As New FarPoint.Win.Spread.SheetView()
fpSpread1.Location = New Point(10, 10)
fpSpread1.Height = 200
fpSpread1.Width = 400
fpSpread1.TabStripPolicy = FarPoint.Win.Spread.TabStripPolicy.Always
fpSpread1.TabStripRatio = 0.75
fpSpread1.Sheets.Count = 3
fpSpread1.TabStrip(0).BackColor = Color.LightBlue
See Also


FpSpread Class
FpSpread Members

User-Task Documentation

Customizing the Appearance of a Sheet
Customizing Interaction with a Sheet