python excel中合并的单元格拆分并补充完整的数据

from copy import deepcopy
import openpyxl

fn = r'产品清单-合并单元.xlsx'
wb = openpyxl.load_workbook(fn)
ws = wb.worksheets[0]

for area in deepcopy(ws.merged_cells):
    ws.unmerge_cells(start_row=area.min_row,end_row=area.max_row,start_column=area.min_col,end_column=area.max_col)
    for row in range(area.min_row,area.max_row+1):
        for col in range(area.min_col, area.max_col+1):
            ws.cell(row=row,column=col,value=ws.cell(area.min_row,area.min_col).value)

wb.save('拆分单元格结果.xlsx')