Sheets Property

Gets a collection of sheets for the Spread component.

Syntax

Visual Basic
C#

'Declaration
 
Public ReadOnly Property Sheets As SheetViewCollection

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

public SheetViewCollection Sheets {get;}

Property Value

SheetViewCollection object containing the sheets in the component.

Remarks

This property returns a collection of sheets, which are SheetView objects.

Example

This example shows how to use the Sheets property to set properties an entire sheet or group of sheets.

FpSpread1.Sheets[0].DefaultStyle.ForeColor = Color.Teal;
FpSpread1.Sheets[0].DefaultStyle.Font.Bold = True;
FpSpread1.Sheets[0].DefaultStyle.Font.Name = "Comic Sans MS";
FpSpread1.Sheets[0].DefaultStyle.Font.Size = FontUnit.Point(12);
FpSpread1.Sheets[0].DefaultStyle.Font.Italic = True;

Visual Basic

FpSpread1.Sheets.Count = 2
Dim fun As New System.Web.UI.WebControls.FontUnit(12)
FpSpread1.Sheets(0).DefaultStyle.ForeColor = Color.Teal
FpSpread1.Sheets(0).DefaultStyle.Font.Bold = True
FpSpread1.Sheets(0).DefaultStyle.Font.Name = "Comic Sans MS"
FpSpread1.Sheets(0).DefaultStyle.Font.Size = fun
FpSpread1.Sheets(0).DefaultStyle.Font.Italic = True

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

FpSpread Class
FpSpread Members
SheetViewCollection Class
SheetView Class

User-Task Documentation

Customizing the Appearance of the Sheet