Loading...

The Excel Writer output node allows writing incoming data to Excel sheets.
Please note that as long the output node is active you won't be able to open the file in Excel at the same time.

Please note that Microsoft Excel has to be installed on the computer if you want to use this node!

This node can be found under Nodes > Output > File System > Excel Writer

Node Properties

File:
Click on [Path] to browse to the Excel file to which the node should write the incoming data. Press [Apply] in order to load the file before proceeding to the worksheet.

Worksheet:
Please choose the worksheet from the drop-down that should be edited.

Single Cell:
Enter the cell in which the node should write the incoming data, for example A1.

Update File:
By default the Excel File will be updated every 10 seconds. You may increase or decrease this value here.

Value:
Please choose the input source that should be written into the specified document.

Node control

With Widget Designer version 6, all nodes support so called node commands. Node commands access functions (i.e methods) from a node and / or set a parameter (i.e. property).

Enter "node", followed by the according ID and a dot and a list will pop up showing all available commands for the node. For instance, Node1.TintColor.SetRGB(125,0,255), colors the node in purple.
In addition, the node properties with a parameter ID (the small superscript number) can be edited via the command Node1.SetParam(ID,new Value) or WDNodeSetParam(NodeID,ParamID,Value).