e-sheet
directive represent a sheet of the Angular Spreadsheet.
It must be contained in a Spreadsheet component(ejs-spreadsheet
).
<ejs-spreadsheet>
<e-sheets>
<e-sheet></e-sheet>
<e-sheet></e-sheet>
</e-sheets>
</ejs-spreadsheet>
any
Specifies active cell within selectedRange
in the sheet.
Defaults to ‘A1’
any
Defines the number of columns to be rendered in the sheet.
Defaults to 100
any
Configures column and its properties for the sheet.
Defaults to null
any
Specifies the conditional formatting for the sheet.
Defaults to []
any
Gets or sets the number of frozen columns.
Defaults to 0
any
Gets or sets the number of frozen rows.
Defaults to 0
any
Specifies index of the sheet. Based on the index, sheet properties are applied.
Defaults to 0
any
Specifies to protect the cells in the sheet.
Defaults to false
any
Specifies the name of the sheet, the name will show in the sheet tabs.
Defaults to ”
any
Represents the freeze pane top left cell. Its default value would be based on the number of freeze rows and columns.
Defaults to ‘A1’
any
Specifies the password.
Defaults to ”
any
Configures protect and its options.
Defaults to { selectCells: false, formatCells: false, formatRows: false, formatColumns: false, insertLink: false }
any
Specifies the collection of range for the sheet.
Defaults to []
any
Defines the number of rows to be rendered in the sheet.
Defaults to 100
any
Configures row and its properties for the sheet.
Defaults to null
any
Specifies selected range in the sheet.
Defaults to ‘A1:A1’
any
Specifies to show / hide grid lines in the sheet.
Defaults to true
any
Specifies to show / hide column and row headers in the sheet.
Defaults to true
any
Represents the standard height of the sheet.
Defaults to null
any
Specifies the sheet visibility state. There must be at least one visible sheet in Spreadsheet.
Defaults to ‘Visible’
any
Specified cell will be positioned at the upper-left corner of the sheet.
Defaults to ‘A1’
any
Defines the used range of the sheet.
Defaults to { rowIndex: 0, colIndex: 0 }