This node writes the input data table into a spreadsheet of an Excel file, which can then be read with other applications such as Microsoft Excel. The node can create completely new files or append data to an existing Excel file. When appending, the input data can be appended as a new spreadsheet or after the last row of an existing spreadsheet. By adding multiple data table input ports, the data can be written/appended to multiple spreadsheets within the same file.
The node supports two formats chosen by file extension:
-
.xlsformat: This is the file format which was used by default up until Excel 2003. The maximum number of columns and rows held by a spreadsheet of this format is 256 and 65536 respectively. -
.xlsxformat: The Office Open XML format is the file format used by default from Excel 2007 onwards. The maximum number of columns and rows held by a spreadsheet of this format is 16384 and 1048576 respectively.
If the data does not fit into a single sheet, it will be split into multiple chunks that are written
to newly chosen sheet names sequentially. The new sheet names are derived from the originally
selected sheet name by appending " (i)" to it, where i=1,...,n.
When appending to a file, a sheet may already exist. In this case the node will
(according to its settings) either replace the sheet, fail or append rows after the last row in that
sheet. This can be used to append data to an Excel file without having to create a new sheet
name once the original sheet is full by just selecting the original sheet name. The data will
be appendend to the last sheet in the name sequence. The original sheet name does not have to be changed.
This node does not support writing files in the '.xlsm' format, yet appending is supported.
This node can access a variety of different file systems. More information about file handling in KNIME can be found in the official File Handling Guide.
Options
Settings
Encryption
Popular Successors
- Variable Loop End15 %
- Excel Writer14 %
- Send Email9 %
- Loop End6 %
- Excel Reader5 %
- XLS Formatter (apply)3 %
- Wait...3 %
- Path to String (Variable)3 %
- Merge Variables2 %
- File Download Widget2 %
- Joiner1 %
- Excel Password Manager1 %
- List Files/Folders1 %
- Transfer Files1 %
- CSV Writer1 %
- Column Filter1 %
- GroupBy< 1 %
- Timer Info< 1 %
- Rule Engine< 1 %
- String Manipulation (Variable)< 1 %
Loop End< 1 %- DB Connection Closer< 1 %
- Column Resorter< 1 %
Row Filter (deprecated)< 1 %- Upload (legacy)< 1 %
- Concatenate< 1 %
- DB Query Reader< 1 %
- SSH Connector< 1 %
- Table to HTML String< 1 %
- Read Excel Sheet Names< 1 %
- Table Creator< 1 %
XLS Formatter (apply)< 1 %- Catch Errors (Var Ports)< 1 %
- Column Expressions< 1 %
- Create Date&Time Range< 1 %
- Create File/Folder Variables< 1 %
- Table Row to Variable Loop Start< 1 %
- Microsoft SQL Server Connector< 1 %
- Python Script (legacy)< 1 %
- Write To Excel Template (deprecated)< 1 %
- Rule-based Row Filter< 1 %
Microsoft Authenticator (Deprecated)< 1 %- Cross Joiner< 1 %
Excel Writer (XLS)< 1 %Merge Variables< 1 %- Delete Files/Folders< 1 %
- CASE Switch End< 1 %
- Loop End (Column Append)< 1 %
Excel Sheet Appender (XLS)< 1 %- Excel Cell Updater< 1 %
Variable Loop End< 1 %Excel Sheet Appender (XLS)< 1 %- Table Writer< 1 %
Column Rename< 1 %- Group Loop Start< 1 %
- Google Sheets Updater< 1 %
- Text Output Widget (legacy)< 1 %
- Table Manipulator< 1 %
- File Reader< 1 %
- XLS Sheet Selector< 1 %
- Download / Upload from List (legacy)< 1 %
- Compress Files/Folder< 1 %
- End IF< 1 %
- Run Heavy Garbage Collector< 1 %
- CSV Reader< 1 %
- Java Snippet< 1 %
- Cell Splitter< 1 %
- Missing Value< 1 %
- Try (Variable Ports)< 1 %
- Column Aggregator< 1 %
- Sorter< 1 %
- SMB Connector< 1 %
- External Tool< 1 %
Send to Power BI< 1 %Loop End (2 ports)< 1 %- DB Writer< 1 %
- Table Column to Variable< 1 %
- String Manipulation< 1 %
- Download (legacy)< 1 %
CASE Switch Variable (End)< 1 %- Save Workflow< 1 %
Cell Replacer< 1 %- Pivot< 1 %
- Variable Expressions< 1 %
- Python Object Reader (legacy)< 1 %
- Copy Excel Sheet< 1 %
Variable to Table Row< 1 %SQL Inject< 1 %- FTP Connector< 1 %
- Credentials Configuration< 1 %
- Catch Errors (Generic Ports)< 1 %
- Variable Creator< 1 %
- DB SQL Executor< 1 %
- String to Path (Variable)< 1 %
- Date&Time Difference< 1 %
- Create File Name (legacy)< 1 %
- Create Temp Folder< 1 %
Table Row to Variable< 1 %- Table Reader< 1 %
- Recursive Loop End< 1 %
- String to Number< 1 %
Table Row to Variable< 1 %- Rule-based Row Splitter< 1 %
- Transfer Files (Table)< 1 %
- List Remote Files (legacy)< 1 %
- Breakpoint< 1 %
- Variable Condition Loop End< 1 %
- URL to File Path (Variable)< 1 %
Variable to Table Row< 1 %- Variable to Table Row< 1 %
- Duplicate Row Filter< 1 %
- Cache< 1 %
- Constant Value Column< 1 %
- Credentials Input (legacy)< 1 %
- R Source (Table)< 1 %
- XLS Row and Column Sizer< 1 %
Database Looping< 1 %- DB Connector< 1 %
Read Excel Sheet Names (XLS)< 1 %File Reader< 1 %Parquet Writer< 1 %- SharePoint Online Connector< 1 %
- Parameter Optimization Loop End< 1 %
- XLS Conditional Formatter< 1 %
Row Splitter (deprecated)< 1 %- DB Loader< 1 %
- DB Table Remover< 1 %
- Local File System Connector< 1 %
- Java Edit Variable (simple)< 1 %
- Path to URI< 1 %
- XLS Coloured Writer< 1 %
- Create Temp Dir (legacy)< 1 %
- Tableau Writer< 1 %
- File Upload Widget< 1 %
- Counting Loop Start< 1 %
- Linear Correlation< 1 %
Google Authenticator (API Key)< 1 %- Date&Time Input (legacy)< 1 %
- Python Source (legacy)< 1 %
- XLS Sheet Properties< 1 %
- XLS Control Table Generator< 1 %
- Zip Files (legacy)< 1 %
Image Writer (Table Column)< 1 %- Microsoft Access Connector< 1 %
- Path to String< 1 %
- Time Generator (legacy)< 1 %
- Active Branch Inverter< 1 %
- Table to PDF (legacy)< 1 %
- XLS Format Merger< 1 %
- Run Garbage Collector< 1 %
- Extract Context Properties< 1 %
- Column Renamer (Dictionary)< 1 %
- Reference Row Filter< 1 %
- Partitioning< 1 %
- MySQL Connector< 1 %
- Oracle Connector< 1 %
- POST Request< 1 %
- Date&Time to String< 1 %
- XLS Border Formatter< 1 %
- XLS Background Colorizer< 1 %
- Configurable End IF/CASE< 1 %
- Copy/Move Files (legacy)< 1 %
Joiner< 1 %- String Replacer< 1 %
- DB Table Selector< 1 %
- Table to HTML (legacy)< 1 %
- Send to Tableau Server< 1 %
Transfer Files< 1 %- Line Plot (JavaScript)< 1 %
- Remove Empty Rows< 1 %
- Java Edit Variable< 1 %
- Generic Loop Start< 1 %
- Column Merger< 1 %
- Rule Engine Variable< 1 %
- Voting Loop End< 1 %
- Network Writer< 1 %
- Fixed Width File Reader< 1 %
Table Writer< 1 %- Table Transposer< 1 %
- DB Insert< 1 %
- DB Table Creator< 1 %
- Empty Table Creator< 1 %
- Explorer Writer< 1 %
- Refresh Button Widget< 1 %
- String to Date&Time< 1 %
- WebDriver Factory< 1 %
Flow Variable End IF< 1 %- Benchmark End< 1 %
- String to URI< 1 %
- Variable to Table Column< 1 %
- Table Row to Variable< 1 %
Table Row To Variable Loop Start< 1 %Database Connection Table Reader< 1 %Database Reader< 1 %Database Connector< 1 %Recursive Loop End< 1 %- Empty Table Switch< 1 %
- Crosstab< 1 %
- DB Update< 1 %
- DB Joiner< 1 %
- H2O to Table< 1 %
- Math Formula< 1 %
Excel Reader (XLS)< 1 %- SharePoint Online List Writer< 1 %
- Punctuation Erasure< 1 %
- Strings to Document< 1 %
- Local File Browser Configuration< 1 %
- Python Edit Variable (legacy)< 1 %
- Date&Time Part Extractor< 1 %
- Date&Time-based Row Filter< 1 %
- XLS Font Formatter< 1 %
Flow Variable IF Switch (Flow Variable Value)< 1 %- Write Variables< 1 %
- KNIME URI Resolver (Variable)< 1 %
- Write To Excel Template< 1 %
- Binary Objects to Files< 1 %
- URI to String< 1 %
CSV Writer< 1 %Database Table Selector< 1 %- Image Writer (Table)< 1 %
List Files< 1 %- Column List Loop Start< 1 %
- Auto-Binner< 1 %
- Column Combiner< 1 %
- Nominal Value Row Filter< 1 %
- Nominal Value Row Splitter< 1 %
- Number Rounder< 1 %
- RowID< 1 %
CASE Switch Variable (Start)< 1 %- Databricks File System Connector< 1 %
- TimeDelay Loop Start< 1 %
- Model Loop End< 1 %
Excel Reader (XLS)< 1 %Excel Writer (XLS)< 1 %- Java Snippet (simple)< 1 %
Compress Files/Folder< 1 %- Create Folder< 1 %
- Date&Time Configuration< 1 %
- String Configuration< 1 %
- Table Editor (JavaScript)< 1 %
- Image Output Widget (legacy)< 1 %
- Python Object Writer (legacy)< 1 %
- R Snippet< 1 %
- XLS Cell Formatter< 1 %
- XLS Control Table from Cell Range< 1 %
- TIBCO Spotfire Information Link Reader< 1 %
- Multiport Loop End< 1 %
- Benchmark End (Flow Variable)< 1 %
- Benchmark End (Flow Variable) (Memory Monitoring)< 1 %
- Python Snippet< 1 %
- R Source< 1 %
- MarvinView< 1 %
- SSH Connection (legacy)< 1 %
- Catch Errors (Data Ports)< 1 %
- Extract Variables (Data)< 1 %
- Inject Variables (Data)< 1 %
Database Writer< 1 %Extract Context Properties< 1 %- Image Writer (Port)< 1 %
- Line Reader< 1 %
- Chunk Loop Start< 1 %
- Logistic Regression Learner< 1 %
- Scorer< 1 %
- Add Empty Rows< 1 %
- Column Auto Type Cast< 1 %
- Number to String< 1 %
- Column Appender< 1 %
- Reference Row Splitter< 1 %
- Column Splitter< 1 %
- CASE Switch Start< 1 %
- IF Switch< 1 %
- Extract Table Dimension< 1 %
- Data Generator< 1 %
- Color Manager< 1 %
- Interactive Table (legacy)< 1 %
- Bar Chart< 1 %
- Hive Connector< 1 %
- Create Databricks Environment< 1 %
- Capture Workflow End< 1 %
- Parallel Chunk End< 1 %
- PostgreSQL Connector< 1 %
- DB Query Extractor< 1 %
- One Row to Many< 1 %
- Math Formula (Variable)< 1 %
XLS Reader< 1 %- Send to Power BI< 1 %
- External SSH Tool< 1 %
- External Tool (Labs)< 1 %
- Set Files/Folders Permissions< 1 %
- String to Path< 1 %
Google Authenticator (Deprecated)< 1 %- Google Sheets Writer< 1 %
- File Download (legacy)< 1 %
- Text Output (legacy)< 1 %
- File Upload (legacy)< 1 %
- String Input (legacy)< 1 %
- Table View (JavaScript)< 1 %
- String Widget< 1 %
- Container Input (File)< 1 %
- Table to JSON< 1 %
Python Script (1⇒1)< 1 %- Data to Report (BIRT)< 1 %
- GET Request< 1 %
- SAP Reader (Theobald Software)< 1 %
- Workflow Service Input< 1 %
- XGBoost Predictor (Regression)< 1 %
- BERT Classification Learner< 1 %
Variable Condition Loop End< 1 %- Category to Number< 1 %
- Unpivot< 1 %
- JSON Path< 1 %
Extract Date&Time Fields< 1 %- Try (Data Ports)< 1 %
Counting Loop Start< 1 %- ORC Writer< 1 %
- Conditional Label Assigner< 1 %
- Credentials Widget< 1 %
- Parameter Optimization Loop Start< 1 %
- Moving Average< 1 %
Click< 1 %- Variable Timed Loop End< 1 %
- Create Table Structure< 1 %
- Rank< 1 %
- SQLite Connector< 1 %
- TimeDelay Loop End< 1 %
- Decompress Files< 1 %
- File Chooser Widget< 1 %
Container Input (Variable)< 1 %- Container Output (File)< 1 %
- Message Slack channel< 1 %
- TIBCO Spotfire File Reader< 1 %
- Upload File To SP< 1 %
Table Reader< 1 %- k-Means< 1 %
Scorer< 1 %- One to Many< 1 %
- Domain Calculator< 1 %
- Statistics< 1 %
CASE Switch Data (Start)< 1 %- DB Delete (Table)< 1 %
- DB Column Filter< 1 %
- Google Drive Connector< 1 %
Views
- This node has no views
Workflows
[01.CX] Combining Siloed Legacy Data with Running App's Back-End DatabaseKNIME Hub- [02.CX] Viber Community Report JSON Parsing WorkflowKNIME Hub
- [03.CX] Extracting and Transforming Viber Broadcast Data from InfobipKNIME Hub
- [04.CX] Capturing Messenger LiveChat Data in Real-Time with ManyChat and Google SheetsKNIME Hub
- [ON] PEX ROTINAS 2024KNIME Hub
- Show all 1963 workflows
Links
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.