|
|
The Excel export node outputs data in the Microsoft Excel .xlsx file
format. Optionally, you can choose to launch Excel automatically and open the exported file when the
node is executed. |
Example
stream = modeler.script.stream()
excelexportnode = stream.createAt("excelexport", "Excel", 200, 200)
excelexportnode.setPropertyValue("full_filename", "C:/output/myexport.xlsx")
excelexportnode.setPropertyValue("excel_file_type", "Excel2007")
excelexportnode.setPropertyValue("inc_field_names", True)
excelexportnode.setPropertyValue("inc_labels_as_cell_notes", False)
excelexportnode.setPropertyValue("launch_application", True)
excelexportnode.setPropertyValue("generate_import", True)
Table 1. excelexportnode properties
excelexportnode properties |
Data type |
Property description |
full_filename
|
string
|
|
excel_file_type
|
Excel2007
|
|
export_mode
|
Create
Append
|
|
inc_field_names
|
flag
|
Specifies whether field names should be included in the first row of the worksheet. |
start_cell
|
string
|
Specifies starting cell for export. |
worksheet_name
|
string
|
Name of the worksheet to be written. |
launch_application
|
flag
|
Specifies whether Excel should be invoked on the resulting file. Note that the path for
launching Excel must be specified in the Helper Applications dialog box (Tools menu, Helper
Applications). |
generate_import
|
flag
|
Specifies whether an Excel Import node should be generated that will read the exported data
file. |
