This node reads an Excel file 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 can take a long time.
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
Popular Successors
- Table Row to Variable Loop Start24 %
Row Filter (deprecated)8 %- Rule-based Row Filter4 %
- Loop End4 %
- Column Filter1 %
- Joiner1 %
- Missing Value1 %
Row Splitter (deprecated)1 %- Nominal Value Row Filter1 %
- String Manipulation1 %
Constant Value Column< 1 %- Reference Row Filter< 1 %
- Table Row to Variable< 1 %
- Excel Writer< 1 %
- String to Number< 1 %
- Excel Reader< 1 %
Table Row To Variable Loop Start< 1 %- Variable to Table Row< 1 %
- Cross Joiner< 1 %
XLS Sheet Appender< 1 %- Stop Word Filter< 1 %
- Extract Variables (Data)< 1 %
Table Writer< 1 %- Concatenate< 1 %
- Category to Number< 1 %
- GroupBy< 1 %
- Normalizer< 1 %
Column Splitter< 1 %- Table Transposer< 1 %
- End IF< 1 %
- Data to Report (BIRT)< 1 %
- XLS Sheet Properties< 1 %
- XLS Sheet Selector< 1 %
- Table Row To Variable Run-for-time Loop Start< 1 %
- Table To Excel Cell Updater< 1 %
- URL to File Path< 1 %
- Try (Data Ports)< 1 %
- Variable to Table Column< 1 %
- Table Column to Variable< 1 %
- Read Images< 1 %
- CSV Writer< 1 %
- Table Writer< 1 %
- Java Snippet< 1 %
Loop End< 1 %- Chunk Loop Start< 1 %
- Column List Loop Start< 1 %
- Generic Loop Start< 1 %
- Group Loop Start< 1 %
- Recursive Loop Start< 1 %
- Variable Loop End< 1 %
Table Row To Variable Loop Start< 1 %- K Nearest Neighbor< 1 %
- Constant Value Row Appender< 1 %
- Cell Splitter< 1 %
- Column Appender< 1 %
- Column Name Extractor< 1 %
- Column Merger< 1 %
- One to Many< 1 %
- Duplicate Row Filter< 1 %
- Reference Column Filter< 1 %
- Nominal Value Row Splitter< 1 %
- Row Filter (Labs)< 1 %
Joiner< 1 %- Table Manipulator< 1 %
- Table Partitioner< 1 %
- Pivot< 1 %
Column Rename< 1 %- RowID< 1 %
- Sorter< 1 %
- String Manipulation (Variable)< 1 %
- Table Difference Finder< 1 %
- Rule Engine< 1 %
- Rule-based Row Splitter< 1 %
- Statistics< 1 %
- IF Switch< 1 %
- Extract Table Dimension< 1 %
- Table View< 1 %
- Counter Generation< 1 %
- Column Expressions (legacy)< 1 %
- Math Formula< 1 %
Excel Sheet Appender (XLS)< 1 %- Read Excel Sheet Names< 1 %
- Excel Cell Updater< 1 %
- Path to String< 1 %
- Path to URI< 1 %
- String to Path< 1 %
- Transfer Files (Table)< 1 %
- Google Sheets Updater< 1 %
- Value Selection Configuration< 1 %
- Table View (JavaScript) (legacy)< 1 %
- Value Selection Widget< 1 %
- Python Script (legacy)< 1 %
- Window Loop Start< 1 %
Generic Loop Start< 1 %- Pie chart (legacy)< 1 %
- Color Manager< 1 %
- Parallel Chunk Start< 1 %
Excel Sheet Appender (XLS)< 1 %- Files/Folders Meta Info< 1 %
- Tag Cloud (JavaScript) (legacy)< 1 %
- R Source (Table)< 1 %
- XLS Control Table Generator< 1 %
- Extract Context Properties< 1 %
- Table Creator< 1 %
Counting Loop Start< 1 %Cell Replacer< 1 %- Filter Apply< 1 %
- String Manipulation (Multi Column)< 1 %
- Single sample t-test< 1 %
- Extract Table Spec< 1 %
Color Appender< 1 %- Interactive Table (legacy)< 1 %
- DB Query Reader< 1 %
Excel Reader (XLS)< 1 %- Path to String (Variable)< 1 %
- Column Selection Configuration< 1 %
- Run Garbage Collector< 1 %
Table Reader< 1 %- Column Auto Type Cast< 1 %
- Domain Calculator< 1 %
- Ungroup< 1 %
DB Writer< 1 %DB Table Creator< 1 %- Set Files/Folders Permissions< 1 %
- Column Selection (legacy)< 1 %
XLS Formatter (apply)< 1 %- XLS Coloured Writer< 1 %
Copy/Move Files< 1 %File Meta Info< 1 %- Catch Errors (Data Ports)< 1 %
Variable to Table Column< 1 %Create File Name< 1 %- Inject Variables (Data)< 1 %
Table Row to Variable< 1 %Parameterized Database Query< 1 %File Reader< 1 %- Java Edit Variable< 1 %
Loop End (2 ports)< 1 %- Loop End (Column Append)< 1 %
- Interval Loop Start< 1 %
Recursive Loop Start< 1 %- Naive Bayes Predictor< 1 %
- Fuzzy Rule Predictor< 1 %
k-Means (deprecated)< 1 %- Linear Regression Learner< 1 %
- Regression Predictor< 1 %
- Association Rule Learner< 1 %
- Number to String< 1 %
- Column Resorter< 1 %
- Linear Correlation< 1 %
- Constant Value Column Filter< 1 %
- HiLite Row Splitter< 1 %
- Missing Value Column Filter< 1 %
- Reference Row Splitter< 1 %
- Rank< 1 %
- String Replacer< 1 %
- Unpivot< 1 %
- Value Counter< 1 %
- Data Explorer< 1 %
- Linear Discriminant Analysis Compute< 1 %
- Empty Table Switch< 1 %
- Enrichment Plotter (legacy)< 1 %
- TimeDelay Loop Start< 1 %
- Model Loop Start< 1 %
- Java Edit Variable (simple)< 1 %
- Strings to Document< 1 %
- String to Path (Variable)< 1 %
- Transfer Files< 1 %
- Nominal Row Filter Configuration< 1 %
- Line Plot (JavaScript) (legacy)< 1 %
- Scatter Plot (JavaScript) (legacy)< 1 %
JSON Writer< 1 %Python Script (1⇒1)< 1 %- R Snippet< 1 %
- String to XML< 1 %
Views
- This node has no views
Workflows
008_Loops - 1KNIME Hub- 01. Descriptive StatisticsKNIME Hub
- 01. Descriptive StatisticsKNIME Hub
- 02 Workflow Control - SolutionKNIME Hub
- 02 Workflow Control - SolutionKNIME Hub
- Show all 265 workflows
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.