new WorkbookDesigner()

Initializes a new instance of the WorkbookDesigner class.

Methods

clearDataSource()

Clears all data sources.

constructor_overload$1(workbook)

Initializes a new instance of the WorkbookDesigner class.

Parameter

Name Type Optional Description

workbook

Workbook

 

The template workbook file.

getCalculateFormula()

Indicates whether formulas should be calculated.

getLineByLine()

Indicates whether processing the smart marker line by line. The default value is false. If False, the template file must contain a range which is named as "_CellsSmartMarkers".

getRepeatFormulasWithSubtotal()

Indicates whether repeating formulas with subtotal row.

getSmartMarkers()

Returns a collection of smart markers in a spreadsheet. A string array is created on every call. The array is sorted and duplicated values are removed.@return {String[]} A collection of smart markers

getUpdateEmptyStringAsNull()

If TRUE, Null will be inserted if the value is "";

getUpdateReference()

Indicates if references in other worksheets will be updated.

getWorkbook()

Gets and sets the Workbook object.

process()

Processes the smart markers and populates the data source values.

process(isPreserved)

Processes the smart markers and populates the data source values.

Parameter

Name Type Optional Description

isPreserved

boolean

 

True if the unrecognized smart marker is preserved.

process(sheetIndex, isPreserved)

Processes the smart markers and populates the data source values. This method works on worksheet level.

Parameters

Name Type Optional Description

sheetIndex

Number

 

Worksheet index.

isPreserved

boolean

 

True if the unrecognized smart marker is preserved.

setCalculateFormula()

Indicates whether formulas should be calculated.

setDataSource(variable, data)

Sets data binding to a variable.

Parameters

Name Type Optional Description

variable

String

 

Variable name created using smart marker.

data

Object

 

Source data.

setLineByLine()

Indicates whether processing the smart marker line by line. The default value is false. If False, the template file must contain a range which is named as "_CellsSmartMarkers".

setRepeatFormulasWithSubtotal()

Indicates whether repeating formulas with subtotal row.

setUpdateEmptyStringAsNull()

If TRUE, Null will be inserted if the value is "";

setUpdateReference()

Indicates if references in other worksheets will be updated.

setWorkbook()

Gets and sets the Workbook object.