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 the contained sheet names at its output port.
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
- k-Means5 %
- Concatenate3 %
- Nominal Value Row Filter3 %
Table Column to Variable3 %- Color Manager2 %
- Interactive Table (legacy)2 %
- Decision Tree Learner2 %
Column Rename2 %- Extract Table Dimension2 %
- Rule Engine2 %
- Value Selection (legacy)2 %
- Missing Value1 %
- Reference Row Filter1 %
- Value Counter1 %
- Table Transposer1 %
Joiner< 1 %- Math Formula< 1 %
- Column Combiner< 1 %
- Normalizer< 1 %
- Strings to Document< 1 %
Table Row To Variable Loop Start< 1 %Concatenate (Optional in)< 1 %- Box Plot (legacy)< 1 %
- Java Snippet< 1 %
Counting Loop Start< 1 %String To Number< 1 %Linear Correlation< 1 %- Table Validator< 1 %
- Line Plot (legacy)< 1 %
- URL to File Path (Variable)< 1 %
Naive Bayes Learner< 1 %Number To String< 1 %- Extract Table Spec< 1 %
- Table Row To Variable Run-for-time Loop Start< 1 %
- Table Validator (Reference)< 1 %
- Rule-based Row Filter< 1 %
- Interactive Pie chart (legacy)< 1 %
XLS Reader< 1 %Excel Reader (XLS)< 1 %- String to Date&Time< 1 %
- URI to Port< 1 %
- Linear Regression Learner< 1 %
- Association Rule Learner< 1 %
- RowID< 1 %
- Cache< 1 %
- Line Plot (JavaScript)< 1 %
- Inject Variables (Data)< 1 %
- ARFF Writer< 1 %
Database Writer< 1 %- Missing Value Column Filter< 1 %
Merge Variables< 1 %- XSLT< 1 %
- XLS Control Table Generator< 1 %
Loop End< 1 %Cell Replacer< 1 %Cell Splitter< 1 %- Number to String< 1 %
- Column Name Extractor< 1 %
Row Filter (deprecated)< 1 %- Normalizer (PMML)< 1 %
- Rule-based Row Splitter< 1 %
- IF Switch< 1 %
- Scatter Plot (legacy)< 1 %
- Math Formula (Multi Column)< 1 %
- Java Snippet (simple)< 1 %
- Google Address Geocoder< 1 %
- R Snippet< 1 %
Table Row to Variable< 1 %CSV Writer< 1 %File Reader< 1 %- Table Creator< 1 %
- Group Loop Start< 1 %
Recursive Loop Start< 1 %- Decision Tree Predictor< 1 %
- MultiLayerPerceptron Predictor< 1 %
- Auto-Binner< 1 %
- Column Renamer (Dictionary)< 1 %
- Column Filter< 1 %
Row Splitter (deprecated)< 1 %- Pivot< 1 %
- Row Sampling< 1 %
- Column Splitter< 1 %
- String Manipulation< 1 %
- Statistics< 1 %
- Conditional Box Plot (legacy)< 1 %
- Histogram (legacy)< 1 %
- Interactive Histogram (legacy)< 1 %
- Scatter Matrix (legacy)< 1 %
- DB Writer< 1 %
Excel Writer (XLS)< 1 %Excel Sheet Appender (XLS)< 1 %Bag of Words Creator< 1 %- Value Selection Configuration< 1 %
- Value Selection Widget< 1 %
Python Script (1⇒1)< 1 %- File Meta Info (legacy)< 1 %
- Zip Files (legacy)< 1 %
- PNN Learner (DDA)< 1 %
- Hierarchical Clustering< 1 %
- Regression Predictor< 1 %
- Bootstrap Sampling< 1 %
- Category to Number< 1 %
- Column Resorter< 1 %
- One to Many< 1 %
- Constant Value Column< 1 %
- Rank< 1 %
- Ungroup< 1 %
- Numeric Outliers< 1 %
Excel Reader (XLS)< 1 %Excel Writer (XLS)< 1 %- Lift Chart (JavaScript)< 1 %
- Table Row To Variable Run-to-time Loop Start< 1 %
- String to URI< 1 %
Variable to Table Row< 1 %Loop End (2 ports)< 1 %Variable Condition Loop End< 1 %- Naive Bayes Learner< 1 %
Naive Bayes Predictor< 1 %PCA< 1 %- Logistic Regression Learner< 1 %
Random Forest Learner< 1 %- Binner (Dictionary)< 1 %
- Create Bit Vector< 1 %
- Cell Splitter By Position< 1 %
Rank Correlation< 1 %- Data Explorer< 1 %
- Crosstab< 1 %
- Parallel Coordinates (legacy)< 1 %
- Shape Manager< 1 %
- DB Insert< 1 %
- String Distances< 1 %
Table to PDF< 1 %- Radar Plot Appender< 1 %
- Punctuation Erasure< 1 %
- Stop Word Filter< 1 %
Strings To Document< 1 %- Container Input (Table)< 1 %
- R Snippet< 1 %
- Table to R< 1 %
- GET Request< 1 %
- XLS Conditional Formatter< 1 %
- Delete Files (legacy)< 1 %
- URL to File Path< 1 %
- Wait...< 1 %
- Catch Errors (Data Ports)< 1 %
Variable to Table Column< 1 %- Create File Name (legacy)< 1 %
- Read Images< 1 %
Extract Context Properties< 1 %Table Writer< 1 %Recursive Loop Start (2 ports)< 1 %Variable Loop End< 1 %- Fuzzy c-Means< 1 %
K Nearest Neighbor< 1 %- RProp MLP Learner< 1 %
- Polynomial Regression Learner< 1 %
Scorer< 1 %- SVM Learner< 1 %
- Linear Correlation< 1 %
- Edit Nominal Domain< 1 %
- Filter Apply< 1 %
- Row Filter (Labs)< 1 %
- GroupBy< 1 %
Missing Value< 1 %Normalizer< 1 %- Partitioning< 1 %
- Sorter< 1 %
- Unpivot< 1 %
- Single sample t-test< 1 %
- Paired t-test< 1 %
- Pie chart (legacy)< 1 %
- DB Merge< 1 %
- Similarity Search< 1 %
- Weka Cluster Assigner (3.7)< 1 %
- Table Editor (JavaScript)< 1 %
- Data to Report (BIRT)< 1 %
- Date&Time Difference< 1 %
- String to Date/Time (legacy)< 1 %
- Molecule to CDK< 1 %
- RDKit From Molecule< 1 %
- XLS Border Formatter< 1 %
- XLS Background Colorizer< 1 %
- XLS Sheet Properties< 1 %
- XLS Sheet Selector< 1 %
IF Switch (Flow Variable Value)< 1 %Flow Variable End IF< 1 %Flow Variable IF Switch (Flow Variable Value)< 1 %- Chunk Loop Run-for-time Loop Start< 1 %
- Write Variables< 1 %
- Create Collection Column< 1 %
- Split Collection Column< 1 %
- Copy/Move Files (legacy)< 1 %
- Create Directory (legacy)< 1 %
- Extract URI Info< 1 %
- Upload (legacy)< 1 %
- Breakpoint< 1 %
Variable to Table Column< 1 %- Extract Variables (Data)< 1 %
Table Column to Variable< 1 %Table Column to Variable< 1 %Table Row to Variable< 1 %- Table to Image< 1 %
CSV Reader< 1 %Database Delete< 1 %- Loop End (Column Append)< 1 %
Interval Loop Start< 1 %- Chunk Loop Start< 1 %
- Column List Loop Start< 1 %
Generic Loop Start< 1 %- X-Partitioner< 1 %
- Cluster Assigner< 1 %
- Hierarchical Clustering (DistMatrix)< 1 %
- Decision Tree to Image< 1 %
PCA Apply< 1 %Logistic Regression Learner< 1 %- Logistic Regression Predictor< 1 %
Regression Predictor< 1 %- Entropy Scorer< 1 %
- Numeric Scorer< 1 %
- SMOTE< 1 %
- SVM Predictor< 1 %
- Gradient Boosted Trees Learner< 1 %
- Gradient Boosted Trees Predictor< 1 %
- Random Forest Learner< 1 %
- Simple Regression Tree Learner< 1 %
- Simple Regression Tree Predictor< 1 %
- Auto-Binner (Apply)< 1 %
- Numeric Binner< 1 %
- Cell Splitter< 1 %
- Column Auto Type Cast< 1 %
- Column Comparator< 1 %
- Category to Number (Apply)< 1 %
- String to Number< 1 %
- Column Aggregator< 1 %
Column Appender< 1 %- Column Appender< 1 %
- Column to Grid< 1 %
- Correlation Filter< 1 %
- Cross Joiner< 1 %
- Domain Calculator< 1 %
- Double to Integer< 1 %
- Duplicate Row Filter< 1 %
- Reference Column Filter< 1 %
- Filter Apply Row Splitter< 1 %
- Nominal Value Row Splitter< 1 %
- Reference Row Splitter< 1 %
- Column Filter (PMML)< 1 %
- Number to String (PMML)< 1 %
- Reference Column Resorter< 1 %
- String Splitter (Regex)< 1 %
- Set Operator< 1 %
- String Manipulation (Variable)< 1 %
- String Replacer< 1 %
String Replace (Dictionary)< 1 %- Rule Engine Variable (Dictionary)< 1 %
- Rank Correlation< 1 %
- Linear Discriminant Analysis< 1 %
- Timer Info< 1 %
- HiLite Table (legacy)< 1 %
- Lift Chart (legacy)< 1 %
- ROC Curve (legacy)< 1 %
- Table to Spark< 1 %
- Molecule Type Cast< 1 %
- SDF Writer< 1 %
DB Loader< 1 %- Counter Generation< 1 %
- TimeDelay Loop End< 1 %
- Bar Chart (JavaScript)< 1 %
- Conditional Box Plot (JavaScript)< 1 %
PMML Predictor< 1 %- Column Expressions (legacy)< 1 %
Table to HTML< 1 %- OpenBabel< 1 %
- Generic Web Service Client< 1 %
- DL4J Feedforward Learner (Classification) (legacy)< 1 %
- DL4J Feedforward Predictor (Classification) (legacy)< 1 %
- DL4J Feedforward Predictor (Regression) (legacy)< 1 %
- External Tool< 1 %
- Table to H2O< 1 %
- Association Rule Learner (Borgelt)< 1 %
- Bar Chart (JFreeChart)< 1 %
- Line Chart (JFreeChart)< 1 %
- OSM Map View< 1 %
Excel Reader (XLS)< 1 %Read Excel Sheet Names (XLS)< 1 %Excel Sheet Appender (XLS)< 1 %- Java Edit Variable (simple)< 1 %
- Java IF (Table)< 1 %
Tableau Writer (Hyper)< 1 %- Topic Extractor (Parallel LDA)< 1 %
- String Matcher< 1 %
- Diacritic Remover< 1 %
- Dictionary Filter< 1 %
- Dictionary Replacer< 1 %
- Dictionary Tagger< 1 %
- StanfordNLP NE Tagger< 1 %
- Bag Of Words Creator< 1 %
- Document Data Extractor< 1 %
- Sentence Extractor< 1 %
- Tag Cloud< 1 %
- Weka Predictor (3.7)< 1 %
- Nominal Row Filter Configuration< 1 %
- Value Filter (legacy)< 1 %
- List Box Input (legacy)< 1 %
- Column Selection (legacy)< 1 %
- Decision Tree View (JavaScript)< 1 %
- Table View (JavaScript)< 1 %
- Scatter Plot (JavaScript)< 1 %
- Tag Cloud (JavaScript)< 1 %
- Tile View (JavaScript)< 1 %
- Column Filter Widget< 1 %
- Table to JSON< 1 %
- JSON Schema Validator< 1 %
Python Script (1⇒2)< 1 %Python Script (2⇒1)< 1 %Python Script (2⇒2)< 1 %- R View (Table)< 1 %
- POST Request< 1 %
Extract Date&Time Fields< 1 %- Modify Date< 1 %
- Extract Time Window (legacy)< 1 %
- Twitter Followers Search (legacy)< 1 %
- Twitter Users (legacy)< 1 %
- XML Column Combiner< 1 %
- Column to XML< 1 %
XML Writer< 1 %- XPath< 1 %
- Table to HTML String< 1 %
- RDKit From IUPAC< 1 %
- RDKit Fingerprint< 1 %
- RDKit To Molecule< 1 %
- MapQuest Geocoder< 1 %
- Coordinate to Latitude/Longitude< 1 %
- HTTP Retriever< 1 %
Views
- This node has no views
Workflows
008_Loops - 1KNIME Hub- 02_Accounting ManagementKNIME Hub
- 05_Read_all_sheets_from_an_XLS_file_in_a_loopKNIME Hub
- 05_Read_all_sheets_from_an_XLS_file_in_a_loopKNIME Hub
- 05_Read_all_sheets_from_an_XLS_file_in_a_loopKNIME Forum
- Show all 38 workflows
Links
- Read Excel Sheet Namesby armingrudd on 2020-08-04forum.knime.com/p/98883
- Add excel sheet names to column namesby izaychik63 on 2019-04-19forum.knime.com/p/59089
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.