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. 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

Options

Enter sheetnames

The list of sheet names as a comma separated list

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 Configuration4 ×
• Component Input1 ×
• Component Output1 ×
• Java Edit Variable1 ×

Extensions

• FeatureKNIME Javasnippet
• FeatureKNIME Quick Forms

Links

• No links available