Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • knime
  • Spaces
  • Examples
  • 01_Data_Access
  • 01_Common_Type_Files
  • 07_Reading_Excel_Files
WorkflowWorkflow

Read an XLS file

Reading XLS Excel Loop Data
+5
KNIME profile image

Last edited: 

Drag & drop
Like
Download workflow
Copy short link
Workflow preview
This workflow demonstrates how to read an XLS file using the XLS Reader node. It contains three workflows. The goal of each workflow is to read accounting data from a restaurant business for all months in 2016 and to calculate the total revenues for each month. Each workflow is different, depending on how the data are stored in the .xls file. Workflow 1: All accounting data are stored in one sheet of a single Excel file. One single Excel Reader node is enough to read all data. Workflow 2: Reads data from all sheets in an Excel file using the Read Excel Sheet Names node, a loop, and the Excel Reader node Workflow 3: Reads data from all sheets of all Excel files present in a folder. Here we use the List Files node, we loop on the list of files, we use the Read Excel Sheet Names node, we loop on the list of sheets, and we read the data from each sheet.

External resources

  • Data Access in KNIME: Excel Reader

Used extensions & nodes

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

    KNIME AG, Zurich, Switzerland

    Version 4.1.0

    KNIME profile image
    knime
  • Go to item
    KNIME Excel Support Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.0

    KNIME profile image
    knime
  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item
  6. Go to item
Loading deployments
Loading ad hoc executions

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