Icon

Excel Cell Updater (.xlsm)

Options

Create missing folders
Select if the folders of the selected output location should be created when they do not already exist. If this option is unchecked, the node will fail if a folder does not exist.
Re-evaluate formulas
If checked, all formulas in the file will be evaluated after the sheet's updates have been performed. This is useful if values that are used in formulas in the sheets have been updated.
Create new file
If this option is selected, create a copy of the original file which is updated instead of the original file. The newly created file must have the same file type as the original file.
Address column
Select the name of the column which contains the addresses of the cells which should be updated.
If exists
Specify the behavior of the node in case the output file already exists.%%00010Overwrite: Will replace any existing file.%%00010Fail: Will issue an error during the node's execution (to prevent unintentional overwrite).
Template path
Select a file system which stores the data you want to read from and potentially update.
Replace missing values with
If selected, the node will write the specified value as a string to the address if only missing values are found in that row. Otherwise a blank cell is created.
Write to
Provide the path to new file that should be used. This has the same file system and file options as "Read from".
Select sheet
Specify which sheet should be update by the corresponding input table.

Input Ports

This node has no input ports

Output Ports

This node has no output ports

Nodes

Extensions

Links