Hub
NodeNode / Source

Read Excel Sheet Names

streamable

This node supports the path flow variable. For further information about file handling in general see the File Handling Guide.

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).

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:

Related workflows & nodes

  1. 31485-looping-through-excel-sheets
    kowisoft > Public > 31485-looping-through-excel-sheets
  2. 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
  3. Workflow Control
    loop reading many files switch +4
    "Workflow Control" exercise for advanced Life Science User Training - Handle and write groups of data to separate sheet…
    knime > Education > Courses > L2-LS KNIME Analytics Platform for Data Scientists - Life Science - Advanced > Exercises > 02. Workflow Control
  4. Workflow Control - Solution
    loop reading many files switch +3
    Solution to exercise 11 for the KNIME Analytics Platform for Data Wranglers course - Write subsets of a file using a lo…
    knime > Education > Courses > L2-DW KNIME Analytics Platform for Data Wranglers - Advanced > Solutions > 11_Workflow_Control_Solution
  5. Workflow Control - Solution
    loop reading many files switch +3
    Solution to exercise 11 for the KNIME Analytics Platform for Data Wranglers course - Write subsets of a file using a lo…
    knime > Education > Courses > L2-DS KNIME Analytics Platform for Data Scientists - Advanced > solutions > 08. Workflow Control - solution
  6. Workflow Control - Solution
    loop reading many files switch +3
    Solution to exercise 11 for the KNIME Analytics Platform for Data Wranglers course - Write subsets of a file using a lo…
    stephanheym > Public > 08. Workflow Control - solution
  7. Workflow Control Solution
    loop reading many files switch +4
    Solution for "Workflow Control" exercise for advanced Life Science User Training - Handle and write groups of data to s…
    knime > Education > Courses > L2-LS KNIME Analytics Platform for Data Scientists - Life Science - Advanced > Solutions > 02. Workflow Control - solution
  8. use Python Pandas and Openpyxl to import and export Excel (sheets) and Export them back
    python excel import +4
    use Python Pandas and Openpyxl to import and export Excel (sheets) and Export them back
    mlauber71 > Public > kn_example_python_excel_import_export_openpyxl
  9. This workflow demonstrates how to use the new Excel Reader and path variables and read Excel sheets
    This workflow demonstrates how to use the new Excel Reader and path variables and read Excel sheets There seems to be s…
    mlauber71 > Public > kn_example_excel_new_node_list_sheets