Constructor Summary |
---|
WorkbookDesigner()
Initializes a new instance of the |
WorkbookDesigner(workbook)
Initializes a new instance of the |
Property Getters/Setters Summary | ||
---|---|---|
function | getCalculateFormula() | |
function | setCalculateFormula(value) | |
Indicates whether formulas should be calculated. | ||
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 | setDataSource(variable, dataArray) | |
Sets data array binding to a variable. |
Constructor Detail |
---|
function WorkbookDesigner()
function WorkbookDesigner(workbook)
workbook: Workbook
-
The template workbook file.
Property Getters/Setters Detail |
---|
getWorkbook/setWorkbook : Workbook | |
function getWorkbook() / function setWorkbook(value) |
getUpdateEmptyStringAsNull/setUpdateEmptyStringAsNull : boolean | |
function getUpdateEmptyStringAsNull() / function setUpdateEmptyStringAsNull(value) |
getUpdateReference/setUpdateReference : boolean | |
function getUpdateReference() / function setUpdateReference(value) |
getCalculateFormula/setCalculateFormula : boolean | |
function getCalculateFormula() / function setCalculateFormula(value) |
Method Detail |
---|
clearDataSource | |
function clearDataSource() |
setDataSource | |
function setDataSource(variable, data) |
variable: String
- Variable name created using smark marker.data: Object
- Source data.setDataSource | |
function setDataSource(variable, dataArray) |
variable: String
- Variable name created using smark marker.dataArray: Object[]
- Source data array.process | |
function process() |
process | |
function process(isPreserved) |
isPreserved: boolean
- True if the unrecognized smart marker is preserved.process | |
function process(sheetIndex, isPreserved) |
sheetIndex: Number
- Worksheet index.isPreserved: boolean
- True if the unrecognized smart marker is preserved.getSmartMarkers | |
function getSmartMarkers() |