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 then be read with other applications such as Microsoft Excel.
The node supports three 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.
- .xlsm format: This node can append data to macro-enabled workbooks, however, new workbooks cannot be created this way.
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 Predecessors
Table Row to Variable9 %File Reader4 %Scorer3 %Linear Correlation2 %- Normalizer2 %
- Column Resorter2 %
- Auto-Binner2 %
- Excel Writer2 %
- Linear Regression Learner2 %
- Numeric Binner2 %
- Double to Integer1 %
- Joiner1 %
- Parameter Optimization Loop End1 %
- k-Means1 %
Numeric Scorer1 %- Column Filter1 %
Column Rename1 %Excel Reader (XLS)1 %Row Filter (deprecated)< 1 %- Extract Table Spec< 1 %
Cell Splitter< 1 %- GroupBy< 1 %
- XPath< 1 %
- Reference Column Filter< 1 %
- One to Many< 1 %
Python Script (1⇒1)< 1 %- Date Field Extractor (legacy)< 1 %
- Rule Engine< 1 %
- One-way ANOVA< 1 %
- Sorter< 1 %
Excel Writer (XLS)< 1 %- Java Edit Variable (simple)< 1 %
Excel Sheet Appender (XLS)< 1 %- Concatenate< 1 %
Counting Loop Start< 1 %- Table Row to Variable< 1 %
- Missing Value< 1 %
- Data Generator< 1 %
- Explorer Browser< 1 %
- Image to Table< 1 %
- Rule-based Row Filter< 1 %
Excel Sheet Appender (XLS)< 1 %- Column List Loop Start< 1 %
Row Splitter (deprecated)< 1 %- Denormalizer< 1 %
- Math Formula< 1 %
- Date&Time Shift< 1 %
Variable to Table Column< 1 %- Extract Variables (Data)< 1 %
- Create Temp Dir (legacy)< 1 %
- Counter Generation< 1 %
- Inject Variables (Data)< 1 %
Generic Loop Start< 1 %- Decision Tree Predictor< 1 %
- String Manipulation (Variable)< 1 %
- Box Plot (legacy)< 1 %
- PDF Parser< 1 %
- Naive Bayes Predictor< 1 %
- DB Query Reader< 1 %
- Polynomial Regression Learner< 1 %
String To Number< 1 %- Pivot< 1 %
String Replace (Dictionary)< 1 %- Cache< 1 %
- Twitter Search (legacy)< 1 %
- Twitter Timeline (legacy)< 1 %
- Logistic Regression Learner< 1 %
- Random Forest Predictor (Regression)< 1 %
- Add Empty Rows< 1 %
- Extract Table Dimension< 1 %
- Google Sheets Reader< 1 %
- File Upload (legacy)< 1 %
- Line Plot (JavaScript)< 1 %
Database Update< 1 %- Nominal Value Row Filter< 1 %
- Nominal Value Row Splitter< 1 %
- Value Counter< 1 %
- Rule-based Row Splitter< 1 %
Rank Correlation< 1 %- Column Filter (legacy)< 1 %
- Scatter Plot (JavaScript)< 1 %
Flow Variable IF Switch (Flow Variable Value)< 1 %- XLS Coloured Writer< 1 %
Database Looping< 1 %Variable Condition Loop End< 1 %Recursive Loop End< 1 %- Column Name Extractor< 1 %
- Column Merger< 1 %
- Rank< 1 %
- Table Transposer< 1 %
- Create Date&Time Range< 1 %
- Run Garbage Collector< 1 %
- Try (Variable Ports)< 1 %
- Duplicate Row Filter< 1 %
Loop End (Upto 6 ports)< 1 %Table Row To Variable Loop Start< 1 %- Hierarchical Clustering< 1 %
- Association Rule Learner< 1 %
- Column Combiner< 1 %
- Column to Grid< 1 %
- Statistics< 1 %
- Interactive Table (legacy)< 1 %
- Random Number Assigner< 1 %
Excel Reader (XLS)< 1 %- Weka Predictor (3.7)< 1 %
- R to Table< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Try (Data Ports)< 1 %
- Linear Correlation< 1 %
- Variable Expressions (legacy)< 1 %
- JSON Path< 1 %
- RDKit Descriptor Calculation< 1 %
- Create Directory (legacy)< 1 %
- URL to File Path< 1 %
CSV Reader< 1 %- X-Aggregator< 1 %
- Logistic Regression Predictor< 1 %
- Reference Row Filter< 1 %
- String Manipulation< 1 %
- Timer Info< 1 %
- Parallel Chunk End< 1 %
- Empty Table Creator< 1 %
- String Input (legacy)< 1 %
- Run Heavy Garbage Collector< 1 %
- Cluster Assigner< 1 %
- Numeric Scorer< 1 %
- Scatter Plot (Plotly)< 1 %
Excel Writer (XLS)< 1 %- Modify Date< 1 %
- Loop End< 1 %
- R Snippet< 1 %
- Copy/Move Files (legacy)< 1 %
- Wait...< 1 %
- Create File Name (legacy)< 1 %
- Table Creator< 1 %
- Java Snippet< 1 %
Loop End< 1 %- Group Loop Start< 1 %
Regression Predictor< 1 %Gradient Boosted Trees Predictor< 1 %Concatenate (Optional in)< 1 %- Column Rename (Regex)< 1 %
- Constant Value Column< 1 %
- Constant Value Column Filter< 1 %
- Reference Row Splitter< 1 %
Joiner< 1 %- Partitioning< 1 %
- String Splitter (Regex)< 1 %
- Number Rounder< 1 %
- Shuffle< 1 %
- Column Splitter< 1 %
- Column Expressions (legacy)< 1 %
- H2O to Table< 1 %
Google Analytics Query (deprecated)< 1 %- Apply Color Settings To Labels< 1 %
- Date&Time to String< 1 %
Extract Date&Time Fields< 1 %- Create Collection Column< 1 %
- Breakpoint< 1 %
Table Row to Variable< 1 %Parameterized Database Query< 1 %- Random Forest Predictor< 1 %
- Number to String< 1 %
- String to Number< 1 %
- Excel Reader< 1 %
- CSV Reader< 1 %
Variable to Table Row< 1 %Database Writer< 1 %Loop End (2 ports)< 1 %Naive Bayes Predictor< 1 %PCA Compute< 1 %Random Forest Predictor< 1 %- Case Converter< 1 %
- Column Aggregator< 1 %
Column Appender< 1 %- Column Renamer (Dictionary)< 1 %
- End IF< 1 %
- GET Request< 1 %
- String to Date&Time< 1 %
- Date&Time-based Row Filter< 1 %
- Set Operator< 1 %
CASE Switch Data (End)< 1 %- DB Writer< 1 %
Excel Reader (XLS)< 1 %- Topic Extractor (Parallel LDA)< 1 %
Execute JavaScript< 1 %- Column Appender< 1 %
- Read Excel Sheet Names< 1 %
- MolConverter< 1 %
- Delete Files (legacy)< 1 %
- Catch Errors (Data Ports)< 1 %
Database Connection Table Reader< 1 %Extract Context Properties< 1 %- Chunk Loop Start< 1 %
Variable Loop End< 1 %Naive Bayes Learner< 1 %Random Forest Learner< 1 %- Correlation Filter< 1 %
- RowID< 1 %
- Ungroup< 1 %
- Spark Statistics< 1 %
- One Row to Many< 1 %
- Math Formula (Multi Column)< 1 %
- Java Snippet Row Filter< 1 %
- Decision Tree View (JavaScript)< 1 %
- Network Analyzer< 1 %
- R Snippet< 1 %
- Time to String (legacy)< 1 %
XML Reader< 1 %- XLS Control Table Generator< 1 %
- Canonical SMILES< 1 %
- Combine Columns by Header< 1 %
- Number Formatter< 1 %
- ARIMA Predictor< 1 %
- Active Branch Inverter< 1 %
Table Column to Variable< 1 %- MultiLayerPerceptron Predictor< 1 %
- PCA Compute< 1 %
Gradient Boosted Trees Predictor< 1 %- Denormalizer (PMML)< 1 %
- HiLite Table (legacy)< 1 %
- k-Medoids< 1 %
- Replacer< 1 %
- Local File Browser Configuration< 1 %
- Modify Time< 1 %
- RDKit To InChI< 1 %
Loop End (3 ports)< 1 %- Split Collection Column< 1 %
- Loop End (Column Append)< 1 %
- Fuzzy c-Means< 1 %
- SVM Predictor< 1 %
- Simple Regression Tree Predictor< 1 %
- Missing Value Column Filter< 1 %
- Reference Column Resorter< 1 %
- Row Sampling< 1 %
- Unpivot< 1 %
- Independent groups t-test< 1 %
- Empty Table Switch< 1 %
- IF Switch< 1 %
- Conditional Box Plot (legacy)< 1 %
- PMML to SQL< 1 %
- Spark Correlation Matrix< 1 %
H2O Random Forest Learner< 1 %- Item Set Finder (Borgelt)< 1 %
- DF< 1 %
- NGram Creator< 1 %
Google Analytics Connector (deprecated)< 1 %Python Script (1⇒1)< 1 %- Date&Time Difference< 1 %
- Extract Time Window (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
Twitter Streaming (legacy)< 1 %- RDKit From Molecule< 1 %
Table Extractor< 1 %- CIR< 1 %
XLS Formatter (apply)< 1 %- MMP Molecule Filter (RDKit)< 1 %
- Read Images< 1 %
Database Delete< 1 %Line Reader< 1 %- Feature Selection Filter< 1 %
- Gradient Boosted Trees Predictor (Regression)< 1 %
- Cell Splitter< 1 %
- Cell Splitter By Position< 1 %
- Table Validator< 1 %
- Table Validator (Reference)< 1 %
- CAIM Binner< 1 %
- Interactive HiLite Collector< 1 %
- Normalizer (PMML)< 1 %
String To Number (PMML)< 1 %CASE Switch Variable (End)< 1 %- Lift Chart (legacy)< 1 %
- Scatter Plot (legacy)< 1 %
- Save Workflow< 1 %
- DB Reader< 1 %
- TimeDelay Loop End< 1 %
- Similarity Search< 1 %
- Index Query< 1 %
- Java Snippet Row Splitter< 1 %
- String Matcher< 1 %
- Integer Input (legacy)< 1 %
- Value Selection (legacy)< 1 %
- Window Loop Start< 1 %
- Date/Time Shift (legacy)< 1 %
- Moving Average< 1 %
- Remove Empty Rows< 1 %
- RDKit From InChI< 1 %
- Google Address Geocoder< 1 %
- Create File/Folder Variables< 1 %
- R-Group Decomposer< 1 %
Flow Variable IF Switch< 1 %- Table Row To Variable Run-for-time Loop Start< 1 %
- Read Variables< 1 %
- Naming< 1 %
- URL to File Path (Variable)< 1 %
Table Column to Variable< 1 %CSV Writer< 1 %Database Reader< 1 %Database SQL Executor< 1 %List Files< 1 %Table Reader< 1 %Table Writer< 1 %- Java Edit Variable< 1 %
Recursive Loop End (2 ports)< 1 %Recursive Loop Start< 1 %- Regression Predictor< 1 %
- Binner (Dictionary)< 1 %
Cell Replacer< 1 %- Column Auto Type Cast< 1 %
- Category to Number< 1 %
Number To String< 1 %- Create Table Structure< 1 %
- Cross Joiner< 1 %
- HiLite Row Splitter< 1 %
- Low Variance Filter< 1 %
- Numeric Row Splitter< 1 %
- String Replacer< 1 %
- Renderer to Image< 1 %
- Numeric Outliers< 1 %
Merge Variables< 1 %- Crosstab< 1 %
- Pie chart (legacy)< 1 %
Color Appender< 1 %- Color Manager< 1 %
Read Excel Sheet Names (XLS)< 1 %- Java Snippet (simple)< 1 %
- Java IF (Table)< 1 %
- RSS Feed Reader< 1 %
Bag of Words Creator< 1 %- Bag Of Words Creator< 1 %
- Sentence Extractor< 1 %
- Value Filter (legacy)< 1 %
- Date&Time Input (legacy)< 1 %
- Table View (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
- JSON to Table< 1 %
- CellProfiler Measurements To Table< 1 %
Python Script (1⇒2)< 1 %Python Script (2⇒1)< 1 %- Moving Aggregator< 1 %
- String to Date/Time (legacy)< 1 %
- Byte Converter< 1 %
- CDK to Molecule< 1 %
- Molecular Properties< 1 %
- RDKit Substructure Counter< 1 %
- Quit WebDriver< 1 %
- XLS Cell Formatter< 1 %
- XLS Font Formatter< 1 %
- XLS Row and Column Sizer< 1 %
- Molecule Properties< 1 %
- FileToTable< 1 %
Flow Variable End IF< 1 %Flow Variable IF Switch (Flow Variable Value)< 1 %Loop End (Upto 4 ports)< 1 %- MMP Molecule Fragment (RDKit)< 1 %
- Z-Primes (PC x NC)< 1 %
- TSNE< 1 %
- Virtual Screening Metrics< 1 %
Element Selector< 1 %- Download / Upload from List (legacy)< 1 %
- File Meta Info (legacy)< 1 %
- Port to URI< 1 %
- Strings to Binary Objects< 1 %
Image Writer (Port)< 1 %- ARFF Reader< 1 %
Database Pivot< 1 %Model Writer< 1 %- K Nearest Neighbor< 1 %
PCA Apply< 1 %- Entropy Scorer< 1 %
- Tree Ensemble Learner (Regression)< 1 %
- Random Forest Learner (Regression)< 1 %
- Bootstrap Sampling< 1 %
- Line Chopper< 1 %
- Column Comparator< 1 %
- Lag Column< 1 %
- Many to One< 1 %
- Edit Nominal Domain< 1 %
- Equal Size Sampling< 1 %
- Extract Missing Value Cause< 1 %
- Reference Column Splitter< 1 %
- Subset Matcher< 1 %
- One to Many (PMML)< 1 %
- Missing Value (Apply)< 1 %
- Top k Row Filter< 1 %
- Rule Engine Variable< 1 %
- Ruleset Editor< 1 %
- Data Explorer< 1 %
- Numeric Outliers (Apply)< 1 %
CASE Switch Data (Start)< 1 %- Global Timer Info< 1 %
- Histogram (legacy)< 1 %
- Extract Color< 1 %
- Shape Manager< 1 %
- Size Manager< 1 %
- Molecule Type Cast< 1 %
- DB Insert< 1 %
- Conditional Label Assigner< 1 %
- Gaussian Distributed Assigner< 1 %
- TimeDelay Loop Start< 1 %
- PMML to Cell< 1 %
- PMML Predictor< 1 %
- H2O MOJO Predictor (Regression)< 1 %
- H2O Random Forest Learner< 1 %
- H2O Gradient Boosting Machine Learner< 1 %
H2O Generalized Linear Model Learner (Regression)< 1 %- H2O Generalized Linear Model Learner (Regression)< 1 %
- H2O Numeric Scorer< 1 %
- Association Rule Learner (Borgelt)< 1 %
- Math Formula (Variable)< 1 %
- Spark Line Appender< 1 %
- IDF< 1 %
- Case Converter< 1 %
- Dictionary Replacer< 1 %
- Hyphenator< 1 %
- RegEx Filter< 1 %
- Word Parser< 1 %
- Document Data Assigner< 1 %
- Document Data Extractor< 1 %
Meta Info Extractor< 1 %Strings To Document< 1 %- Strings to Document< 1 %
- Term to String< 1 %
- Term Vector< 1 %
- Date&Time Configuration< 1 %
- Value Selection Configuration< 1 %
- Credentials Input (legacy)< 1 %
- ROC Curve (JavaScript)< 1 %
- Date&Time Widget< 1 %
- JSON Row Combiner< 1 %
- JSON to XML< 1 %
- Track HiLite Propagator< 1 %
- PUT Request< 1 %
- Duration to Number< 1 %
- Date&Time to legacy Date&Time< 1 %
- Time Difference (legacy)< 1 %
- Time Field Extractor (legacy)< 1 %
- Time Generator (legacy)< 1 %
- Web Log Reader< 1 %
- Discretise< 1 %
- Table to HTML String< 1 %
- XLogP< 1 %
- RDKit Molecule Highlighting< 1 %
- RDKit From IUPAC< 1 %
- RDKit Molecule Substructure Filter< 1 %
- RDKit To Molecule< 1 %
- RDKit Substructure Filter< 1 %
- Text Classifier Model to Table< 1 %
- Latitude/Longitude to Coordinate< 1 %
- HTTP Result Data Extractor< 1 %
Web Searcher< 1 %Extract Outer/InnerHTML< 1 %- Synchronize< 1 %
- Variable Loop End< 1 %
- Table Row to Variable Loop Start< 1 %
- Row Filter (Labs)< 1 %
- Random Label Assigner (Data)< 1 %
- Path to String (Variable)< 1 %
- String to Path< 1 %
- String to Path (Variable)< 1 %
- File Chooser (legacy)< 1 %
Views
- This node has no views
Workflows
00_KNIME_Workshop_basicsKNIME Hub- 2019_08_22_Excel_Files_ManipulationsKNIME Hub
- 20200405IdentifyNuclei_measure2ChannelsKNIME Hub
- 23_XLS_MultipleSheetsViaLoopKNIME Hub
- Append_Excel_SheetKNIME Hub
- Show all 30 workflows
Links
- XML in CSV or xlsx or something elseby armingrudd on 2019-10-09forum.knime.com/p/71983
- Insert Data of Knime in prepared Excel tableby izaychik63 on 2018-08-30forum.knime.com/p/47124
- How to read multiple excel files in one folder?by izaychik63 on 2018-08-01forum.knime.com/p/46067
- Overwrite data into existing Excel sheetby armingrudd on 2019-05-24forum.knime.com/p/61154
- Insert content in an existent external spreadsheetby mlauber71 on 2019-06-24forum.knime.com/p/62838
- Show all 8 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.