XLSX Sheet Duplicator

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. If the destination XLSX file already exists, 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.

This component uses Apache POI java classes (bundled with KNIME). Future versions of KNIME may include different versions of POI, and this component attempts to collect the required java bundles. There is no guarantee that future POI classes will work. Please contact @takbb on the KNIME community forum if you experience difficulty with this component.

@takbb Brian Bates 29 May 2023

Options

Enter sheetnames

The list of destination sheet names as a comma separated list. The source sheet will be cloned to all of the sheet names given here

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

Nodes

• String Configuration5 ×
• Component Input3 ×
• Component Output3 ×
• Table Row to Variable3 ×
• Column Rename2 ×
• Show all 20 nodes

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Basic File System Connectors
• FeatureKNIME Javasnippet
• FeatureKNIME Quick Forms

Links

• No links available