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 duplicatedSource XLSX File location
Enter the absolute file location of the source XLSX fileDestination XLSX File location
Enter the absolute file location of the output XLSX fileEnter sheetnames
The list of sheet names as a comma separated list
Used extensions & nodes
Created with KNIME Analytics Platform version 4.7.2
- Go to item
- Go to item
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.