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 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

FpSpread Class
FpSpread Members
SheetViewCollection Class
SheetView Class

User-Task Documentation

Customizing the Appearance of the Sheet