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>

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

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