Hub
ComponentComponent

XLSX Sheet Duplicator

takbb profile image
Draft Latest edits on 
Drag & drop
Like
Use or download
Takes a single sheet from a source Excel XLSX file and clones it to a new XLSX file. Multiple named destination sheets may be supplied in which case the original sheet is cloned to each of the named sheets. The destination XLSX file should not already exist, but if it does, any existing sheets of the specified names will be deleted and replaced. !EXPERIMENTAL! - Please ensure that you are happy that it fulfills your requirements as there may be some limitations in what it can clone from the original source sheet. NOTE THIS COMPONENT REQUIRES KNIME AP 4.7 OR ABOVE AS IT REQUIRES SPECIFIC BUNDLED JAVA CLASSES FOR APACHE POI 4.1.1 OR LATER @takbb Brian Bates 29 May 2023

Component details

  • Sheet to be cloned

    Enter the name of the source worksheet (sheetname) to be duplicated

  • Source XLSX File location

    Enter the absolute file location of the source XLSX file

  • Destination XLSX File location

    Enter the absolute file location of the output XLSX file

  • Enter sheetnames

    The list of sheet names as a comma separated list

Used extensions & nodes

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