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 Basic | Copy 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 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family
See Also
Reference
FpSpread ClassFpSpread Members
SheetViewCollection Class
SheetView Class