Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community 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.

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
    soumyabg
  2. Go to item
    Workflow Control - Solution
    Loop Reading many files Switch
    +3
    Solution to exercise 11 for the KNIME Analytics Platform for Data Wranglers course - Writ…
    ADILT22 > Course Material - Codefree Introduction to Data Science > VL10 - Ensemble > Workflows > loop demo
    ADILT22
  3. Go to item
    Loop_Beispiel3
    diljin_123 > Public > Hausaufgabe > Loop_Beispiel3
    diljin_123
  4. Go to item
    Excel Sheet Updater
    lukass > Forum > Excel Sheet Updater
    lukass
  5. Go to item
    import multiple Excel files - forum question 27716
    import multiple Excel files - forum question 27716
    mlauber71 > Forum > 2022 > kn_forum_27716_excel_import_multiple_files > m_001_forum_27716_excel_import_multiple_files
    mlauber71
  6. Go to item
    31485-looping-through-excel-sheets
    kowisoft > Public > 31485-looping-through-excel-sheets
    kowisoft
  7. Go to item
    Bulk load Excel sheets and files - forum question (43934)
    Excel Import Bulk
    Bulk load Excel sheets and files - forum question (43934)
    mlauber71 > Forum > 2022 > kn_forum_43934_excel_bulk_import
    mlauber71
  8. Go to item
    use Python package openpyxl to remove an existing worksheet from an Excel file
    Excel Load Write
    +5
    use Python package openpyxl to remove an existing worksheet from an Excel file
    mlauber71 > Public > kn_example_python_excel_remove_sheet
    mlauber71
  9. 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
    mlauber71
  10. Go to item
    Consolidate Multiple Excel Files into One
    Excel Files File Manipulation Data Consolidation
    This workflow demonstrates how to bring multiple Excel files in one Excel file with multi…
    mlauber71 > Forum > 2022 > kn_forum_51793_consolidate_multiple_excel_files_into_one
    mlauber71

No known nodes available

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