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 reads a spread sheet and provides it at its output port.
It reads only data from one sheet at the moment. It can read only
numeric data (or strings) but, of course, no diagrams, pictures, or other items.
Currently supported KNIME types are String, Double, and Int. (Time or date in the
spread sheet is represented as String and can be translated into the appropriate
TimeAndDateCells with the corresponding nodes.)
It reads in the data from the sheet and sets a type for all columns that
is compatible with the data in that column (in the worst case "String" covers all).
The performance of the reader node is limited (due to the underlying library
of the Apache POI project). Reading large files takes a very long time and uses a
lot of memory (especially files in xlsx format).
Options
Popular Successors
Joiner12 %- Column Filter8 %
Row Filter (deprecated)4 %- GroupBy4 %
- Concatenate3 %
Number To String3 %- Partitioning2 %
- String Manipulation2 %
- Color Manager2 %
- Statistics2 %
Column Rename2 %String To Number2 %- String to Date/Time (legacy)2 %
- Reference Row Filter2 %
- k-Means2 %
- Rule-based Row Filter2 %
- Missing Value1 %
Concatenate (Optional in)1 %- Normalizer1 %
- Math Formula1 %
Database Writer1 %Cell Splitter1 %Strings To Document1 %- Rule Engine< 1 %
- Constant Value Column< 1 %
Cell Replacer< 1 %CSV Writer< 1 %- Unpivot< 1 %
Linear Correlation< 1 %Row Splitter (deprecated)< 1 %XLS Writer< 1 %- Molecule Type Cast< 1 %
Loop End< 1 %- Scatter Plot (legacy)< 1 %
- Decision Tree Predictor< 1 %
- Decision Tree Learner< 1 %
- Pivot< 1 %
- Interactive Table (legacy)< 1 %
- Linear Regression Learner< 1 %
- String Replacer< 1 %
- Box Plot (legacy)< 1 %
- Cross Joiner< 1 %
- Table Transposer< 1 %
- Column Splitter< 1 %
- Java Snippet< 1 %
- Java Snippet (simple)< 1 %
- Interactive Histogram (legacy)< 1 %
- Histogram (legacy)< 1 %
- Create Bit Vector< 1 %
- R Snippet< 1 %
- Reference Row Splitter< 1 %
- Column Combiner< 1 %
- RowID< 1 %
Column Appender< 1 %- Rule-based Row Splitter< 1 %
- Nominal Value Row Filter< 1 %
- Crosstab< 1 %
- Column Renamer (Dictionary)< 1 %
- X-Partitioner< 1 %
Regression Predictor< 1 %- Auto-Binner< 1 %
- Line Plot (legacy)< 1 %
- Hierarchical Clustering< 1 %
K Nearest Neighbor< 1 %- Missing Value Column Filter< 1 %
Table Row To Variable Loop Start< 1 %- Sorter< 1 %
- Value Counter< 1 %
Dictionary tagger< 1 %- Cluster Assigner< 1 %
- Category to Number< 1 %
Table Writer< 1 %Naive Bayes Learner< 1 %Naive Bayes Predictor< 1 %- Reference Column Filter< 1 %
- Conditional Box Plot (legacy)< 1 %
- OpenBabel< 1 %
Gradient Boosted Trees Predictor< 1 %- Column Auto Type Cast< 1 %
XLS Sheet Appender< 1 %Random Forest Predictor< 1 %- Column Aggregator< 1 %
- Column Resorter< 1 %
- Double to Integer< 1 %
- Association Rule Learner< 1 %
- Create Collection Column< 1 %
- Scatter Matrix (legacy)< 1 %
Table Row to Variable< 1 %- Group Loop Start< 1 %
- Interactive Pie chart (legacy)< 1 %
Logistic Regression Learner< 1 %- Numeric Binner< 1 %
- Chunk Loop Start< 1 %
- Row Sampling< 1 %
- Fuzzy c-Means< 1 %
- Pie chart (legacy)< 1 %
- Extract Table Dimension< 1 %
- Object Inserter< 1 %
PCA< 1 %- Polynomial Regression Learner< 1 %
- Case Converter< 1 %
- Cell Splitter By Position< 1 %
- Domain Calculator< 1 %
- Set Operator< 1 %
- Extract Table Spec< 1 %
- Shape Manager< 1 %
- Number Rounder< 1 %
Variable to Table Column< 1 %- Lag Column< 1 %
- Distance Matrix Calculate< 1 %
- Column Filter (legacy)< 1 %
- Correlation Filter< 1 %
Normalizer< 1 %Number To String (PMML)< 1 %String Replace (Dictionary)< 1 %- HTTP Retriever< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Numeric Distances< 1 %
- Column List Loop Start< 1 %
- Rule Engine (Dictionary)< 1 %
- Advanced MolConverter< 1 %
- Column Merger< 1 %
POS tagger< 1 %Scorer< 1 %- One to Many< 1 %
- Shuffle< 1 %
Rank Correlation< 1 %- Counter Generation< 1 %
- Similarity Search< 1 %
- Bar Chart (JFreeChart)< 1 %
- Scatter Plot (JFreeChart)< 1 %
Python Script (1⇒1)< 1 %- Molecule to CDK< 1 %
- DBSCAN< 1 %
- Numeric Row Splitter< 1 %
- k-Medoids< 1 %
- Line Chart (JFreeChart)< 1 %
- Feature Inserter< 1 %
- String Matcher< 1 %
- Google Address Geocoder< 1 %
Database Update< 1 %- Hierarchical Clustering (DistMatrix)< 1 %
PCA Compute< 1 %Simple Regression Tree Learner< 1 %- Column Rename (Regex)< 1 %
- Table Validator< 1 %
- HiLite Row Splitter< 1 %
- Ungroup< 1 %
- Histogram Chart (JFreeChart)< 1 %
XLS Reader< 1 %- R View (Table)< 1 %
- Table to R< 1 %
- RDKit From Molecule< 1 %
- Inject Variables (Data)< 1 %
Counting Loop Start< 1 %- PNN Predictor< 1 %
Random Forest Predictor< 1 %- Simple Regression Tree Predictor< 1 %
- One-way ANOVA< 1 %
- Java Snippet Row Filter< 1 %
- Weka Predictor (3.7)< 1 %
- Date Field Extractor (legacy)< 1 %
Table Column to Variable< 1 %Generic Loop Start< 1 %- Column Comparator< 1 %
- Low Variance Filter< 1 %
String To Number (PMML)< 1 %- String Splitter (Regex)< 1 %
CASE Switch Data (End)< 1 %Expand Well Position< 1 %- 2D/3D Scatterplot< 1 %
- Add Empty Rows< 1 %
- Single sample t-test< 1 %
- ROC Curve (legacy)< 1 %
- Java Snippet Row Splitter< 1 %
Dumb Joiner< 1 %- Latitude/Longitude to Coordinate< 1 %
- Outlier Removal< 1 %
- MarvinView< 1 %
- Fuzzy Rule Learner< 1 %
- HeatMap (JFreeChart)< 1 %
- Spark Line Appender< 1 %
Wildcard tagger< 1 %- Tag Cloud< 1 %
- Table to JSON< 1 %
- R Learner< 1 %
PCA Apply< 1 %- SMOTE< 1 %
- SVM Predictor< 1 %
- Simple Regression Tree Learner< 1 %
- Column Name Extractor< 1 %
- Normalizer (PMML)< 1 %
- Cache< 1 %
- External Tool< 1 %
- GroupBy Bar Chart (JFreeChart)< 1 %
- Pie Chart (JFreeChart)< 1 %
- Punctuation Erasure< 1 %
- String to Term< 1 %
- R Snippet< 1 %
- R Plot< 1 %
- MolConverter< 1 %
- Read Images< 1 %
- Java Edit Variable< 1 %
Backward Feature Elimination Filter< 1 %- Decision Tree to Image< 1 %
- MultiLayerPerceptron Predictor< 1 %
- RProp MLP Learner< 1 %
- Entropy Scorer< 1 %
- SVM Learner< 1 %
Random Forest Learner (Regression)< 1 %- Column to Grid< 1 %
- Edit Nominal Domain (Dictionary)< 1 %
- Normalizer (Apply)< 1 %
- Rank< 1 %
- Reference Column Resorter< 1 %
Linear Discriminant Analysis< 1 %- Parallel Coordinates (legacy)< 1 %
- SDF Writer< 1 %
- Topic Extractor (Parallel LDA)< 1 %
Bag of Words Creator< 1 %- Molecular Properties< 1 %
- RDKit From IUPAC< 1 %
- Text Classifier Predictor< 1 %
- ARIMA Predictor< 1 %
- Split Collection Column< 1 %
File Meta Info< 1 %- ARFF Writer< 1 %
- Table Creator< 1 %
- Loop End (Column Append)< 1 %
Recursive Loop Start (2 ports)< 1 %- Hierarchical Cluster View< 1 %
Random Forest Learner< 1 %- Number to Category (Apply)< 1 %
- CAIM Binner< 1 %
- Column Filter (PMML)< 1 %
- SDF Extractor< 1 %
- Index Query< 1 %
- NGram Creator< 1 %
Document Data Extractor< 1 %Document vector< 1 %- JPMML Classifier< 1 %
- Value Selection (legacy)< 1 %
- Table View (JavaScript)< 1 %
- GET Request< 1 %
- Time Difference (legacy)< 1 %
- Moving Average< 1 %
- Preset Date/Time (legacy)< 1 %
- RDKit Canon SMILES< 1 %
- Text Classifier Learner< 1 %
- String Similarity< 1 %
- TIBCO Spotfire File Writer< 1 %
- R Snippet (2:1)< 1 %
- String to URI< 1 %
Variable to Table Row< 1 %Interval Loop Start< 1 %- PNN Learner (DDA)< 1 %
Gradient Boosted Trees Learner< 1 %- Binner (Dictionary)< 1 %
- Edit Nominal Domain< 1 %
- Numeric Binner (PMML)< 1 %
- String Distances< 1 %
- Matrix Distance< 1 %
PMML Predictor< 1 %Open TIBCO Spotfire< 1 %- Radar Plot Appender< 1 %
- Case Converter< 1 %
- Columns to JSON< 1 %
- Row to Network< 1 %
- Multi Feature Inserter< 1 %
Python Script (2⇒1)< 1 %Python View< 1 %Column Filter QuickForm (legacy)< 1 %- Date/Time Shift (legacy)< 1 %
- Twitter Followers Search (legacy)< 1 %
- Twitter Users (legacy)< 1 %
Location Extractor< 1 %- MapQuest Geocoder< 1 %
- Table Row To Variable Run-for-time Loop Start< 1 %
- Combine Columns by Header< 1 %
- Plate Heatmap Viewer< 1 %
- Set MolName And Comment< 1 %
- Pareto Ranking< 1 %
Database Looping< 1 %Backward Feature Elimination Start (1:1)< 1 %- Hierarchical Cluster Assigner (local)< 1 %
Tree Ensemble Predictor< 1 %- Table Validator (Reference)< 1 %
- Edit Numeric Domain< 1 %
- Equal Size Sampling< 1 %
- Reference Column Splitter< 1 %
- One to Many (PMML)< 1 %
- Independent groups t-test< 1 %
Color Appender< 1 %- PMML Compiling Predictor< 1 %
- Smiles Directory Writer< 1 %
- One Rule Inserter< 1 %
K Nearest Neighbor (Distance Function)< 1 %Table to PDF< 1 %- Association Rule Learner (Borgelt)< 1 %
- Bubble Chart (JFreeChart)< 1 %
- OSM Map View< 1 %
- Extract Time Window (legacy)< 1 %
- Column to XML< 1 %
XML Writer< 1 %- RDKit Descriptor Calculation< 1 %
- Read Variables< 1 %
- BinningAnalysis< 1 %
- Normalize Plates (POC)< 1 %
- Open in Matlab< 1 %
- Matlab Snippet< 1 %
ChemSpider (deprecated)< 1 %- ARIMA Learner< 1 %
- ARIMA Parameter Importer< 1 %
- Binary Objects to Strings< 1 %
- URL to File Path< 1 %
Database Reader< 1 %- SOTA Learner< 1 %
- SOTA Predictor< 1 %
Random Forest Predictor (Regression)< 1 %Gradient Boosted Trees Learner (Regression)< 1 %Tree Ensemble Learner< 1 %- Random Forest Learner (Regression)< 1 %
Column Filter< 1 %- Interactive HiLite Collector< 1 %
- Subset Matcher< 1 %
- Missing Value (Apply)< 1 %
- Renderer to Image< 1 %
- Ruleset Editor< 1 %
- Cronbach Alpha< 1 %
- Paired t-test< 1 %
- IF Switch< 1 %
CASE Switch Data (Start)< 1 %- HiLite Table (legacy)< 1 %
- Lift Chart (legacy)< 1 %
- Size Manager< 1 %
- One Row to Many< 1 %
- Time Series Generator< 1 %
Table to HTML< 1 %- LIBSVMLearner< 1 %
- Table Indexer< 1 %
- OSM Map to Image< 1 %
External SSH Tool< 1 %- Java Edit Variable (simple)< 1 %
- TF< 1 %
- Keygraph Keyword Extractor< 1 %
- Dictionary Replacer< 1 %
- RegEx Filter< 1 %
Stop Word Filter< 1 %OpenNLP NE tagger< 1 %Simple Table View (JavaScript)< 1 %- Hierarchy Extractor< 1 %
- Neighbor Filter< 1 %
- Matrix to Network< 1 %
Value Filter QuickForm (legacy)< 1 %- Table Difference Checker< 1 %
- Moving Aggregator< 1 %
- Time to String (legacy)< 1 %
- RDKit To Molecule< 1 %
- RDKit Salt Stripper< 1 %
- Information Gain Calculator< 1 %
- Coordinate to Latitude/Longitude< 1 %
HTTP Retriever< 1 %- Reaction Builder< 1 %
- Substructure Matcher< 1 %
- Chunk Loop Run-for-time Loop Start< 1 %
- SMARTSViewer< 1 %
- Normalize Plates (Z-Score)< 1 %
CV< 1 %- PubChem Search< 1 %
- Text Extractor< 1 %
- Fingerprint Similarity< 1 %
- XLS Coloured Writer< 1 %
Binary Objects to Files< 1 %- Copy/Move Files (legacy)< 1 %
- Extract URI Info< 1 %
- Strings to Binary Objects< 1 %
- Zip Files (legacy)< 1 %
- Catch Errors (Data Ports)< 1 %
CSV Reader< 1 %Parameterized Database Query< 1 %- Feature Selection Loop Start (1:1)< 1 %
Variable Condition Loop End< 1 %Recursive Loop End< 1 %Variable Loop End< 1 %- X-Aggregator< 1 %
Fuzzy c-Means< 1 %k-Means< 1 %- MDS< 1 %
PCA Inversion< 1 %Tree Ensemble Learner< 1 %Random Forest Learner< 1 %- Tree Ensemble Learner (Regression)< 1 %
- Bootstrap Sampling< 1 %
- Create Byte Vector< 1 %
Category To Number< 1 %- Many to One< 1 %
Double To Int< 1 %Missing Value< 1 %- Many to One (PMML)< 1 %
- Normalizer Apply (PMML)< 1 %
RowID< 1 %- Ruleset Predictor< 1 %
- Rule Engine Variable (Dictionary)< 1 %
Odds and Risk Ratios< 1 %- Wilcoxon-Mann-Whitney Test< 1 %
- End IF< 1 %
Merge Variables< 1 %- Timer Info< 1 %
- Molfile Writer< 1 %
- SDF Reader< 1 %
- Random Number Assigner< 1 %
- Random Label Assigner< 1 %
- Random Label Assigner (Data)< 1 %
- TimeDelay Loop Start< 1 %
- Bit Vector Distances< 1 %
- Table to PMML Ensemble< 1 %
- Universe Marker< 1 %
- Generic Web Service Client< 1 %
DL4J Feedforward Predictor (legacy)< 1 %- JPython Function (Legacy)< 1 %
- Geo-Coordinate Row Filter< 1 %
XLS Writer< 1 %R Snippet< 1 %- DF< 1 %
- Frequency Filter< 1 %
- Category to Class< 1 %
- Chi-Square Keyword Extractor< 1 %
- Dictionary Filter< 1 %
- Dictionary Replacer (File-based)< 1 %
- Number Filter< 1 %
- Tags to String< 1 %
- Document Viewer< 1 %
- Weka Cluster Assigner (3.7)< 1 %
- Value Filter (legacy)< 1 %
- Column Selection (legacy)< 1 %
- ROC Curve (JavaScript)< 1 %
- Scatter Plot (JavaScript)< 1 %
- String to JSON< 1 %
- Container Output (JSON)< 1 %
JSON Writer< 1 %- Node Neighbor Extractor< 1 %
- Rowset Filter< 1 %
Python Learner< 1 %Python Predictor< 1 %Column Selection QuickForm (legacy)< 1 %Value Selection QuickForm (legacy)< 1 %- POST Request< 1 %
- Fail in execution< 1 %
- Mask Date/Time (legacy)< 1 %
- XSLT< 1 %
- Discretise< 1 %
- Result< 1 %
- CDK to Molecule< 1 %
- Sum Formula< 1 %
- RDKit From InChI< 1 %
- RDKit Interactive Table< 1 %
- RDKit To InChI< 1 %
Map Viewer< 1 %Reverse Location Lookup< 1 %- URL Normalizer< 1 %
Web Searcher< 1 %- Form Encoded HTTP Entity Creator< 1 %
Views
- This node has no views
Workflows
_01_PMR_AnalysisKNIME Hub- ExplorationKNIME Hub
- ExplorationKNIME 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.