aspose.cells
Class WorkbookDesigner

WorkbookDesigner

function WorkbookDesigner()

Initializes a new instance of the WorkbookDesigner class.

WorkbookDesigner

function WorkbookDesigner(workbook)

Initializes a new instance of the WorkbookDesigner class.

Parameters:

workbook: Workbook - The template workbook file.

function getWorkbook() / function setWorkbook(value)

Gets and sets the Workbook object.

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 getCalculateFormula() / function setCalculateFormula(value)

Indicates whether formulas should be calculated.

function clearDataSource()

Clears all data sources.

function setDataSource(variable, data)

Sets data binding to a variable.

Parameters:

variable: String - Variable name created using smark marker.

data: Object - Source data.

function setDataSource(variable, dataArray)

Sets data array binding to a variable.

Parameters:

variable: String - Variable name created using smark marker.

dataArray: Object[] - Source data array.

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.

Parameters:

isPreserved: boolean - True if the unrecognized smart marker is preserved.

function process(sheetIndex, isPreserved)

Processes the smart markers and populates the data source values.

This method works on worksheet level.

Parameters:

sheetIndex: Number - Worksheet index.

isPreserved: boolean - True if the unrecognized smart marker is preserved.

function 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.

Returns:

A collection of smart markers