RangeDirective API in Angular Spreadsheet API component

e-range directive represent a range of the Angular Spreadsheet. It must be contained in a e-sheet directive.

<ejs-spreadsheet>
  <e-sheets>
   <e-sheet>
   <e-ranges>
   <e-range [dataSource]='data'></e-range>
   </e-ranges>
   </e-sheet>
  </e-sheets>
</ejs-spreadsheet>

Properties

address

any

Specifies the address for updating the dataSource or template.

Defaults to ‘A1’

dataSource

any

Specifies the data as JSON / Data manager to the sheet.

Defaults to null

fieldsOrder

any

By default, when a sheet is bound to a data source, columns are assigned to data source fields sequentially. This means that the first data field is assigned to Column A, the second to Column B, and so on. You can customize these assignments by specifying the field names in the desired column order using the ‘fieldsOrder’ property.

Defaults to null

query

any

Defines the external Query that will be executed along with data processing.

Defaults to null

showFieldAsHeader

any

Show/Hide the field of the datasource as header.

Defaults to true

startCell

any

Specifies the start cell from which the datasource will be populated.

Defaults to ‘A1’

template

any

Template helps to compiles the given HTML String (or HTML Element ID) into HtML Element and append to the Cell.

Defaults to ”