Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / FpSpread Class / Sheets Property
Example


In This Topic
    Sheets Property
    In This Topic
    Gets a collection of sheets for the Spread component.
    Syntax
    '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;
    
    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
    
    See Also