menu

ASP.NET MVC - EJ2

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Class Sheet - ASP.NETMVC-EJ2 API Reference | Syncfusion

    Show / Hide Table of Contents

    Class Sheet

    Inheritance
    System.Object
    Syncfusion.EJ2.EJTagHelper
    Sheet
    Namespace: Syncfusion.EJ2.Spreadsheet
    Assembly: Syncfusion.EJ2.dll
    Syntax
    public class Sheet : EJTagHelper

    Constructors

    Sheet()

    Declaration
    public Sheet()

    Properties

    ActiveCell

    Specifies active cell within selectedRange in the sheet.

    Declaration
    public string ActiveCell { get; set; }
    Property Value
    Type Description
    System.String

    The default value is "A1"

    ColCount

    Defines the number of columns to be rendered in the sheet.

    Declaration
    public int ColCount { get; set; }
    Property Value
    Type Description
    System.Int32

    The default value is 100

    Columns

    Configures column and its properties for the sheet.

    Declaration
    public List<Column> Columns { get; set; }
    Property Value
    Type Description
    System.Collections.Generic.List<Column>

    The default value is null

    ConditionalFormats

    Specifies the conditional formatting for the sheet.

    Declaration
    public List<ConditionalFormat> ConditionalFormats { get; set; }
    Property Value
    Type Description
    System.Collections.Generic.List<ConditionalFormat>

    The default value is null

    FrozenColumns

    Gets or sets the number of frozen columns.

    Declaration
    public int FrozenColumns { get; set; }
    Property Value
    Type Description
    System.Int32

    The default value is 0

    FrozenRows

    Gets or sets the number of frozen rows.

    Declaration
    public int FrozenRows { get; set; }
    Property Value
    Type Description
    System.Int32

    The default value is 0

    Index

    Specifies index of the sheet. Based on the index, sheet properties are applied.

    Declaration
    public int Index { get; set; }
    Property Value
    Type Description
    System.Int32

    The default value is 0

    IsProtected

    Specifies to protect the cells in the sheet.

    Declaration
    public bool IsProtected { get; set; }
    Property Value
    Type Description
    System.Boolean

    The default value is false

    Name

    Specifies the name of the sheet, the name will show in the sheet tabs.

    Declaration
    public string Name { get; set; }
    Property Value
    Type Description
    System.String

    The default value is ""

    PaneTopLeftCell

    Represents the freeze pane top left cell. Its default value would be based on the number of freeze rows and columns.

    Declaration
    public string PaneTopLeftCell { get; set; }
    Property Value
    Type Description
    System.String

    The default value is "A1"

    Password

    Specifies the password.

    Declaration
    public string Password { get; set; }
    Property Value
    Type Description
    System.String

    The default value is ""

    ProtectSettings

    Configures protect and its options.

    Declaration
    public SpreadsheetProtectSettings ProtectSettings { get; set; }
    Property Value
    Type Description
    SpreadsheetProtectSettings

    The default value is null

    Ranges

    Specifies the collection of range for the sheet.

    Declaration
    public List<Range> Ranges { get; set; }
    Property Value
    Type Description
    System.Collections.Generic.List<Range>

    The default value is null

    RowCount

    Defines the number of rows to be rendered in the sheet.

    Declaration
    public int RowCount { get; set; }
    Property Value
    Type Description
    System.Int32

    The default value is 100

    Rows

    Configures row and its properties for the sheet.

    Declaration
    public List<Row> Rows { get; set; }
    Property Value
    Type Description
    System.Collections.Generic.List<Row>

    The default value is null

    SelectedRange

    Specifies selected range in the sheet.

    Declaration
    public string SelectedRange { get; set; }
    Property Value
    Type Description
    System.String

    The default value is "A1:A1"

    ShowGridLines

    Specifies to show / hide grid lines in the sheet.

    Declaration
    public bool ShowGridLines { get; set; }
    Property Value
    Type Description
    System.Boolean

    The default value is true

    ShowHeaders

    Specifies to show / hide column and row headers in the sheet.

    Declaration
    public bool ShowHeaders { get; set; }
    Property Value
    Type Description
    System.Boolean

    The default value is true

    StandardHeight

    Represents the standard height of the sheet.

    Declaration
    public double StandardHeight { get; set; }
    Property Value
    Type Description
    System.Double

    The default value is Double.NaN

    State

    Specifies the sheet visibility state. There must be at least one visible sheet in Spreadsheet.

    Declaration
    public SheetState State { get; set; }
    Property Value
    Type Description
    SheetState

    The default value is SheetState.Visible

    TopLeftCell

    Specified cell will be positioned at the upper-left corner of the sheet.

    Declaration
    public string TopLeftCell { get; set; }
    Property Value
    Type Description
    System.String

    The default value is "A1"

    UsedRange

    Defines the used range of the sheet.

    Declaration
    public SpreadsheetUsedRange UsedRange { get; set; }
    Property Value
    Type Description
    SpreadsheetUsedRange

    The default value is null

    Back to top Generated by DocFX
    Copyright © 2001 - 2025 Syncfusion Inc. All Rights Reserved