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
- Type: TableInput tableTable 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)