This node writes the input data table into a spreadsheet of a workbook. The files can then be read with other applications such as Microsoft Excel.
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 (all additional columns in the data table are truncated). If the input data table has more than 65536 rows, it is split into multiple spreadsheets (all stored in the created workbook).
- .xlsx format: The Office Open XML format is the file format used by default from Excel 2007 onwards.
This nodes does not support writing in the 'xlsm' format.
Specifying a remote URL as the destination location will force the node to overwrite this file as it is not possible to determine whether this location already exists. If no extension is specified, the file will be written in the .xlsx format.