Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
Sign in
  • KNIME Hub
  • Nodes
  • Excel Reader
NodeNode / Source

Excel Reader

streamable

This node reads Excel files (xlsx, xlsm, 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. Formulas can also be read in and reevaluated if desired.
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.
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.

Node details

Output ports
  1. File Table Type: Data
    File being read with number and types of columns guessed automatically.
Dynamic input ports
  1. File System Connection Type: File System
    The file system connection.

Related workflows & nodes

  1. Reading and transforming multiple Excel files from a ZIP archive
    decompress Excel ETL +1
    This workflow demonstrates how to read and transform multiple files with similar file structure.
    knime > Examples > 01_Data_Access > 01_Common_Type_Files > 13_Reading and transforming multiple Excel files from a ZIP archive
  2. 04 Numbers Strings and Rules
    data manipulation transformation rule engine +3
    Exercise for data transformation. Perform data manipulation operations with the Rule Engine, Math Formula, String Manip…
    maarit > Self-Paced Courses > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Exercises > 04 Numbers Strings and Rules
  3. 05 Date and Time Manipulation
    date time
    Exercise for date and time manipulation. Perform data manipulation operations that are specific to date and time values
    maarit > Self-Paced Courses > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Exercises > 05 Date and Time Manipulation
  4. Replace Excel Column Names
    There has been no description set for this workflow's metadata.
    simons > Public > Forum > Excel > Replace_Excel_Column_Names
  5. 01 Read Data from File - Solution
    csv data access education +2
    Solution workflow to an exercise for reading data from a file. CHECK YOUR ANSWERS: a. The reader nodes used in this exe…
    maarit > Self-Paced Courses > L1-DS KNIME Analytics Platform for Data Scientists - Basics > Solutions > 01 Read Data from File - Solution
  6. 05 Date and Time Manipulation - Solution
    date time
    Solution to an exercise for date and time manipulation. Perform data manipulation operations that are specific to date …
    maarit > Self-Paced Courses > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Solutions > 05 Date and Time Manipulation - Solution
  7. 05 Join and Concatenate
    join concatenate
    Exercise for joining and concatenating data. Combine data tables side-by-side using the join operation. Put tables on t…
    maarit > Self-Paced Courses > L1-DS KNIME Analytics Platform for Data Scientists - Basics > Exercises > 07 Join and Concatenate
  8. 06 Aggregations
    aggregate groupby pivot
    Exercise for data aggregation. Calculate statistics for subgroups of data with the GroupBy and Pivoting nodes.
    maarit > Self-Paced Courses > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Exercises > 06 Aggregations
  9. 01 Read Data from File - Solution
    csv data access excel +1
    Solution to an exercise for reading data from a file CHECK YOUR ANSWERS: a. The reader nodes to use are Excel Reader, C…
    maarit > Self-Paced Courses > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Solutions > 01 Read Data from File - Solution
  10. Transform data with One-To-Many and Math Formula
    Transform data with One-To-Many and Math Formula
    mlauber71 > Public > forum > kn_forum_29997_one_to_many

No known nodes available

Extension

This node is part of the extension

KNIME Excel SupportTrusted extension
Version 4.3.0
Short link

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Server
© 2021 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits