Recently I had a project to load the data from excel sheet into database. The excel sheets are monthly summery report and they have many merged cells, so I wrote a utility function in python using
openpyxl library to unmerge the cell and populate the top cell value.
Here is the code, the first helper function
create_merged_cell_lookup is taking the one worksheet and return a
dict of cell location and its cell value. Then this helper function will be passed into
unmerge_cell_copy_top_value and we use the
openpyxl then populate the value from