NOTE - 2023-07-25 DEPRECATED
- Please use Excel Unmerge Cells which handles formulas and formatting in the cells being unmerged
Reads an Excel XLSX file and attempts to unmerge any merged cells. All unmerged cells are given the value that previously applied to the merged cell.
The location of the unmerged file is conveniently returned as a path flow variable so that it can then be passed to an Excel Reader node.
This component uses a java edit variable node to perform the Excel sheet processing, with the Apache POI package.
The java code was written with the aid of chatGPT and a few manual tweaks. Please treat this as experimental, and fully test that it meets your own requirements.
@takbb Brian Bates 25 May 2023
To use this component in KNIME, download it from the below URL and open it in KNIME:
Download ComponentDeploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.
Try NodePit Runner!Do you have feedback, questions, comments about NodePit, want to support this platform, or want your own nodes or workflows listed here as well? Do you think, the search results could be improved or something is missing? Then please get in touch! Alternatively, you can send us an email to mail@nodepit.com.
Please note that this is only about NodePit. We do not provide general support for KNIME — please use the KNIME forums instead.