Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • Nodes
  • XLS Named Range Reader
NodeNode / Source

XLS Named Range Reader

Community Nodes Erlwood Nodes IO
Drag & drop
Like
Copy short link

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
  1. Go to item
  2. Go to item

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 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 Business Hub
© 2023 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits