Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • Nodes
  • Read Excel Sheet Names
NodeNode / Source

Read Excel Sheet Names

IO Read Streamable
Drag & drop
Like
Copy short link

This node reads an Excel file and provides the contained sheet names at its output port.
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).

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
    Output table
    The sheet names contained in the workbook and the path to the workbook.
File System Connection (Dynamic Inport)
The file system connection.
  1. Type: File System

Extension

The Read Excel Sheet Names node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    Read all sheets from an excel file
    Excel Data wrangling
    This workflow reads all sheets from a Excel file by using a loop. The Loop End node colle…
    soumyabg > Public > Read all sheets from an excel file
  2. Go to item
    Excel Sheet Updater
    lukass > Forum > Excel Sheet Updater
  3. Go to item
    31485-looping-through-excel-sheets
    kowisoft > Public > 31485-looping-through-excel-sheets
  4. Go to item
    Append data to an existing Excel file with the help of Python Pandas and OpenPyxl
    Excel File Sheet
    +5
    Append data to an existing Excel file with the help of Python Pandas and OpenPyxl
    mlauber71 > Public > forum > kn_forum_29528_python_excel_append_to_existing_sheet
  5. Go to item
    Workflow Control
    Loop Reading many files Switch
    +4
    "Workflow Control" exercise for advanced Life Science User Training - Handle and write gr…
    knime > Education > Courses > L2-LS KNIME Analytics Platform for Data Scientists - Life Sciences - Advanced > Exercises > 02. Workflow Control
  6. Go to item
    Excel Reader - force sheet_selection "NAME" with Flow variable
    Excel Sheet Name
    +3
    Excel Reader - force sheet_selection "NAME" with Flow variable
    mlauber71 > Forum > 2021 > kn_forum_38226_excel_sheet_force_name_read
  7. Go to item
    Read and Concatenation from multiple Excels to table
    takbb > Public > Read and Concatenation from multiple Excels to table
  8. Go to item
    FocusDBTables
    mraraman > Public > IPF > FocusDBTables
  9. Go to item
    FocusDBTables
    alamisrar > Public > IPF > FocusDBTables
  10. Go to item
    Excel Worksheet Rename
    adamkingsbury > ExcelHelpers > Examples > Excel Worksheet Rename

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