Class Sheet

Inheritance
System.Object
TagHelper
EJTagHelper
Sheet
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
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
[HtmlAttributeName("activeCell")]
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
[HtmlAttributeName("colCount")]
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
[HtmlAttributeName("columns")]
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
[HtmlAttributeName("conditionalFormats")]
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
[HtmlAttributeName("frozenColumns")]
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
[HtmlAttributeName("frozenRows")]
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
[HtmlAttributeName("index")]
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
[HtmlAttributeName("isProtected")]
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
[HtmlAttributeName("name")]
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
[HtmlAttributeName("paneTopLeftCell")]
public string PaneTopLeftCell { get; set; }
Property Value
Type Description
System.String

The default value is "A1"

Password

Specifies the password.

Declaration
[HtmlAttributeName("password")]
public string Password { get; set; }
Property Value
Type Description
System.String

The default value is ""

ProtectSettings

Configures protect and its options.

Declaration
[HtmlAttributeName("protectSettings")]
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
[HtmlAttributeName("ranges")]
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
[HtmlAttributeName("rowCount")]
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
[HtmlAttributeName("rows")]
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
[HtmlAttributeName("selectedRange")]
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
[HtmlAttributeName("showGridLines")]
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
[HtmlAttributeName("showHeaders")]
public bool ShowHeaders { get; set; }
Property Value
Type Description
System.Boolean

The default value is true

State

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

Declaration
[HtmlAttributeName("state")]
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
[HtmlAttributeName("topLeftCell")]
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
[HtmlAttributeName("usedRange")]
public SpreadsheetUsedRange UsedRange { get; set; }
Property Value
Type Description
SpreadsheetUsedRange

The default value is null