This node writes the input data table into a spreadsheet of an Excel file. The files can then be read with other applications such as Microsoft Excel.
Adding additional sheet input ports allows to write multiple spreadsheets to the same file. Furthermore, it is also possible to append sheets to an already existing excel file by selecting the append option.
The node supports two formats chosen by file extension:
- .xls format: This is the file format which was used by default up until Excel 2003. The maximum number of columns held by a spreadsheet of this format is 256. If the input data table has more than 65536 rows, it is split into multiple spreadsheets.
- .xlsx format: The Office Open XML format is the file format used by default from Excel 2007 onwards. The maximum number of columns held by a spreadsheet of this format is 16384. If the input data table has more than 1048576 rows, it is split into multiple spreadsheets.
This nodes does not support writing files in the 'xlsm' format, yet appending is supported.