Search results

RangeModel API in Angular Spreadsheet API component

Interface for a class Range

Properties

address

string

Specifies the address for updating the dataSource or template.

dataSource

Object[] | DataManager

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

fieldsOrder

string[]

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.

query

Query

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

showFieldAsHeader

boolean

Show/Hide the field of the datasource as header.

startCell

string

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

template

string | Function

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