XLSX Cell Un-Merge


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

Options

Excel File Location (absolute path)
Enter the absolute path for the Excel XLSX file
Output file
Enter the absolute path for the output Excel XLSX file. This will be a copy of the original but with the merged cells unmerged

Input Ports

This node has no input ports

Output Ports

Icon
No description for this port available.

Nodes

Extensions

Links