Configures the range processing for the spreadsheet.
<div id='Spreadsheet'></div>
let spreadsheet: Spreadsheet = new Spreadsheet({
sheets: [{
name: 'First Sheet',
ranges: [{ dataSource: defaultData }],
rows: [{
index: 30,
cells: [{ index: 4, value: 'Total Amount:' },
{ formula: '=SUM(F2:F30)', style: { fontWeight: 'bold' } }]
}]
...
});
spreadsheet.appendTo('#Spreadsheet');
string
Specifies the address for updating the dataSource or template.
Defaults to ‘A1’
Object[]
| DataManager
Specifies the data as JSON / Data manager to the sheet.
Defaults to null
Query
Defines the external Query
that will be executed along with data processing.
Defaults to null
boolean
Show/Hide the field of the datasource as header.
Defaults to true
string
Specifies the start cell from which the datasource will be populated.
Defaults to ‘A1’
string
| Function
Template helps to compiles the given HTML String (or HTML Element ID) into HtML Element and append to the Cell.
Defaults to ”