Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • adamkingsbury
  • Spaces
  • ExcelHelpers
  • Excel - Copy Reference Worksheet to Destination Workbook
ComponentComponent

Excel - Copy Reference Worksheet to Destination Workbook

Adam Kingsbury profile image

Last edited: 

Drag & drop
Like
Use or download
Copy short link
Given a reference to a Source Excel Workbook and a Worksheet within it, Copy the worksheet into another Excel Workbook. The source and destination workbooks must already exist for the node to work. Node requires Python scripting extensions to be installed. The xlwings module must be installed in the python environment (this is a standard module in anaconda)

Component details

Input ports
  1. Type: Table
    Copy Actions
    Table containing the copy actions to perform. Each row will result in one source worksheet being copied into the destination workbook and saved. The destination workbook will be saved for each row, making it possible to copy multiple worksheets into the same destination workbook, but it might be slow due to multiple saving and opening actions.
Output ports
  1. Type: Table
    Results
    Returns the input table with an additional column showing the results of the actions.

Used extensions & nodes

Created with KNIME Analytics Platform version 4.4.1
  • Go to item
    KNIME Base nodes Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.4.1

    knime
  • Go to item
    KNIME Expressions Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.4.0

    knime
  • Go to item
    KNIME Python Integration Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.4.2

    knime
  • Go to item
    KNIME Quick Forms Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.4.1

    knime
  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 component, you agree to our terms and conditions.

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