Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • Nodes
  • Excel Reader (XLS) (deprecated)
NodeNode / Source

Excel Reader (XLS) (deprecated)

IO Read Streamable

This node has been deprecated and its use is not recommended. Please search for updated nodes instead.

Like
Copy short link

This node reads a spread sheet and provides it at its output port.
It reads only data from one sheet, but it is possible to read multiple files that contain the same sheet name at once.
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).

External resources

  • KNIME E-Learning Course: Excel Reader Node

Node details

Output ports
  1. Type: Table
    Output table
    The data table read in.
File System Connection (Dynamic Inport)
The file system connection.
  1. Type: File System

Extension

The Excel Reader (XLS) (deprecated) node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    Read an XLS file
    Reading XLS Excel
    +1
    There are multiple ways of reading an .xls file. 1. Add the XLS Reader to the workspace a…
    knime > Examples > 01_Data_Access > 01_Common_Type_Files > 03_Read_an_XLS_file
  2. Go to item
    03_Read_Data_from_Excel_File - Solution
    E-learning Excel Data access
    +1
    Solution to an e-learning course exercise. Read data from an Excel file.
    stervis > Public > E-Learning > L1-DS KNIME Analytics Platform for Data Scientists - Basics > Solutions > 03_Read_Data_from_Excel_File - Solution
  3. Go to item
    03_Read_Data_from_Excel_File - Solution
    E-learning Excel Data access
    +1
    Solution to an e-learning course exercise. Read data from an Excel file.
    stervis > Public > E-Learning > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Solutions > 03_Read_Data_from_Excel_File - Solution
  4. Go to item
    Import Excel file with special table structure
    Import Excel file with special table structure
    mlauber71 > Public > forum > kn_forum_12425_import_excel
  5. Go to item
    Relations in data with scatter and 3-D scatter
    Visualization Relation Relationship
    +10
    This exercise focuses on learning about the relations among the data of prices of the hou…
    barbora > Courses > L4-DV Codeless Data Exploration and Visualization_12.2020 > L4-DV Codeless Data Exploration and Visualization - Exercises > exercises > 04c. GenericJS View optional
  6. Go to item
    03_Read_Data_from_Excel_File - Solution
    E-learning Excel Data access
    +1
    Solution to an e-learning course exercise. Read data from an Excel file.
    a2620 > Public > L1-DS KNIME Analytics Platform for Data Scientists - Basics > Solutions > 03_Read_Data_from_Excel_File - Solution
  7. Go to item
    03_Read_Data_from_Excel_File - Solution
    E-learning Excel Data access
    +1
    Solution to an e-learning course exercise. Read data from an Excel file.
    mavalenciaor > Public > L1-DS KNIME Analytics Platform for Data Scientists - Basics > Solutions > 03_Read_Data_from_Excel_File - Solution
  8. Go to item
    Read an XLS file
    Reading XLS Excel
    +1
    There are multiple ways of reading an .xls file. 1. Add the XLS Reader to the workspace a…
    haoran > Public > 01_Data_Access > 01_Common_Type_Files > 03_Read_an_XLS_file
  9. Go to item
    KNIME_TEST
    amlou > Public > KNIME_TEST
  10. Go to item
    dataStage
    jaircarrion > Public > dataStage

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