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

Excel Reader

IO Read Streamable
Drag & drop
Like
Copy short link

This node reads Excel files (xlsx, xlsm, xlsb, 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.

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.

Node details

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

Extension

The Excel Reader node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    KNIME_project
    ajay1915 > Public > KNIME_project
  2. Go to item
    Generic Java Script
    Plot Scatter plot Bivariate analysis
    +14
    Use the Generic JavaScript View to code your own chart by either own coding or template u…
    barbora > Courses > L4-DV Codeless Data Exploration and Visualization_06.2021 > L4-DV Codeless Data Exploration and Visualization - Demos > Demos empty > Session_04b_GenericJavaScriptView_empty
  3. Go to item
    Table views and Tile views
    Visualization Table view Table
    +4
    This workflow contains data visualization techniques with tables visualization tools
    barbora > Courses > L4-DV Codeless Data Exploration and Visualization_06.2021 > L4-DV Codeless Data Exploration and Visualization - Demos > Demos empty > Session_01a_table_demo_2_tableview_empty
  4. Go to item
    Dashboard via Component on WebPortal
    Visualization Visualize JavaScript
    +9
    This workflow shows how to create metanode for wrapping data preparation nodes and how to…
    barbora > Courses > L4-DV Codeless Data Exploration and Visualization_06.2021 > L4-DV Codeless Data Exploration and Visualization - Demos > Demos empty > Session_03c - 04a_demo_dashboard_empty
  5. Go to item
    Statistics, data distribution and data normalization
    Univariate Visualization Visualize
    +17
    This workflow illustrates how to learn statistical indicators about our data, its distrib…
    barbora > Courses > L4-DV Codeless Data Exploration and Visualization_06.2021 > L4-DV Codeless Data Exploration and Visualization - Demos > Demos empty > Session_02b_charts_demo_distribution_empty
  6. Go to item
    Assignment_1
    carljohanson > Public > Komm-IT > Assignment_1
  7. Go to item
    Assignment_1
    amaliedamm > Public > Komm-IT > Assignment_1
  8. Go to item
    Assignment_1
    maxroager > Public > Public > Komm-IT > Assignment_1
  9. Go to item
    04 Numbers Strings and Rules
    Data manipulation Transformation Rule engine
    +3
    Exercise for data transformation. Perform data manipulation operations with the Rule Engi…
    knime > Education > Self-Paced Courses > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Exercises > 04 Numbers Strings and Rules
  10. Go to item
    05 Date and Time Manipulation
    Date Time
    Exercise for date and time manipulation. Perform data manipulation operations that are sp…
    knime > Education > Self-Paced Courses > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Exercises > 05 Date and Time Manipulation

No known nodes available

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
© 2022 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits