This node reads Excel files (xlsx, xlsm, xlsb, and xls format). It can read a single or multiple files
at the same time, however reading only one sheet per file. The supported Excel types that can be read in
are string, number, boolean, date, and time but not pictures, diagrams, etc.
The data is read in and converted to the KNIME types string, integer, long, double, boolean, local date,
local time, and local date&time. Upon execution, the node will scan the input file to determine
number and types of the columns and output a table with the auto-guessed structure and KNIME types.
Formulas can also be read in and reevaluated if desired.The performance of this node is limited
(due to the underlying library of the Apache POI project). Reading large files takes a long time and
uses a lot of memory (especially files in xlsx format when formula reevaluation is enabled).
The dialog of this node shows a preview and the file content. While the preview shows the
table that will be read in having the settings applied and is updated once a setting is changed, the file
content shows the content of the file as it is displayed in Excel. This allows finding row numbers and
column names easier to specify different settings.
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
File and Sheet
Data Area
Advanced
Transformation
Popular Successors
- Concatenate8 %
- Column Filter8 %
Row Filter (deprecated)8 %- GroupBy5 %
- String Manipulation3 %
- Rule-based Row Filter3 %
- Excel Writer2 %
- Duplicate Row Filter2 %
- Rule Engine2 %
- Number to String2 %
- Missing Value2 %
- Loop End2 %
- String to Number1 %
- Column Expressions1 %
- Partitioning1 %
- Constant Value Column1 %
- Reference Row Filter1 %
- Math Formula1 %
- Cell Splitter1 %
- DB Writer1 %
- String to Date&Time1 %
Row Splitter (deprecated)< 1 %- Value Lookup< 1 %
- Unpivot< 1 %
- Column Renamer< 1 %
- Rule-based Row Splitter< 1 %
- CSV Writer< 1 %
- Nominal Value Row Filter< 1 %
- Sorter< 1 %
- Statistics< 1 %
- Cross Joiner< 1 %
- Table Manipulator< 1 %
- Date&Time Part Extractor< 1 %
- Normalizer< 1 %
- Pivot< 1 %
Joiner< 1 %- Table Transposer< 1 %
- Column Combiner< 1 %
- Molecule Type Cast< 1 %
- DB Insert< 1 %
- String Manipulation (Multi Column)< 1 %
- Date&Time-based Row Filter< 1 %
- Date&Time to String< 1 %
- Column Resorter< 1 %
- Case Converter< 1 %
- Column Appender< 1 %
- Bar Chart< 1 %
- k-Means< 1 %
- Table Row to Variable Loop Start< 1 %
- String Replacer< 1 %
- Color Manager< 1 %
- Regression Predictor< 1 %
- Group Loop Start< 1 %
- Statistics View< 1 %
Database Looping< 1 %- Linear Correlation< 1 %
- Linear Regression Learner< 1 %
- Value Counter< 1 %
- Row Sampling< 1 %
- Column Splitter< 1 %
- Chunk Loop Start< 1 %
- Excel Reader< 1 %
- Row Filter (Labs)< 1 %
- Reference Row Splitter< 1 %
- Data Explorer< 1 %
- DB Table Creator< 1 %
- Date&Time Difference< 1 %
- Missing Value Column Filter< 1 %
- Path to String< 1 %
- RowID< 1 %
- Table Writer< 1 %
- Column Renamer (Dictionary)< 1 %
- Java Snippet< 1 %
- Numeric Outliers< 1 %
- Column Merger< 1 %
- Excel Cell Updater< 1 %
- String Replacer (Dictionary)< 1 %
- Decision Tree Learner< 1 %
- Table Cropper< 1 %
- Reference Column Filter< 1 %
- Category to Number< 1 %
- Strings to Document< 1 %
- Decision Tree Predictor< 1 %
- Column Aggregator< 1 %
- Column Rename (Regex)< 1 %
- Column Name Extractor< 1 %
- Table Difference Finder< 1 %
- Nominal Value Row Splitter< 1 %
- Number Rounder< 1 %
- Python Script (legacy)< 1 %
- Joiner< 1 %
- Auto-Binner< 1 %
- Math Formula (Multi Column)< 1 %
- DB Loader< 1 %
- Table View< 1 %
Loop End< 1 %- Row to Column Names< 1 %
- Filter Apply< 1 %
- Rank< 1 %
- String Splitter (Regex)< 1 %
- Pie Chart< 1 %
- Box Plot< 1 %
- Table Splitter< 1 %
- K Nearest Neighbor< 1 %
- Row Aggregator< 1 %
- Logistic Regression Predictor< 1 %
- Cell Splitter By Position< 1 %
- Modify Date< 1 %
- Catch Errors (Data Ports)< 1 %
Column Rename< 1 %- Counter Generation< 1 %
- Rank Correlation< 1 %
- Table Validator (Reference)< 1 %
- Histogram< 1 %
Database Writer< 1 %- Normalizer (PMML)< 1 %
- DB Update< 1 %
- Rule Engine (Dictionary)< 1 %
- XLS Control Table Generator< 1 %
- Number to String (PMML)< 1 %
- Modify Time< 1 %
- Hierarchical Clustering< 1 %
- Column List Loop Start< 1 %
- Logistic Regression Learner< 1 %
- Create Bit Vector< 1 %
- Send to Power BI< 1 %
- Random Forest Predictor< 1 %
- PMML Predictor< 1 %
- Dictionary Tagger< 1 %
- Create Collection Column< 1 %
- One to Many< 1 %
- Extract Table Dimension< 1 %
- Path to String (Variable)< 1 %
- Domain Calculator< 1 %
- One-way ANOVA< 1 %
- Parquet Writer< 1 %
- Date&Time Shift< 1 %
- Scatter Plot (legacy)< 1 %
- Scatter Matrix (legacy)< 1 %
- Parameterized DB Query Reader< 1 %
- Table Row to Variable< 1 %
- Column Auto Type Cast< 1 %
- Lag Column< 1 %
- Similarity Search< 1 %
- DB Looping< 1 %
- Table to JSON< 1 %
- Numeric Binner< 1 %
- Normalizer (Apply)< 1 %
- Extract Table Spec< 1 %
- Java Snippet (simple)< 1 %
- X-Partitioner< 1 %
- Top k Row Filter< 1 %
- DB Merge< 1 %
- R Snippet< 1 %
- Conditional Box Plot (legacy)< 1 %
- String to Date/Time (legacy)< 1 %
- Table Creator< 1 %
- PCA< 1 %
- Reference Column Resorter< 1 %
- String Manipulation (Variable)< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- IF Switch< 1 %
- Data to Report (BIRT)< 1 %
- Column Comparator< 1 %
- OpenBabel< 1 %
- Date&Time to legacy Date&Time< 1 %
- Files/Folders Meta Info< 1 %
- Fuzzy c-Means< 1 %
- String to Number (PMML)< 1 %
- String Matcher< 1 %
- Cluster Assigner< 1 %
- Association Rule Learner< 1 %
- Cell Extractor< 1 %
- RDKit From IUPAC< 1 %
- Polynomial Regression Learner< 1 %
- Binner (Dictionary)< 1 %
- DB Connector< 1 %
- String to Path< 1 %
- Table View (JavaScript)< 1 %
- Molecule to CDK< 1 %
- RDKit Canon SMILES< 1 %
- Reference Column Splitter< 1 %
- CASE Switch End< 1 %
- GET Request< 1 %
- Create Date&Time Range< 1 %
- Scorer< 1 %
- Row Splitter (Labs)< 1 %
- Heatmap< 1 %
- Write To Excel Template (deprecated)< 1 %
- Missing Value (Apply)< 1 %
- Set Operator< 1 %
- Crosstab< 1 %
- Sunburst Chart< 1 %
- Tableau Writer< 1 %
- Double to Integer< 1 %
- Microsoft SQL Server Connector< 1 %
- Variable Loop End< 1 %
Cell Replacer< 1 %- Column to Grid< 1 %
- Numeric Row Splitter< 1 %
- Linear Discriminant Analysis< 1 %
- Empty Table Switch< 1 %
- Box Plot (JavaScript)< 1 %
- Naive Bayes Learner< 1 %
- Simple Regression Tree Learner< 1 %
- Independent groups t-test< 1 %
- Interactive Pie chart (legacy)< 1 %
- Box Plot (legacy)< 1 %
- Scatter Plot Matrix< 1 %
- Advanced MolConverter< 1 %
- CSV Reader< 1 %
- Equal Size Sampling< 1 %
- Subset Matcher< 1 %
- Lift Chart (legacy)< 1 %
- Density Plot< 1 %
- Google Sheets Writer< 1 %
- Variable to Table Column< 1 %
Parameterized Database Query< 1 %- Loop End (Column Append)< 1 %
- Stacked Area Chart< 1 %
- Generic JavaScript View (JavaScript)< 1 %
- Shape Manager< 1 %
- Bar Chart (JavaScript)< 1 %
- String to JSON< 1 %
- MultiLayerPerceptron Predictor< 1 %
- Random Forest Learner< 1 %
- Table Updater< 1 %
- Single sample t-test< 1 %
- Histogram (legacy)< 1 %
DB Table Creator< 1 %- Stop Word Filter< 1 %
- Moving Average< 1 %
- Recursive Loop Start< 1 %
- SMOTE< 1 %
- Table Validator< 1 %
- CASE Switch Start< 1 %
- Line Plot (legacy)< 1 %
- Send to Tableau Server< 1 %
- R View (Table)< 1 %
- Regex Extractor< 1 %
Table Row To Variable Loop Start< 1 %- Add Empty Rows< 1 %
- Constant Value Column Filter< 1 %
- End IF< 1 %
- Send Email< 1 %
- Parallel Coordinates (legacy)< 1 %
- Interactive Table (legacy)< 1 %
- Distance Matrix Calculate< 1 %
- Table to H2O< 1 %
- Tag Cloud< 1 %
- Date Field Extractor (legacy)< 1 %
- Read Images< 1 %
Concatenate (Optional in)< 1 %- Filter Apply Row Splitter< 1 %
- Shuffle< 1 %
- Ungroup< 1 %
- Interactive Histogram (legacy)< 1 %
- Pie chart (legacy)< 1 %
- Transfer Files (Table)< 1 %
- Google Sheets Updater< 1 %
- RDKit From Molecule< 1 %
- BERT Predictor< 1 %
- Table Row To Variable Run-for-time Loop Start< 1 %
- MolConverter< 1 %
Variable Condition Loop End< 1 %- Generic Loop Start< 1 %
- DBSCAN< 1 %
- Numeric Scorer< 1 %
- PMML Gradient Boosted Trees Predictor (Regression)< 1 %
- HiLite Row Splitter< 1 %
- Column Filter (PMML)< 1 %
- DB Query Reader< 1 %
- ARIMA Visualization< 1 %
- URL to File Path< 1 %
- Extract Variables (Data)< 1 %
- Fuzzy Rule Learner< 1 %
- SVM Learner< 1 %
- DB SQL Executor< 1 %
- Numeric Distances< 1 %
- String Distances< 1 %
Excel Reader (XLS)< 1 %- Read Excel Sheet Names< 1 %
- Tika Language Detector< 1 %
- Number Filter< 1 %
- RSS Feed Reader< 1 %
- Wildcard Tagger< 1 %
- Heatmap (JavaScript)< 1 %
- Scatter Plot (JavaScript)< 1 %
Extract Date&Time Fields< 1 %- Modify Time Zone< 1 %
- Split Collection Column< 1 %
- Copy/Move Files (legacy)< 1 %
- Feature Selection Loop Start (1:1)< 1 %
- Conditional Box Plot (JavaScript)< 1 %
Excel Sheet Appender (XLS)< 1 %- Java Snippet Row Filter< 1 %
- Path to URI< 1 %
- Text Output Widget (legacy)< 1 %
- POST Request< 1 %
- XML Writer< 1 %
- BERT Embedder< 1 %
- Window Slider< 1 %
- Substructure Matcher< 1 %
- Files to Binary Objects< 1 %
- Upload (legacy)< 1 %
- Feature Selection Filter< 1 %
- Counting Loop Start< 1 %
- PNN Learner (DDA)< 1 %
- Tree Ensemble Predictor< 1 %
- Correlation Filter< 1 %
- CAIM Binner< 1 %
String Replace (Dictionary)< 1 %- Numeric Outliers (Apply)< 1 %
- Kolmogorov-Smirnov Test< 1 %
- Save Workflow< 1 %
- Mahalanobis Distance< 1 %
- Association Rule Learner (Borgelt)< 1 %
- OSM Map View< 1 %
- Nominal Row Filter Configuration< 1 %
- Value Filter Definition (legacy)< 1 %
- Columns to JSON< 1 %
- Image Viewer< 1 %
- Webpage Retriever< 1 %
- Date Extractor< 1 %
- Duplicate Filter< 1 %
XLS Formatter (apply)< 1 %- XLS Conditional Formatter< 1 %
- R Plot< 1 %
- Create File Name (legacy)< 1 %
- Variable to Table Row< 1 %
- Fuzzy Rule Predictor< 1 %
- Random Forest Predictor (Regression)< 1 %
- Extract Missing Value Cause< 1 %
- Ruleset Editor< 1 %
- Linear Discriminant Analysis Compute< 1 %
- Merge Variables< 1 %
- HiLite Table (legacy)< 1 %
- Table to Spark< 1 %
- Amazon Translate< 1 %
- MySQL Connector< 1 %
- DL Python Network Learner< 1 %
- Boosting Predictor Loop End< 1 %
- JPython Function (Legacy)< 1 %
- NGram Creator< 1 %
- Sentence Extractor< 1 %
- Weka Predictor (3.7)< 1 %
- Column Selection Widget< 1 %
- JSON Path< 1 %
- JSON to Table< 1 %
- Parameter Optimization Loop Start (Table)< 1 %
XGBoost Linear Ensemble Learner< 1 %- Lipinski's Rule-of-Five< 1 %
- Fingerprints< 1 %
- XLS Control Table Merger< 1 %
- Canonical SMILES< 1 %
- Trim Table< 1 %
- Join Layout< 1 %
- Expand Well Position< 1 %
- Plate Heatmap Viewer< 1 %
- Python Snippet 2:2< 1 %
- R Snippet< 1 %
- 2D/3D Scatterplot< 1 %
- String to URI< 1 %
- Breakpoint< 1 %
- Active Branch Inverter< 1 %
- Table Column to Variable< 1 %
Table Row to Variable< 1 %- ARFF Writer< 1 %
CSV Writer< 1 %Database Update< 1 %- Java Edit Variable< 1 %
Generic Loop Start< 1 %- X-Aggregator< 1 %
- PCA Compute< 1 %
- Simple Regression Tree Predictor< 1 %
- Auto-Binner (Apply)< 1 %
- Rule-based Row Splitter (Dictionary)< 1 %
- Bland-Altman Plot< 1 %
- Paired t-test< 1 %
- Scatter Plot< 1 %
- SDF Writer< 1 %
- One Row to Many< 1 %
- Matrix Distance< 1 %
- Autocomplete Text Widget< 1 %
- Histogram (JavaScript)< 1 %
- Surface Plot (Plotly)< 1 %
- External Tool< 1 %
- Scatter Plot (JFreeChart)< 1 %
- Table Indexer< 1 %
- Rule Viewer (local) (Legacy)< 1 %
- Spark Line Appender< 1 %
- Delete Files/Folders< 1 %
- JPMML Classifier< 1 %
- Value Filter (legacy)< 1 %
- Value Selection (legacy)< 1 %
- Scorer (JavaScript)< 1 %
- JSON Path (Dictionary)< 1 %
- Feature Inserter< 1 %
- Python Predictor (legacy)< 1 %
- Table to R< 1 %
- Legacy Date&Time to Date&Time< 1 %
- RDKit To Molecule< 1 %
- CIR< 1 %
- Table Merger< 1 %
- Price Maximize< 1 %
- Scale Purchased< 1 %
- Open in R< 1 %
- PubChem Search< 1 %
- ARIMA Learner< 1 %
- Try (Data Ports)< 1 %
Table Row to Variable< 1 %- Naive Bayes Predictor< 1 %
- Hierarchical Clustering (DistMatrix)< 1 %
- RProp MLP Learner< 1 %
- Gradient Boosted Trees Learner< 1 %
- Gradient Boosted Trees Predictor (Regression)< 1 %
- Tree Ensemble Learner (Regression)< 1 %
- Tree Ensemble Predictor (Regression)< 1 %
- Category to Number (Apply)< 1 %
String To Number< 1 %- Denormalizer< 1 %
- One to Many (PMML)< 1 %
- Cell Updater< 1 %
- Renderer to Image< 1 %
- Proportion Test< 1 %
- Color Appender< 1 %
- ROC Curve (legacy)< 1 %
- ROC Curve< 1 %
- ORC Writer< 1 %
- Workflow Executor< 1 %
- DB Column Rename< 1 %
- Random Number Assigner (Apache)< 1 %
- Keras Network Executor< 1 %
- 3D Scatter Plot (Plotly)< 1 %
- Model Loop Start< 1 %
- Generic Web Service Client< 1 %
- Index Query< 1 %
- Word2Vec Learner (legacy)< 1 %
- Frequency Filter< 1 %
- Category to Class< 1 %
- Diacritic Remover< 1 %
- Dictionary Replacer< 1 %
- Punctuation Erasure< 1 %
- Document Vector< 1 %
- Document Viewer< 1 %
- Transfer Files< 1 %
- Tile View (JavaScript)< 1 %
- Container Output (JSON)< 1 %
- Duration to Number< 1 %
- String to Duration< 1 %
- XPath< 1 %
- HTML Parser< 1 %
- XLS Cell Formatter< 1 %
- Polygon Properties< 1 %
- Matlab Plot< 1 %
- Elemental Analysis< 1 %
- Regex Substring< 1 %
- Regex To List< 1 %
- File Meta Info (legacy)< 1 %
- URI to String< 1 %
- URL to File Path (Variable)< 1 %
Variable to Table Column< 1 %- Inject Variables (Data)< 1 %
Database Table Creator< 1 %- File Reader< 1 %
- Image Writer (Table)< 1 %
Table Writer< 1 %- Interval Loop Start< 1 %
- OPTICS Cluster Compute< 1 %
- Entropy Scorer< 1 %
- SOTA Predictor< 1 %
- Tree Ensemble Learner< 1 %
- Random Forest Learner (Regression)< 1 %
- Bootstrap Sampling< 1 %
Number To String< 1 %- Edit Nominal Domain (Dictionary)< 1 %
- Low Variance Filter< 1 %
Normalizer< 1 %- Cronbach Alpha< 1 %
- Shapiro-Wilk Test< 1 %
- Wilcoxon-Mann-Whitney Test< 1 %
- Enrichment Plotter (legacy)< 1 %
- Parallel Coordinates Plot< 1 %
DB Loader< 1 %- Time Series Generator< 1 %
- Bubble Chart (Plotly)< 1 %
- Line Plot (Plotly)< 1 %
- Variable Expressions< 1 %
- Item Set Finder (Borgelt)< 1 %
- GroupBy Bar Chart (JFreeChart)< 1 %
Excel Reader (XLS)< 1 %- SharePoint Online List Writer< 1 %
- SMB Connector< 1 %
- Doc2Vec Learner (legacy)< 1 %
- Keygraph Keyword Extractor< 1 %
- Dictionary Filter< 1 %
Strings To Document< 1 %- Create Folder< 1 %
- Create Temp Folder< 1 %
- Google Sheets Reader< 1 %
- Date&Time Configuration< 1 %
- Column Filter (legacy)< 1 %
- Date&Time Input (legacy)< 1 %
- String Input (legacy)< 1 %
- Line Plot (JavaScript)< 1 %
- Column Filter Widget< 1 %
- Nominal Row Filter Widget< 1 %
- String Widget< 1 %
- Value Selection Widget< 1 %
- JSON Row Combiner< 1 %
- Container Input (Table)< 1 %
- JSON Writer< 1 %
- XML to JSON< 1 %
- JSON to XML< 1 %
- Add Table to R< 1 %
- DELETE Request< 1 %
- Extract Duration Fields< 1 %
- Call Workflow (Table Based)< 1 %
- RDKit Fingerprint< 1 %
- Anonymization< 1 %
- Neo4j Writer< 1 %
- Text Classifier Learner< 1 %
- Google Address Geocoder< 1 %
- Geo Distances< 1 %
- String Similarity< 1 %
- HTTP Retriever< 1 %
- XLS Border Formatter< 1 %
- XLS Background Colorizer< 1 %
- XLS Font Formatter< 1 %
- XLS Row and Column Sizer< 1 %
- XLS Sheet Properties< 1 %
- XLS Sheet Selector< 1 %
- XLS Control Table from Cell Range< 1 %
- Model Acceptability Criteria< 1 %
- Feature Table To List< 1 %
- TIBCO Spotfire File Writer< 1 %
- Speedy Sequence to SMILES< 1 %
- Speedy Sequence Analysis< 1 %
- PMI Triangle Scatter Plot< 1 %
- Speedy SMILES De-salt< 1 %
- Chunk Loop Run-for-time Loop Start< 1 %
- Run Garbage Collector< 1 %
- 2D Kernel Density Plot< 1 %
- PDB Downloader< 1 %
- Dose Response (R)< 1 %
- Open in Python< 1 %
- Python Plot< 1 %
- Python Snippet< 1 %
- Convert to R< 1 %
- Text Extractor< 1 %
- ZXing Encoder< 1 %
- Evaluate Excel Formula< 1 %
- Table To Excel Cell Updater< 1 %
- Write To Excel Template< 1 %
- XLS Coloured Writer< 1 %
- ARIMA Predictor< 1 %
- Binary Objects to Strings< 1 %
- Download / Upload from List (legacy)< 1 %
- Extract URI Info< 1 %
- Strings to Binary Objects< 1 %
- Zip Files (legacy)< 1 %
- Wait...< 1 %
- Catch Errors (Var Ports)< 1 %
- Try (Variable Ports)< 1 %
Variable to Table Column< 1 %Table Column to Variable< 1 %- Variable to Credentials< 1 %
- Table to Image< 1 %
- Table Reader< 1 %
- Variable Creator< 1 %
Loop End (2 ports)< 1 %Counting Loop Start< 1 %Interval Loop Start< 1 %- Variable Condition Loop End< 1 %
- Recursive Loop End< 1 %
Recursive Loop Start (2 ports)< 1 %Table Row To Variable Loop Start< 1 %- PNN Predictor< 1 %
- Silhouette Coefficient< 1 %
- Hierarchical Cluster Assigner (local)< 1 %
- Hierarchical Cluster View< 1 %
- Decision Tree to Image< 1 %
- SOTA Learner< 1 %
- SVM Predictor< 1 %
- PCA Apply< 1 %
- PCA Inversion< 1 %
- Gradient Boosted Trees Learner (Regression)< 1 %
- Gradient Boosted Trees Predictor< 1 %
- PMML Gradient Boosted Trees Predictor< 1 %
- PMML Simple Regression Tree Predictor< 1 %
Cell Splitter< 1 %- Number to Category (Apply)< 1 %
- String to SVG< 1 %
Column Appender< 1 %- Many to One< 1 %
Linear Correlation< 1 %- Edit Nominal Domain< 1 %
- Edit Numeric Domain< 1 %
Column Filter< 1 %- Interactive HiLite Collector< 1 %
- Numeric Binner (PMML)< 1 %
- Normalizer Apply (PMML)< 1 %
- Denormalizer (PMML)< 1 %
- Nominal Probability Distribution Creator< 1 %
- Rule Engine Variable< 1 %
- Kaplan-Meier Estimator< 1 %
- Kruskal-Wallis Test< 1 %
- Linear Discriminant Analysis Apply< 1 %
CASE Switch Data (End)< 1 %- Cache< 1 %
- Timer Info< 1 %
Color Appender< 1 %- Size Manager< 1 %
- Line Plot< 1 %
- Parquet Reader< 1 %
Parquet Writer< 1 %- Capture Workflow End< 1 %
- Capture Workflow Start< 1 %
- Smiles Directory Writer< 1 %
- Parallel Chunk Start< 1 %
MySQL Connector< 1 %- Oracle Connector< 1 %
- PostgreSQL Connector< 1 %
- DB Delete (Table)< 1 %
- Random Number Assigner< 1 %
- Random Label Assigner (Data)< 1 %
- TimeDelay Loop End< 1 %
- k-Medoids< 1 %
- K Nearest Neighbor (Distance Function)< 1 %
- Keras Network Learner< 1 %
- Contour Plot (Plotly)< 1 %
- Pie/Donut Chart (JavaScript)< 1 %
- Scatter Plot (Plotly)< 1 %
- Sunburst Chart (JavaScript)< 1 %
- Violin Plot (Plotly)< 1 %
- Table to HTML (legacy)< 1 %
- Table to PDF (legacy)< 1 %
- H2O MOJO Predictor (Regression)< 1 %
- Math Formula (Variable)< 1 %
- Bar Chart (JFreeChart)< 1 %
- HeatMap (JFreeChart)< 1 %
- Histogram Chart (JFreeChart)< 1 %
- Line Chart (JFreeChart)< 1 %
- Pie Chart (JFreeChart)< 1 %
- OSM Map to Image< 1 %
- Geo-Coordinate Row Filter< 1 %
Read Excel Sheet Names (XLS)< 1 %Excel Sheet Appender (XLS)< 1 %Excel Writer (XLS)< 1 %Excel Writer (XLS)< 1 %Send to Power BI< 1 %- SharePoint Online Connector< 1 %
- Java IF (Table)< 1 %
- Radar Plot Appender< 1 %
- Word Vector Apply (legacy)< 1 %
- Topic Extractor (Parallel LDA)< 1 %
- Chi-Square Keyword Extractor< 1 %
- Markup Tag Filter< 1 %
- Tika Parser URL Input< 1 %
- Case Converter< 1 %
- N Chars Filter< 1 %
- RegEx Filter< 1 %
- Replacer< 1 %
- Tag Filter< 1 %
Dictionary tagger< 1 %- Dictionary Tagger (Multi Column)< 1 %
- POS Tagger< 1 %
- StanfordNLP NE Learner< 1 %
- Bag Of Words Creator< 1 %
- Document Data Extractor< 1 %
- Meta Info Extractor< 1 %
- String to Term< 1 %
- Term to String< 1 %
- t-SNE (L. Jonsson)< 1 %
- Compress Files/Folder (Table)< 1 %
- Create File/Folder Variables< 1 %
- Delete Files/Folders (Table)< 1 %
- List Files/Folders< 1 %
- String to Path (Variable)< 1 %
- Google Sheets Appender< 1 %
- Column Filter Configuration< 1 %
- Integer Slider Configuration< 1 %
- Column Selection Configuration< 1 %
- Value Selection Configuration< 1 %
- Column Selection (legacy)< 1 %
- Decision Tree View (JavaScript)< 1 %
- Lift Chart (JavaScript)< 1 %
- ROC Curve (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
- Tag Cloud (JavaScript)< 1 %
- Interactive Range Slider Filter Widget< 1 %
- Interactive Value Filter Widget< 1 %
- Slider Widget< 1 %
- File Download Widget< 1 %
- Container Output (Table)< 1 %
- JSON Reader< 1 %
- Kafka Producer< 1 %
- Object Inserter< 1 %
- Multiobjective Score Computation< 1 %
- Python Object Reader (legacy)< 1 %
Python Script (1⇒1)< 1 %- Python Source (legacy)< 1 %
- Python View (legacy)< 1 %
- R Predictor< 1 %
- Table Difference Checker< 1 %
- Duration to String< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Window Loop Start< 1 %
- Date/Time Shift (legacy)< 1 %
- Time Difference (legacy)< 1 %
- Extract Time Window (legacy)< 1 %
- Time Generator (legacy)< 1 %
- Moving Aggregator< 1 %
- Twitter Followers Search< 1 %
- Twitter Users< 1 %
Call Workflow Service< 1 %- XGBoost Predictor< 1 %
- XGBoost Predictor (Regression)< 1 %
- Column to XML< 1 %
- XML Row Combiner< 1 %
- String to XML< 1 %
- XSLT< 1 %
- Table to HTML String< 1 %
- Remove Empty Rows< 1 %
- Molecular Properties< 1 %
- SMARTS Query< 1 %
- RDKit Chemical Transformation< 1 %
- RDKit Descriptor Calculation< 1 %
- RDKit From InChI< 1 %
- RDKit Interactive Table< 1 %
- RDKit Salt Stripper< 1 %
- RDKit Two Component Reaction< 1 %
- BERT Classification Learner< 1 %
- Spacy Tokenizer< 1 %
- Text Classifier Predictor< 1 %
Location Extractor< 1 %- Latitude/Longitude to Coordinate< 1 %
Regex Extractor< 1 %- Hash Calculator< 1 %
- URL Domain Extractor< 1 %
- XLS Cell Merger< 1 %
- Molecule Properties< 1 %
- IL XLS Writer< 1 %
- Correlation Concatenation< 1 %
Flow Variable End IF< 1 %- Number Formatter< 1 %
- Z-Primes (PC x NC)< 1 %
- Hierarchical Cluster Assigner< 1 %
- Many to One (PMML)< 1 %
- Gaussian Distributed Assigner< 1 %
- DL4J Feedforward Predictor (Regression) (legacy)< 1 %
- Java Edit Variable (simple)< 1 %
Send to Tableau Server (Hyper)< 1 %- TF< 1 %
- Python Edit Variable (legacy)< 1 %
- PUT Request< 1 %
- RDKit Molecule Extractor< 1 %
- Web Page Content Extractor< 1 %
- MapQuest Geocoder< 1 %
- URL Normalizer< 1 %
- XLS Formatter (apply)< 1 %
- Substructure Match Counter< 1 %
- Duplicate Remover< 1 %
- FASTA Sequence Extractor< 1 %
- R Snippet (2:1)< 1 %
- Delete Files (legacy)< 1 %
- OPTICS Cluster Assigner< 1 %
- Perl Scripting< 1 %
- Target Shuffling< 1 %
- Rule Engine Variable (Dictionary)< 1 %
Merge Variables< 1 %- Shape Appender< 1 %
- DB Table Selector< 1 %
- Radar Plot (Plotly)< 1 %
- Stacked Area Chart (Plotly)< 1 %
- Prediction Fusion< 1 %
- Cell to Model< 1 %
- Term Co-Occurrence Counter< 1 %
- IDF< 1 %
- Porter Stemmer< 1 %
- Document Data Assigner< 1 %
- Distance Map< 1 %
- Binary Classification Inspector< 1 %
- Python Learner (legacy)< 1 %
- Time Field Extractor (legacy)< 1 %
- Table to Event Log< 1 %
- RDKit Molecule Substructure Filter< 1 %
- RDKit Find Murcko Scaffolds< 1 %
- Cardinality< 1 %
- Distance (1-D)< 1 %
- Coordinate Row Filter< 1 %
- Create Well Position< 1 %
- ChemSpider< 1 %
- Desirability Ranking< 1 %
File Reader< 1 %List Files< 1 %Table Reader< 1 %Recursive Loop End< 1 %- MDS Projection< 1 %
- Ruleset Predictor< 1 %
- PMML Transformation Apply< 1 %
- DB Reader< 1 %
- Random Matcher< 1 %
- 2D Density Plot (Plotly)< 1 %
- Continuous Error Plot (Plotly)< 1 %
- DL4J Feedforward Learner (Pretraining) (legacy)< 1 %
- Table To DL4J Vector (Regression) (legacy)< 1 %
- Interval Chart (JFreeChart)< 1 %
XLS Sheet Appender< 1 %XLS Writer< 1 %- Java Snippet Row Splitter< 1 %
- Stanford Tagger< 1 %
- Compress Files/Folder< 1 %
- Data Row to Image< 1 %
- Time to String (legacy)< 1 %
XML Writer< 1 %- Substructure Search< 1 %
Spacy Tokenizer< 1 %- Coordinate to Latitude/Longitude< 1 %
- N-Gram Extractor< 1 %
- Sequence Properties< 1 %
- Sequence Convert< 1 %
- Network Component Splitter< 1 %
- InChi< 1 %
- Active-Site Ligand Extractor< 1 %
- AutoDock 4< 1 %
- SMILES Writer< 1 %
- Chart View< 1 %
- Domain - Leverage< 1 %
- Correlation Matrix To Pairs< 1 %
- Speedy SMILES Clean '.' non-bonds< 1 %
Flow Variable IF Switch< 1 %- Multiport Loop End< 1 %
- Read Variables< 1 %
- Run Heavy Garbage Collector< 1 %
- 1D Kernel Density Plot< 1 %
- PDB Loader< 1 %
- Vector Distance (n-D)< 1 %
- PDB Property Extractor< 1 %
- URL Decode< 1 %
- URL Encode< 1 %
- Plate Row Converter< 1 %
- Split Columns by Header< 1 %
- Combine Columns by Header< 1 %
- Create Interval< 1 %
- BinningAnalysis< 1 %
- Normalize Plates (Z-Score)< 1 %
- Multivariate Z-Primes< 1 %
- SSMD (PC x NC)< 1 %
- Fix Column Names< 1 %
- Spell Checker (simple)< 1 %
- HNMR Prediction< 1 %
- logD< 1 %
- logP< 1 %
- MarvinView< 1 %
- QRCode Monkey Encoder< 1 %
- Excel Password Manager< 1 %
- Active Learning Loop End< 1 %
- ARIMA Parameter Importer< 1 %
- Catch Errors (Generic Ports)< 1 %
Image Writer (Table Column)< 1 %CSV Reader< 1 %Recursive Loop Start< 1 %- Create Byte Vector< 1 %
- Line Chopper< 1 %
- CAIM Applier< 1 %
- Key-Collection HiLite Translator< 1 %
- Linear Discriminant Analysis Inversion< 1 %
CASE Switch Data (Start)< 1 %- Data Generator< 1 %
- Extract Color< 1 %
- Visualization Property Extractor< 1 %
Parquet Reader< 1 %- SDF Inserter< 1 %
- Amazon Comprehend (Key Phrases)< 1 %
- Amazon Comprehend (Sentiment)< 1 %
- Amazon Comprehend (Entity Tagger)< 1 %
- SQLite Connector< 1 %
- Conditional Label Assigner< 1 %
- Empty Table Creator< 1 %
- Random Label Assigner< 1 %
- TimeDelay Loop Start< 1 %
- Java Distance< 1 %
- Distance Matrix Writer< 1 %
- TensorFlow Network Executor< 1 %
- Boosting Learner Loop Start< 1 %
- PMML Ensemble Predictor< 1 %
- Cell to PMML< 1 %
- DL4J Feedforward Learner (Regression) (legacy)< 1 %
- H2O MOJO Predictor (Classification)< 1 %
- LIBSVMPredictor< 1 %
Microsoft Authenticator (Deprecated)< 1 %- SSH Connector< 1 %
- External SSH Tool< 1 %
- Dictionary Replacer (File-based)< 1 %
- Snowball Stemmer< 1 %
- Abner Tagger< 1 %
- StanfordNLP NE Tagger< 1 %
- Document Vector Applier< 1 %
- Meta Info Inserter< 1 %
- Term Vector< 1 %
- Weka Predictor (3.6) (legacy)< 1 %
- External Tool (Labs)< 1 %
- Google Sheets Connector< 1 %
- String Configuration< 1 %
- Range Slider Filter Definition (legacy)< 1 %
- Double Input (legacy)< 1 %
- Integer Input (legacy)< 1 %
- Date&Time Widget< 1 %
- File Upload Widget< 1 %
- Single Selection Widget< 1 %
- Inverter< 1 %
- SHAP Loop Start< 1 %
- Shapley Values Loop Start< 1 %
- Network Feature Extractor< 1 %
- Hierarchy Extractor< 1 %
- Network Viewer< 1 %
- Multiobjective Subset Selection (NSGA-II)< 1 %
- Rowset Filter< 1 %
Python Script (2⇒1)< 1 %- Mask Date/Time (legacy)< 1 %
- Preset Date/Time (legacy)< 1 %
- Workflow Service Input< 1 %
XGBoost Linear Ensemble Learner (Regression)< 1 %XGBoost Tree Ensemble Learner (Regression)< 1 %Table to HTML String< 1 %Binary Scorer< 1 %- CDK to Molecule< 1 %
- XLogP< 1 %
- Mass Calculator< 1 %
- OPSIN< 1 %
- Sum Formula< 1 %
- RDKit Calculate Charges< 1 %
- RDKit Molecule Catalog Filter< 1 %
- RDKit Molecule Fragmenter< 1 %
- RDKit One Component Reaction< 1 %
- RDKit R-Group Decomposition< 1 %
- RDKit SMILES Headers< 1 %
- RDKit Substructure Filter< 1 %
Map Viewer< 1 %- TF-IDF Similarity< 1 %
- Form Encoded HTTP Entity Creator< 1 %
Views
- This node has no views
Workflows
!Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub- [01.CX] Combining Siloed Legacy Data with Running App's Back-End DatabaseKNIME Hub
- [03.CX] Extracting and Transforming Viber Broadcast Data from InfobipKNIME Hub
- [ON] PEX ROTINAS 2024KNIME Hub
- 00 Send Reporting_vMediumKNIME Hub
- Show all 5583 workflows
Links
- i am on the right way?by AnotherFraudUser on 2021-12-31forum.knime.com/p/143226
- Union multiple excel files with different columnsby knimediger on 2022-10-20forum.knime.com/p/172839
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.