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 and appends it to an existing workbook.
If no workbook is present a new one will be created. The files can
be read then with other applications like Microsoft Excel, for
example. The writer supports both the old 'xls' format as well as 'xlsx', whereby the same limitations
apply as described in the documentation to the XLS Writer node (max 65536x256 for 'xls').
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 Predecessors
XLS Writer27 %XLS Sheet Appender17 %- Column Rename (Regex)2 %
- Value Counter2 %
XLS Reader2 %Joiner2 %- Group Loop Start2 %
- Statistics2 %
Excel Writer (XLS)2 %Database Reader2 %- Rule-based Row Filter1 %
- R to Table1 %
Loop End (2 ports)< 1 %- Column Auto Type Cast< 1 %
- Table Transposer< 1 %
Variable to Table Row< 1 %File Reader< 1 %- Table Creator< 1 %
Variable Loop End< 1 %- Missing Value< 1 %
Table Row To Variable Loop Start< 1 %- Concatenate< 1 %
- Reference Row Filter< 1 %
- Number Rounder< 1 %
Cell Replacer< 1 %- Column Name Extractor< 1 %
Read XLS Sheet Names< 1 %- Mask Date/Time (legacy)< 1 %
CSV Reader< 1 %- Column Resorter< 1 %
Row Filter (deprecated)< 1 %- Row Sampling< 1 %
- Sorter< 1 %
- String Replacer< 1 %
- Read Excel Sheet Names< 1 %
- Inject Variables (Data)< 1 %
Loop End< 1 %- Rule-based Row Filter (Dictionary)< 1 %
- Column Filter (legacy)< 1 %
- String Input (legacy)< 1 %
- R Snippet< 1 %
- Decision Tree Predictor< 1 %
Cell Splitter< 1 %- Column Aggregator< 1 %
- Column Filter< 1 %
- GroupBy< 1 %
- Normalizer< 1 %
- Column Splitter< 1 %
- Unpivot< 1 %
- Renderer to Image< 1 %
Python Script (1⇒1)< 1 %- String to Date/Time (legacy)< 1 %
Wait-for-time< 1 %Variable Condition Loop End< 1 %- Linear Regression Learner< 1 %
- Auto-Binner< 1 %
String To Number< 1 %- Rank< 1 %
- Rule Engine< 1 %
- End IF< 1 %
- Loop End< 1 %
- List Folders< 1 %
- Copy/Move Files (legacy)< 1 %
- Wait...< 1 %
Table Row to Variable< 1 %Regression Predictor< 1 %- Case Converter< 1 %
- One to Many< 1 %
- Double to Integer< 1 %
- Nominal Value Row Filter< 1 %
- Reference Row Splitter< 1 %
- Pivot< 1 %
- String Manipulation< 1 %
- Conditional Box Plot (legacy)< 1 %
- TimeDelay Loop End< 1 %
- Java Edit Variable (simple)< 1 %
- XPath< 1 %
- Data Generator< 1 %
- Image to Table< 1 %
Table Reader< 1 %Recursive Loop End< 1 %- Polynomial Regression Learner< 1 %
Concatenate (Optional in)< 1 %Number To String< 1 %- Column Merger< 1 %
- Cross Joiner< 1 %
- Reference Column Filter< 1 %
Row Splitter (deprecated)< 1 %Column Rename< 1 %- Empty Table Switch< 1 %
- Create Temp Dir (legacy)< 1 %
- Extract Table Spec< 1 %
- Color Manager< 1 %
- Math Formula< 1 %
- NGram Creator< 1 %
- Weka Predictor (3.7)< 1 %
Variable to Table Column< 1 %- Create File Name (legacy)< 1 %
- Chunk Loop Start< 1 %
Random Forest Learner< 1 %- File Chooser (legacy)< 1 %
- Joiner< 1 %
- Excel Reader< 1 %
Loop End (3 ports)< 1 %- Create Directory (legacy)< 1 %
Table Column to Variable< 1 %Image Writer (Port)< 1 %CSV Writer< 1 %Database Connection Table Reader< 1 %Database SQL Executor< 1 %List Files< 1 %- Java Edit Variable< 1 %
- Java Snippet< 1 %
- X-Partitioner< 1 %
- Cluster Assigner< 1 %
Logistic Regression Learner< 1 %Scorer< 1 %Tree Ensemble Predictor (Regression)< 1 %Random Forest Predictor (Regression)< 1 %- Column Combiner< 1 %
- Column Comparator< 1 %
Column Appender< 1 %- Column to Grid< 1 %
- Constant Value Column< 1 %
Linear Correlation< 1 %- Missing Value Column Filter< 1 %
- RowID< 1 %
- Numeric Row Splitter< 1 %
- Rule-based Row Splitter< 1 %
- Independent groups t-test< 1 %
CASE Switch Variable (Start)< 1 %Merge Variables< 1 %- Crosstab< 1 %
- Empty Table Creator< 1 %
- Association Rule Learner (Borgelt)< 1 %
- Java Snippet (simple)< 1 %
- Java IF (Table)< 1 %
- Term to String< 1 %
- Line Plot (JavaScript)< 1 %
String Input (legacy)< 1 %- Time Difference (legacy)< 1 %
- Date Field Extractor (legacy)< 1 %
- Time Generator (legacy)< 1 %
- Moving Aggregator< 1 %
- Moving Average< 1 %
- Twitter Users< 1 %
- Domain - Leverage< 1 %
Flow Variable End IF< 1 %- Variable Timed Loop End< 1 %
- Split Collection Column< 1 %
- String to URI< 1 %
- URL to File Path (Variable)< 1 %
- Breakpoint< 1 %
- Catch Errors (Data Ports)< 1 %
- Try (Data Ports)< 1 %
Generic Loop Start< 1 %Naive Bayes Predictor< 1 %- Fuzzy c-Means< 1 %
- Logistic Regression Learner< 1 %
- Simple Regression Tree Predictor< 1 %
- Add Empty Rows< 1 %
- Numeric Binner< 1 %
- Cell Splitter< 1 %
- Category to Number< 1 %
- Create Table Structure< 1 %
- Table Validator (Reference)< 1 %
Double To Int< 1 %- Low Variance Filter< 1 %
- Partitioning< 1 %
- Decision Tree to Ruleset< 1 %
Rank Correlation< 1 %CASE Switch Data (End)< 1 %CASE Switch Data (Start)< 1 %- Extract Table Dimension< 1 %
- Lift Chart (legacy)< 1 %
- Interactive Table (legacy)< 1 %
- DB Reader< 1 %
Excel Reader (XLS)< 1 %Excel Sheet Appender (XLS)< 1 %- Weka Cluster Assigner (3.7)< 1 %
- Value Filter (legacy)< 1 %
- File Upload (legacy)< 1 %
- Single Selection (legacy)< 1 %
- Column to XML< 1 %
- Write To Excel Template (deprecated)< 1 %
- Variable Creator< 1 %
- Number to String< 1 %
- Column Appender< 1 %
- String Manipulation (Variable)< 1 %
Views
- This node has no views
Workflows
Add_Multipal_Sheet_in_one_excel_fileKNIME Forum- Add_Multipal_Sheet_in_one_excel_fileKNIME Hub
- Spontaneous tail coilings-measurementKNIME Hub
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.