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

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