Using the python package xlrd and xlwt to unmerge the excel file, and then auto fill the merged cells by the first cell in the merged cells.
For general purpose, unMergeExcelCell.py won't keep the style and format from the origin excel file.
Un-merge excel cell and auto fill with the first cell value in the merged cells
Usage: unMergeExcelCell.py <excel file>
excel file: the path for un-merging excel file
Notice: unMergeExcelCell.py will make a new excel file by add the sufix
_unmerged.
e.g. excel.xlsx -> excel_unmerged.xlsx
In learning we trust !