Reads an Excel XLSX or XLS file and attempts to unmerge any merged cells. All unmerged cells are given the value that previously applied to the merged cell.
This is an updated version of the XLSX Cell Un-Merge component, and can read both .xlsx and .xls files. In addition, this now attempts to execute any formula and replace it with the literal calculated value so that when it is unmerged, the alculated value rather than the formula expression is placed into each unmerged cell.
The location of the unmerged file is conveniently returned as both string and path flow variables so that it can then be passed to an Excel Reader node, or used by other components or nodes.
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 July 2023
v1.1 bug fix 26 July 2023
- Type: Flow VariableFlow variables containing path and string of file location.