WorkbookDesigner class

WorkbookDesigner class

Encapsulates the object that represents a designer spreadsheet.

The WorkbookDesigner type exposes the following members:

Constructors

Constructor	Description
init	Initializes a new instance of the WorkbookDesigner class.
init	Initializes a new instance of the WorkbookDesigner class.

Properties

Property	Description
workbook	Gets and sets the WorkbookDesigner.workbook object.
repeat_formulas_with_subtotal	Indicates whether repeating formulas with subtotal row.
update_empty_string_as_null	If TRUE, Null will be inserted if the value is “”;
update_reference	Indicates if references in other worksheets will be updated.
calculate_formula	Indicates whether formulas should be calculated.
call_back	Gets and sets callback interface of processing smartmarker.
line_by_line	Indicates whether processing the smart marker line by line.

Methods

Method	Description
set_data_source	Sets data source of a ICellsDataTable object.
set_data_source	Sets data binding to a variable.
process	Processes the smart markers and populates the data source values.
process	Processes the smart markers and populates the data source values.
process	Processes the smart markers and populates the data source values.
clear_data_source	Clears all data sources.
set_json_data_source
get_smart_markers	Returns a collection of smart markers in a spreadsheet.

Example

from aspose.cells import Workbook, WorkbookDesigner

# Create WorkbookDesigner object.
wd = WorkbookDesigner()
# Open the template file (which contains smart markers).
wd.workbook = Workbook("SmartMarker_Designer.xls")
# Initialize your data from data source
# DataSet ds = new DataSet();
# ...
# Set the datatable as the data source.
# wd.SetDataSource(dt);
# Process the smart markers to fill the data into the worksheets.
wd.process(True)
# Save the excel file.
wd.workbook.save("outSmartMarker_Designer.xls")

See Also

• module aspose.cells
• class ICellsDataTable
• class WorkbookDesigner