Write To Excel Template

This node writes the input data table into an existing Excel file without changing its formatting.
Alternatively a new file will be created based on the template file formats and data. The input data will be written to the second row without header by default (can be changed in the Advanced Options) Already populated cells in the input file will be overwritten.
The node supports three formats chosen by file extension: XLS,XLSX,XLSM

Options

Template File Type
Select the file type of your template Excel. The same file type will be used for the optional output file.
Template File - Selected File
Enter a valid location where the template Excel is available. This file will be used as template - including the formatting and data. The required syntax of a path depends on the chosen file system, such as "C:\path\to\file" (Local File System on Windows) or "/path/to/file" (Local File System on Linux/MacOS and Mountpoint).
Template Sheet Name Selection
Select which sheet in the template file should be used. You can select the sheet by name or by the sheet index. by default the first sheet will be used.
Writing Options
Select if the template file should be overwritten ordered list if a new file should be created. Note: If "Create new file" is selected - then you have to specify a output file
Output File - Selected File
Enter a valid location where the output file should be created. This file will be used as template - including the formatting and data. The required syntax of a path depends on the chosen file system, such as "C:\path\to\file" (Local File System on Windows) or "/path/to/file" (Local File System on Linux/MacOS and Mountpoint).
Output File - Overwrite Options
Select if the node should fail - if the new file already exists. Or if the existing file should be overwritten.
Write Options - Write column header
Select if the input table column headers should be written into the first row. By default no column header will be written.
Write Options - Do not write '=' cells as formulas
Select if string columns containing = should be escaped by ' so they are not interpreted as formulas.
Should all exising formulas be recalculated?
Select if you want to recalculate all existing formulas in your Excel file.
Offsets
Select on which row/column the writer should start. By default the input table will write from A2 till the last row of the input table. If you want to shift this by 2 rows and 1 column (so starting at C4): Starting row: 4 Starting column: 3 If you want to append the input table to the end of the template file, then select the "Write to last physical row" option
Template file password
If you template file is secured by a password. Then enter your Excel password here. The following password options are availible: No PWD needed = the file does not have an password and no password should be added to the output Open with PWD = file has an password and the password should be the same in the output Remove PWD = file has an password, but output should not be secured Change PWD = file has an password, but output should have a different password Add PWD = file has no password, but output should be secured

Input Ports

Icon
Table that contains columns to write to Excel. Most column types are supported. (Strings, Integer, Double, Timestamps, PNG Pictures and file paths. If you want to create formulas, then start a String column with '=' followed by the formula. (the formula has to use the english function names)

Output Ports

This node has no output ports

Views

This node has no views

Workflows

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.