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
- Type: Flow Variable