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
Template helps to compiles the given HTML String (or HTML Element ID) into HtML Element and append to the Cell. @default ”