Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / FpSpread Class / Sheets Property

In This Topic
    Sheets Property
    In This Topic
    Gets a collection of sheets for the Spread component.
    Public ReadOnly Property Sheets As SheetViewCollection
    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.
    This property returns a collection of sheets, which are SheetView objects.
    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