Constructor Summary |
---|
WorkbookDesigner()
Initializes a new instance of the |
WorkbookDesigner(workbook)
Initializes a new instance of the |
Property Getters/Setters Summary | ||
---|---|---|
method | getCalculateFormula() | |
method | setCalculateFormula(value) | |
Indicates whether formulas should be calculated. | ||
method | getUpdateEmptyStringAsNull() | |
method | setUpdateEmptyStringAsNull(value) | |
If TRUE, Null will be inserted if the value is ""; | ||
method | getUpdateReference() | |
method | setUpdateReference(value) | |
Indicates if references in other worksheets will be updated. | ||
method | getWorkbook() | |
method | setWorkbook(value) | |
Gets and sets the |
Method Summary | ||
---|---|---|
method | clearDataSource() | |
Clears all data sources. | ||
method | getSmartMarkers() | |
Returns a collection of smart markers in a spreadsheet. | ||
method | process() | |
Processes the smart markers and populates the data source values. | ||
method | process(isPreserved) | |
Processes the smart markers and populates the data source values. | ||
method | process(sheetIndex, isPreserved) | |
Processes the smart markers and populates the data source values. | ||
method | setDataSource(variable, data) | |
Sets data binding to a variable. | ||
method | setDataSource(variable, dataArray) | |
Sets data array binding to a variable. |
Constructor Detail |
---|
WorkbookDesigner()
WorkbookDesigner(workbook)
workbook: Workbook
-
The template workbook file.
Property Getters/Setters Detail |
---|
getWorkbook/setWorkbook : Workbook | |
Workbook getWorkbook() / setWorkbook(value) |
getUpdateEmptyStringAsNull/setUpdateEmptyStringAsNull : boolean | |
boolean getUpdateEmptyStringAsNull() / setUpdateEmptyStringAsNull(value) |
getUpdateReference/setUpdateReference : boolean | |
boolean getUpdateReference() / setUpdateReference(value) |
getCalculateFormula/setCalculateFormula : boolean | |
boolean getCalculateFormula() / setCalculateFormula(value) |
Method Detail |
---|
clearDataSource | |
clearDataSource() |
setDataSource | |
setDataSource(variable, data) |
variable: String
- Variable name created using smark marker.data: Object
- Source data.setDataSource | |
setDataSource(variable, dataArray) |
variable: String
- Variable name created using smark marker.dataArray: Object[]
- Source data array.process | |
process() |
process | |
process(isPreserved) |
isPreserved: boolean
- True if the unrecognized smart marker is preserved.process | |
process(sheetIndex, isPreserved) |
sheetIndex: int
- Worksheet index.isPreserved: boolean
- True if the unrecognized smart marker is preserved.getSmartMarkers | |
String[] getSmartMarkers() |