This Node Is Deprecated — This node is kept for backwards-compatibility, but the usage in new workflows is no longer recommended. The documentation below might contain more information.
This node writes the input data table into a spreadsheet of a workbook. The files can be read then with other applications like Microsoft Excel, for example.
The node supports two formats, which one is used is derived from the file ending.
- If the file name ends with 'xls' (e.g. filename.xls) it will use the old Excel file format, which was used as 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).
- If the file name ends with 'xlsx' (e.g. filename.xlsx) it will use the Office Open XML format, which is the default format starting with Excel 2007.
Note that if the destination location is a remote URL not all options are available because in general it's not possible to determine whether the remote location exists. In this case it will always be overwritten.
Options
Popular Successors
XLS Sheet Appender30 %Variable Loop End13 %Loop End12 %- Send Email9 %
- File Download (legacy)8 %
XLS Reader5 %- Wait...2 %
Merge Variables2 %File Download (legacy)2 %XLS Writer2 %- Java Snippet2 %
- GroupBy1 %
- Write Variables1 %
- Table Creator1 %
- SSH Connection (legacy)1 %
- SDF Writer< 1 %
Database Reader< 1 %- Timer Info< 1 %
- Java Edit Variable (simple)< 1 %
- Group Loop Start< 1 %
Row Filter (deprecated)< 1 %String Replace (Dictionary)< 1 %Table Row To Variable Loop Start< 1 %List Files< 1 %List Files< 1 %- Java Edit Variable< 1 %
Wait-for-time< 1 %- Column Filter< 1 %
- R Snippet< 1 %
Database Writer< 1 %File Reader< 1 %- Constant Value Column< 1 %
Row Splitter (deprecated)< 1 %MySQL Connector< 1 %- String Input (legacy)< 1 %
- Create Directory (legacy)< 1 %
- Upload (legacy)< 1 %
Variable to Table Row< 1 %Database SQL Executor< 1 %Counting Loop Start< 1 %Scorer< 1 %- Concatenate< 1 %
Cell Replacer< 1 %- Rule-based Row Filter< 1 %
- End IF< 1 %
- Extract Table Dimension< 1 %
- JSON Row Combiner< 1 %
JSON Writer< 1 %
Views
- This node has no views
Workflows
DataCleaning_WebPortalKNIME Hub- DataCleaning_WebPortalKNIME Hub
- Drinks_LOESSKNIME Forum
- hitIdentificationKNIME4HTS
- KniMet1.2.8_KNIMESTedKNIME Hub
- Show all 8 workflows
Links
- No links available
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.