Spread for ASP.NET 7.0 Product Documentation
Sheets Property
See Also  Example Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > FpSpread Class : Sheets Property


Glossary Item Box

Gets a collection of sheets for the Spread component.

Syntax

Visual Basic (Declaration) 
Public ReadOnly Property Sheets As SheetViewCollection
Visual Basic (Usage)Copy Code
Dim instance As FpSpread
Dim value As SheetViewCollection
 
value = instance.Sheets
C# 
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.
C#Copy Code
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 BasicCopy Code
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

See Also

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