Hub
Pricing About
NodeNode / Source

XLS Named Range Reader

Community NodesErlwood NodesIO
Drag & drop
Like

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 data (or strings) but, of course, no diagrams, pictures, or other items.
Currently supported KNIME types are String, Double, and Int. (Time or date in the spread sheet is represented as String and can be translated into the appropriate TimeAndDateCells with the corresponding nodes.)
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).

Node details

Output ports
  1. Type: Table
    Output table
    The data table read in.

Extension

The XLS Named Range Reader node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
  2. Go to item
  3. Go to item

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits