Excel Unmerge Cells

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

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

Nodes

• String Configuration2 ×
• Component Input1 ×
• Component Output1 ×
• Java Edit Variable1 ×
• String to Path (Variable)1 ×

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Javasnippet
• FeatureKNIME Quick Forms

Links

• No links available