Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • knime
  • Spaces
  • Examples
  • 01_Data_Access
  • 01_Common_Type_Files
  • 09_Multiple_Sheet_in_one_Excel_File
WorkflowWorkflow

Write three files in one Excel file on three sheets

Writing Sheets XLS Excel Split data
+4

Last edited: 

Drag & drop
Like
Download workflow
Copy short link
Workflow preview
This workflow demonstrates how to write three files in one Excel file on three sheets. It separates values in different sheets based on the person's marital status. In the top left three branches, the names of the sheets are input manually in the corresponding fields of the Excel Sheet Appender (XLS) nodes. In the top right three branches, the names of the categories are output as flow variables in the Row Filter nodes, passed to the Excel Sheet Appender (XLS) nodes, and used to create the names of the sheets. In the lower branch, a Group Loop start node is used to iterate through the categories. The name of the current iteration is passed as a variable to the Excel Sheet Appender (XLS) node and used to create the names of the sheets.

External resources

  • Transforming a data cell into a flow variable

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

  • Go to item
    KNIME Excel Support Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.0

  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. 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