Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • berolly
  • Spaces
  • Public
  • 05_Read_all_sheets_from_an_XLS_file_in_a_loop
WorkflowWorkflow

Read all sheets from an XLS file in a loop

Reading Excel XLS Loop Sheet

Last edited: 

Drag & drop
Like
Download workflow
Copy short link
Workflow preview
This workflow demonstrates how to read all sheets from an XML file using the XML Reader node together with the Read XLS Sheet Names node in a loop. To read all sheets from an .xls file in a loop first add the Read XLS Sheet Names node to the workspace and chose the appropriate .xls file from the file system in the configuration dialog. The node lists all sheet names from the .xls file in a data table. This table is used to feed the Table Row To Variable Loop Start node which takes one row from the data table in each loop and creates a flow variable from it. In the loop the created flow variable is fed into the XLS Reader as SHEET_NAME. The Loop End node collects all the sheets by appending the rows.

External resources

  • Excel Reader

Used extensions & nodes

Created with KNIME Analytics Platform version 4.1.4
  • Go to item
    KNIME Core Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.4

  • Go to item
    KNIME Excel Support Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.4

  • Go to item
    KNIME Plotly Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.3

  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item
  6. Go to item

Legal

By using or downloading the workflow, you agree to our terms and conditions.

Discussion
Discussions are currently not available, please try again later.

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