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