Class Sheet
Inheritance
System.Object
Sheet
Assembly: Syncfusion.EJ2.dll
Syntax
public class Sheet : EJTagHelper
Constructors
Sheet()
Declaration
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> |
|
Specifies the conditional formatting for the sheet.
Declaration
public List<ConditionalFormat> ConditionalFormats { get; set; }
Property Value
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
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 |
|
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
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