Hub
Pricing About
ComponentComponent

Excel - Rename Worksheets

adamkingsbury profile image
Draft Latest edits on 
Oct 25, 2021 4:36 PM
Drag & drop
Like
Use or download
Rename existing sheets within excel workbooks and save the file (eiter to the same name or a new destination) The source workbook and original worksheet name must already exist for the node to work. The new worksheet name cannot be contained within the source worksheet to avoid clashes. 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
    Rename Actions
    Table containing the rename actions to perform. Each row will result in one source worksheet being opened, and one worksheet being renamed before the file is saved to the specified destination filename.
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.2
  • Go to item
    KNIME Base nodesTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.4.2

    knime
  • Go to item
    KNIME ExpressionsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.4.0

    knime
  • Go to item
    KNIME Python Integration

    KNIME AG, Zurich, Switzerland

    Version 4.4.2

    knime
  • Go to item
    KNIME Quick FormsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.4.2

    knime

This component does not have nodes, extensions, nested components and related workflows

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
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits