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 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.
Options
Popular Successors
- Double to Integer5 %
CSV Writer3 %- Group Loop Start3 %
Recursive Loop End3 %Loop End2 %- Table Creator2 %
- Create Date&Time Range2 %
Counting Loop Start2 %- Column Filter2 %
- Rule-based Row Filter2 %
CSV Reader2 %Flow Variable End IF2 %- String Manipulation2 %
Excel Sheet Appender (XLS)2 %Variable to Table Row2 %- Chunk Loop Start2 %
- Java Edit Variable (simple)1 %
- SSH Connection (legacy)1 %
- Create File Name (legacy)1 %
- Statistics1 %
Loop End (2 ports)1 %- Modify Time1 %
- Java Edit Variable1 %
- Delete Files (legacy)1 %
Python Object Reader1 %- List Remote Files (legacy)1 %
- Wait...1 %
- File Upload (legacy)1 %
- Reference Column Resorter< 1 %
- External Tool< 1 %
Excel Writer (XLS)< 1 %- Row Splitter< 1 %
- Column Resorter< 1 %
- R Snippet< 1 %
- String to Date&Time< 1 %
- Read Variables< 1 %
Database Query< 1 %XLS Sheet Appender< 1 %Tableau Writer (Hyper)< 1 %MongoDB Reader< 1 %- Python Source (legacy)< 1 %
Flow Variable IF Switch< 1 %Table Column to Variable< 1 %Excel Reader (XLS)< 1 %- XPath< 1 %
- Explorer Writer< 1 %
- Radar Plot Appender< 1 %
- Find MIME-Type< 1 %
Variable Loop End< 1 %- Empty Table Switch< 1 %
- Extract Variables (Data)< 1 %
Table Reader< 1 %- Rule Engine< 1 %
- Concatenate< 1 %
Python Script (1⇒1)< 1 %- URL to File Path (Variable)< 1 %
Database Table Selector< 1 %Column Rename< 1 %- File Download (legacy)< 1 %
- Loop End (Column Append)< 1 %
Variable Condition Loop End< 1 %- Python Edit Variable (legacy)< 1 %
Concatenate (Optional in)< 1 %- Color Manager< 1 %
- Write Variables< 1 %
- String to URI< 1 %
Number To String< 1 %CASE Switch Variable (End)< 1 %- Send Email< 1 %
- Text Output (legacy)< 1 %
- Java Snippet< 1 %
Excel Reader (XLS)< 1 %Parameterized Database Query< 1 %- Parallel Chunk End< 1 %
File Download (legacy)< 1 %Database Table Creator< 1 %Cell Replacer< 1 %- Value Counter< 1 %
- Sorter< 1 %
- POST Request< 1 %
- File Download Widget< 1 %
- Table Transposer< 1 %
- Math Formula< 1 %
Read Excel Sheet Names (XLS)< 1 %List Files< 1 %- DB Writer< 1 %
- Legacy Date&Time to Date&Time< 1 %
- RowID< 1 %
CASE Switch Variable (Start)< 1 %- Reference Row Filter< 1 %
Google Sheets Interactive Service Provider< 1 %- Rule-based Row Splitter< 1 %
- Google Sheets Appender< 1 %
- Active Branch Inverter< 1 %
- Missing Value< 1 %
- Benchmark End (Flow Variable)< 1 %
- Copy/Move Files (legacy)< 1 %
- Date&Time to legacy Date&Time< 1 %
Database Table Connector< 1 %Joiner< 1 %- Reference Row Splitter< 1 %
- Extract Table Dimension< 1 %
- Variable Expressions< 1 %
- FileMerger< 1 %
Database Connector< 1 %Column Appender< 1 %- Regex Split< 1 %
Microsoft SQL Server Connector< 1 %XLS Formatter (apply)< 1 %- String to Date/Time (legacy)< 1 %
Input File< 1 %- Upload (legacy)< 1 %
- Zip Files (legacy)< 1 %
Table Writer< 1 %- Create Temp Dir (legacy)< 1 %
- R Source (Workspace)< 1 %
- X-Partitioner< 1 %
- Google Sheets Updater< 1 %
- Database Connection Closer< 1 %
- Column Combiner< 1 %
- Java Snippet (simple)< 1 %
Python Edit Variable< 1 %- Variable Timed Loop End< 1 %
- Create Directory (legacy)< 1 %
Image Writer (Port)< 1 %File Reader< 1 %- DB Query Reader< 1 %
Tableau Writer (TDE)< 1 %- Date&Time Widget< 1 %
Database Reader< 1 %- Linear Regression Learner< 1 %
- Cross Joiner< 1 %
- Rule Engine Variable< 1 %
Find Elements< 1 %- XLS Sheet Properties< 1 %
- Chemistry External Tool< 1 %
- Message Slack channel< 1 %
String To Number< 1 %- Constant Value Column< 1 %
- SDF Writer< 1 %
- Microsoft SQL Server Connector< 1 %
- MySQL Connector< 1 %
- Bag Of Words Creator< 1 %
- Parallel Coordinates Plot (JavaScript)< 1 %
- XLS Coloured Writer< 1 %
Variable to Table Column< 1 %Table Row To Variable Loop Start< 1 %Database SQL Executor< 1 %Database Writer< 1 %- Row Filter< 1 %
- String Manipulation (Variable)< 1 %
- Timer Info< 1 %
- Histogram (legacy)< 1 %
PostgreSQL Connector< 1 %- XLS Background Colorizer< 1 %
- Download (legacy)< 1 %
Database Delete< 1 %- DB SQL Executor< 1 %
- String to Term< 1 %
- Modify Date< 1 %
- Date&Time-based Row Filter< 1 %
- Breakpoint< 1 %
- Inject Variables (Data)< 1 %
Table Row to Variable< 1 %Database Looping< 1 %List Files< 1 %Recursive Loop Start (2 ports)< 1 %- GroupBy< 1 %
- Pivot< 1 %
Merge Variables< 1 %- Scatter Plot (legacy)< 1 %
- Save Workflow< 1 %
- Container Input (JSON)< 1 %
Python Source< 1 %- R to R< 1 %
- Time Generator (legacy)< 1 %
XML Reader< 1 %- XLS Sheet Selector< 1 %
Flow Variable IF Switch (Flow Variable Value)< 1 %- Unzip Files (legacy)< 1 %
- Catch Errors (Var Ports)< 1 %
- Try (Variable Ports)< 1 %
Database Connection Table Reader< 1 %- Column Renamer (Dictionary)< 1 %
- Subset Matcher< 1 %
- Denormalizer< 1 %
- Partitioning< 1 %
String To Number (PMML)< 1 %- Round Double< 1 %
String Replace (Dictionary)< 1 %- Pie chart (legacy)< 1 %
- Microsoft Access Connector< 1 %
- DB Connector< 1 %
Table to PDF< 1 %- Math Formula (Variable)< 1 %
XLS Writer< 1 %- Java IF (Table)< 1 %
- Frequency Filter< 1 %
- Document Data Extractor< 1 %
- File Upload Widget< 1 %
MongoDB Remove< 1 %- Python Object Reader (legacy)< 1 %
Python Script (1⇒2)< 1 %- R Source (Table)< 1 %
- File Difference Checker< 1 %
- Wait< 1 %
Views
- This node has no views
Workflows
01_B2B_Customer_AnalyticsKNIME Hub- 01_Correlation_MatrixKNIME Hub
- 01_Hitlist_FilterKNIME Hub
- 01_Model_Deployment_file_to_database_schedulingKNIME Hub
- 01_SDS phrases extractionKNIME Hub
- Show all 87 workflows
Links
- Table to txt or xlsby qqilihq on 2019-11-19forum.knime.com/p/75108
- XML in CSV or xlsx or something elseby armingrudd on 2019-10-09forum.knime.com/p/71976
- New to Knime - Creating a reportby johannes.schweig on 2018-11-22forum.knime.com/p/50333
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.