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

Excel Reader (XLS) (deprecated)

streamable deprecated

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

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:

Related workflows & nodes

  1. 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 and open the configuration dial…
    knime > Examples > 01_Data_Access > 01_Common_Type_Files > 03_Read_an_XLS_file
  2. 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 and open the configuration dial…
    lcs > Public > 01_Data_Access > 01_Common_Type_Files > 03_Read_an_XLS_file
  3. 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.
    maarit > Public > E-Learning > L1-DS KNIME Analytics Platform for Data Scientists - Basics > Solutions > 03_Read_Data_from_Excel_File - Solution
  4. 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.
    maarit > Public > E-Learning > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Solutions > 03_Read_Data_from_Excel_File - Solution
  5. 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
  6. 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
  7. Import Excel file with special table structure
    Import Excel file with special table structure
    mlauber71 > Public > forum > kn_forum_12425_import_excel
  8. 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 houses in Boston. Steps: Read exc…
    barbora > Courses > L4-DV Codeless Data Exploration and Visualization_12.2020 > L4-DV Codeless Data Exploration and Visualization - Exercises > exercises > 04c. GenericJS View optional
  9. 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
  10. KNIME_TEST
    amlou > Public > KNIME_TEST

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