Demonstration of XLSX Cell Un-Merge component. This uses java to unmerge cells in a spreadsheet and then writes the modifications to a new xlsx file that can be read in using Excel Readers.
Unlike the standard processing of merged cells, the Un-Merge component replaces the value in each cell with the value that was shared in the merged cell. So actual empty cells remain empty but the merged cells are populated with a value so that they can be processed.
Used extensions & nodes
Created with KNIME Analytics Platform version 4.7.1
Legal
By using or downloading the workflow, you agree to our terms and conditions.