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, date, boolean and string data but, of course, no diagrams, pictures, or other items.
Currently supported KNIME types are String, TimeAndDate, Double, Boolean, and Int.
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 when formula reevaluation is selected).
Options
Popular Predecessors
- Amazon S3 File Picker (legacy)5 %
Table Writer4 %List Files4 %- Table Row to Variable3 %
CSV Reader3 %Database SQL Executor3 %- Python Edit Variable (legacy)3 %
- Chunk Loop Start2 %
- Create Temp Dir (legacy)2 %
- Table Row to Variable Loop Start2 %
Excel Writer (XLS)2 %- Java Edit Variable (simple)2 %
- Column List Loop Start2 %
- Table Creator2 %
- Table Row To Variable Run-to-time Loop Start2 %
- Create Directory (legacy)1 %
- Java Snippet1 %
- Single Selection (legacy)1 %
- Value Selection (legacy)1 %
- Column Filter1 %
- Parameter Optimization Loop Start1 %
Row Filter (deprecated)< 1 %Excel Sheet Appender (XLS)< 1 %Excel Sheet Appender (XLS)< 1 %- DB Query Reader< 1 %
- Wait...< 1 %
Table Row to Variable< 1 %- Variable Expressions< 1 %
- URI Port to Variable< 1 %
Table Row to Variable< 1 %Variable to Table Row< 1 %- Concatenate< 1 %
String To Number< 1 %- String Manipulation (Variable)< 1 %
- IF Switch< 1 %
Database Table Selector< 1 %- DB Writer< 1 %
- Table Column to Variable< 1 %
- Catch Errors (Var Ports)< 1 %
- Inject Variables (Data)< 1 %
Table Column to Variable< 1 %Variable Loop End< 1 %- Column Resorter< 1 %
- Scatter Plot (legacy)< 1 %
- Boolean Input (legacy)< 1 %
- Merge Variables< 1 %
- Excel Reader< 1 %
- Excel Writer< 1 %
Flow Variable End IF< 1 %Table Row To Variable Loop Start< 1 %Number To String< 1 %- GroupBy< 1 %
- JSON Path< 1 %
Table Reader< 1 %- Rule Engine< 1 %
- External Tool< 1 %
- File Upload Widget< 1 %
- String to Path (Variable)< 1 %
- Path to String (Variable)< 1 %
- URL to File Path< 1 %
Concatenate (Optional in)< 1 %Read Excel Sheet Names (XLS)< 1 %- Date&Time Input (legacy)< 1 %
- Column Selection (legacy)< 1 %
- File Meta Info (legacy)< 1 %
Cell Replacer< 1 %- Boolean Configuration< 1 %
XLS Formatter (apply)< 1 %Flow Variable IF Switch (Flow Variable Value)< 1 %- Unzip Files (legacy)< 1 %
- Try (Variable Ports)< 1 %
Database Reader< 1 %Recursive Loop Start< 1 %- Column Combiner< 1 %
- Rule Engine Variable< 1 %
- List Folders< 1 %
CASE Switch Data (Start)< 1 %- Azure Blob Store File Picker (legacy)< 1 %
Excel Reader (XLS)< 1 %- Date&Time Widget< 1 %
IF Switch (Flow Variable Value)< 1 %Flow Variable IF Switch< 1 %Flow Variable IF Switch (Flow Variable Value)< 1 %- URL to File Path (Variable)< 1 %
- Catch Errors (Data Ports)< 1 %
- Extract Variables (Data)< 1 %
CSV Writer< 1 %Database Connection Table Reader< 1 %- Java Edit Variable< 1 %
Column Rename< 1 %- String Manipulation< 1 %
- Table Transposer< 1 %
- Send Email< 1 %
Excel Reader (XLS)< 1 %- Container Input (JSON)< 1 %
- Python Source (legacy)< 1 %
- Run Heavy Garbage Collector< 1 %
Binary Objects to Files< 1 %- Extract URI Info< 1 %
Table Column to Variable< 1 %SQL Extract< 1 %Interval Loop Start< 1 %- Column Name Extractor< 1 %
- Cross Joiner< 1 %
- Nominal Value Row Splitter< 1 %
- Amazon S3 Connector< 1 %
- Parallel Chunk Start< 1 %
- DB Table Selector< 1 %
- Model Loop Start< 1 %
- Math Formula (Variable)< 1 %
- Date&Time Configuration< 1 %
- Value Selection Configuration< 1 %
- GET Request< 1 %
Table Column to Variable< 1 %Table Row To Variable Loop Start< 1 %- Table Row To Variable Run-for-time Loop Start< 1 %
- Read Variables< 1 %
- Catch Errors (Generic Ports)< 1 %
- Create File Name (legacy)< 1 %
Database Writer< 1 %Database Connector< 1 %Database Drop Table< 1 %Extract Context Properties< 1 %File Reader< 1 %Loop End< 1 %Generic Loop Start< 1 %- Group Loop Start< 1 %
- k-Means< 1 %
Column Appender< 1 %Row Splitter (deprecated)< 1 %- Reference Row Filter< 1 %
Joiner< 1 %- Ungroup< 1 %
- Rule-based Row Filter< 1 %
CASE Switch Variable (Start)< 1 %- End IF< 1 %
Merge Variables< 1 %- Explorer Browser< 1 %
- Math Formula< 1 %
- Google Sheets Updater< 1 %
- Credentials Input (legacy)< 1 %
- Double Input (legacy)< 1 %
- File Chooser (legacy)< 1 %
- File Upload (legacy)< 1 %
- Integer Input (legacy)< 1 %
- String Input (legacy)< 1 %
- String to Date&Time< 1 %
- Generic Run-for-time Loop Start< 1 %
- Copy/Move Files (legacy)< 1 %
- Download (legacy)< 1 %
- String to URI< 1 %
- Breakpoint< 1 %
- Try (Data Ports)< 1 %
- Active Branch Inverter< 1 %
Variable to Table Column< 1 %- Extract Variables (Database)< 1 %
Database Query< 1 %Database Sorter< 1 %Database Sampling< 1 %- Loop End (Column Append)< 1 %
Counting Loop Start< 1 %Variable Condition Loop End< 1 %- Decision Tree Learner< 1 %
- Expand Bit Vector< 1 %
- Column Auto Type Cast< 1 %
- Number to String< 1 %
- String to Number< 1 %
- Table Validator (Reference)< 1 %
- Filter Apply Row Splitter< 1 %
- Partitioning< 1 %
- Column Filter (PMML)< 1 %
- Missing Value< 1 %
- Numeric Row Splitter< 1 %
- Sorter< 1 %
- Unpivot< 1 %
- Rule Engine Variable (Dictionary)< 1 %
CASE Switch Variable (End)< 1 %- Empty Table Switch< 1 %
- Data Generator< 1 %
- Pie chart (legacy)< 1 %
- DB Update< 1 %
- DB SQL Executor< 1 %
- TimeDelay Loop End< 1 %
- Column Expressions< 1 %
Excel Writer (XLS)< 1 %- Google Cloud Storage File Picker (legacy)< 1 %
- Credentials Configuration< 1 %
- Local File Browser Configuration< 1 %
- String Configuration< 1 %
- Single Selection Configuration< 1 %
- Text Output (legacy)< 1 %
- List Box Input (legacy)< 1 %
- String Widget< 1 %
- Single Selection Widget< 1 %
- Container Input (Table)< 1 %
Container Input (Variable)< 1 %- Parameter Optimization Loop End< 1 %
Python Edit Variable< 1 %Python Script (1⇒1)< 1 %Boolean Input (legacy)< 1 %File Upload (legacy)< 1 %- R Source (Table)< 1 %
- Create Date&Time Range< 1 %
- Reset on Load< 1 %
- Capture Workflow Start< 1 %
- DB Connector< 1 %
- Refresh Button Widget< 1 %
Views
- This node has no views
Workflows
00_KNIME_Workshop_basicsKNIME Hub- 01_B2B_Customer_AnalyticsKNIME Hub
- 01_Data_AccessKNIME Hub
- 01_Data_PreparationKNIME Hub
- 01_ExerciseKNIME Hub
- Show all 334 workflows
Links
- KNIME E-Learning Course: Excel Reader Nodewww.knime.com/knime-introductory-course/chapter2/section1/excel-reader-node
- Select a specific Excel Sheetby armingrudd on 2019-01-23forum.knime.com/p/53322
- Can’t find source code for ExcelReader – XLSReaderNode**by KFDing on 2019-08-09forum.knime.com/p/67542
- Loading multiple xlsx filesby armingrudd on 2019-08-26forum.knime.com/p/68647
- Move file based on an excel fileby knimediger on 2020-10-18forum.knime.com/p/105873
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.