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

Read Excel Sheet Names (XLS) (deprecated)

IO Read

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

Like
Copy short link

This node reads a spread sheet 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).

Node details

Output ports
  1. Type: Table
    Output table
    The sheet names contained in the workbook.

Extension

The Read Excel Sheet Names (XLS) (deprecated) node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    Read all sheets from an XLS file in a loop
    Reading Excel XLS
    +2
    This workflow demonstrates how to read all sheets from an XML file using the XML Reader n…
    knime > Examples > 01_Data_Access > 01_Common_Type_Files > 05_Read_all_sheets_from_an_XLS_file_in_a_loop
  2. Go to item
    Read all sheets from an XLS file in a loop
    Reading Excel XLS
    +2
    This workflow demonstrates how to read all sheets from an XML file using the XML Reader n…
    haoran > Public > 01_Data_Access > 01_Common_Type_Files > 05_Read_all_sheets_from_an_XLS_file_in_a_loop
  3. Go to item
    Reading Multiple Excel file with different sheet names
    Excel Sheets Multiple
    +1
    This worklow reads in multiple excel files from a folder. It takes the location and the s…
    hanss > Public > forum_flows > reading multiple excel with different sheet names
  4. 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
  5. Go to item
    XLS Sheetname Reader not using variable
    mwiegand > Public > Bugs > XLS Sheetname Reader not using variable
  6. Go to item
    读多个文件多个工作表
    vzzw > Public > 读多个文件多个工作表
  7. Go to item
    use R's openxlsx to remove an existing worksheet from an Excel file
    Openxlsx Excel Load
    +5
    use R's openxlsx to remove an existing worksheet from an Excel file edit: warning! in thi…
    mlauber71 > Public > kn_example_r_excel_remove_sheet
  8. Go to item
    Read all sheets from Google Sheet & Excel with loop nodes
    Google Sheet XLS Loop
    +3
    This workflow demonstrate how to read all the sheets (or selected sheets) from a Google S…
    yemunn_soe_ydsc > Public > Read all sheets from Google Sheet & Excel with loop nodes
  9. Go to item
    m_001_import
    shanaka > Public > kn_example_multiple_excel_sheets4 > m_001_import
  10. Go to item
    Test3_project
    There has been no description set for this workflow's metadata.
    mlauber71 > Public > forum > kn_forum_db_loop_excel_sheet
  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item
  6. Go to item

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