Search results

SheetDirective API in Angular Spreadsheet API component

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>

Properties

activeCell

any

Specifies active cell within selectedRange in the sheet.

Defaults to ‘A1’

colCount

any

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

Defaults to 100

columns

any

Configures column and its properties for the sheet.

Defaults to []

conditionalFormats

any

Specifies the conditional formatting for the sheet.

Defaults to []

index

any

Specifies index of the sheet. Based on the index, sheet properties are applied.

Defaults to 0

isProtected

any

Specifies to protect the cells in the sheet.

Defaults to false

name

any

Specifies the name of the sheet, the name will show in the sheet tabs.

Defaults to

protectSettings

any

Configures protect and its options.

Defaults to { selectCells: false, formatCells: false, formatRows: false, formatColumns: false, insertLink: false }

ranges

any

Specifies the collection of range for the sheet.

Defaults to []

rowCount

any

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

Defaults to 100

rows

any

Configures row and its properties for the sheet.

Defaults to []

selectedRange

any

Specifies selected range in the sheet.

Defaults to ‘A1’

showGridLines

any

Specifies to show / hide grid lines in the sheet.

Defaults to true

showHeaders

any

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

Defaults to true

state

any

Specifies the sheet visibility state. There must be at least one visible sheet in Spreadsheet.

Defaults to ‘Visible’

topLeftCell

any

Specified cell will be positioned at the upper-left corner of the sheet.

Defaults to ‘A1’

usedRange

any

Defines the used range of the sheet.

Defaults to { rowIndex: 0, colIndex: 0 }