Constructor Summary |
---|
Property Getters/Setters Summary | ||
---|---|---|
function | getCalculateFormula() | |
function | setCalculateFormula(value) | |
Indicates whether formulas should be calculated. | ||
function | getLineByLine() | |
function | setLineByLine(value) | |
Indicates whether processing the smart marker line by line. | ||
function | getRepeatFormulasWithSubtotal() | |
function | ||
Indicates whether repeating formulas with subtotal row. | ||
function | getUpdateEmptyStringAsNull() | |
function | setUpdateEmptyStringAsNull(value) | |
If TRUE, Null will be inserted if the value is ""; | ||
function | getUpdateReference() | |
function | setUpdateReference(value) | |
Indicates if references in other worksheets will be updated. | ||
function | getWorkbook() | |
function | setWorkbook(value) | |
Gets and sets the |
Method Summary | ||
---|---|---|
function | clearDataSource() | |
Clears all data sources.
|
||
function | getSmartMarkers() | |
Returns a collection of smart markers in a spreadsheet.
|
||
function | process() | |
Processes the smart markers and populates the data source values.
|
||
function | process(isPreserved) | |
Processes the smart markers and populates the data source values.
|
||
function | process(sheetIndex, isPreserved) | |
Processes the smart markers and populates the data source values.
|
||
function | setDataSource(variable, data) | |
Sets data binding to a variable.
|
||
function | setJsonDataSource(variable, data) | |
function WorkbookDesigner()
function WorkbookDesigner(workbook)
workbook: Workbook
-
The template workbook file.
function getWorkbook() / function setWorkbook(value)
function getRepeatFormulasWithSubtotal() / function setRepeatFormulasWithSubtotal(value)
function getUpdateEmptyStringAsNull() / function setUpdateEmptyStringAsNull(value)
function getUpdateReference() / function setUpdateReference(value)
function getCalculateFormula() / function setCalculateFormula(value)
function getLineByLine() / function setLineByLine(value)
function clearDataSource()
function setJsonDataSource(variable, data)
variable: String
- data: String
- function setDataSource(variable, data)
variable: String
- Variable name created using smart marker.data: Object
- Source data.function process()
function process(isPreserved)
isPreserved: boolean
- True if the unrecognized smart marker is preserved.function process(sheetIndex, isPreserved)
sheetIndex: Number
- Worksheet index.isPreserved: boolean
- True if the unrecognized smart marker is preserved.function getSmartMarkers()