Write To Excel Template

Node / Other

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

Node details

Ports Options Views

Input ports

Type: Table

Input table

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)

Extension

The Write To Excel Template node is part of this extension:

Go to item