Class Sheet
Inherited Members
Namespace: Syncfusion.EJ2.Spreadsheet
Assembly: Syncfusion.EJ2.dll
Syntax
public class Sheet : EJTagHelperConstructors
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 |
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 |