Class Sheet

Inheritance
System.Object
EJTagHelper
Sheet
Inherited Members
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

ColCount

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

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

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>

ConditionalFormats

Specifies the conditional formatting for the sheet.

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

FrozenColumns

Gets or sets the number of frozen columns.

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

FrozenRows

Gets or sets the number of frozen rows.

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

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

IsChild

Declaration
protected override bool IsChild { get; }
Property Value
Type Description
System.Boolean
Overrides

IsProtected

Specifies to protect the cells in the sheet.

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

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

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

Password

Specifies the password.

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

ProtectSettings

Configures protect and its options.

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

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>

RowCount

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

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

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>

SelectedRange

Specifies selected range in the sheet.

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

ShowGridLines

Specifies to show / hide grid lines in the sheet.

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

ShowHeaders

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

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

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

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

UsedRange

Defines the used range of the sheet.

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