openpyxl无意中删除链接的单元格

from openpyxl import load_workbook

# 打开Excel文件
wb = load_workbook('example.xlsx')

# 获取工作表
ws = wb['Sheet1']

# 遍历每个单元格
for row in ws.iter_rows():
    for cell in row:
        # 检查单元格是否包含链接
        if cell.hyperlink is not None:
            # 如果链接已删除，重新设置链接
            if cell.value is None:
                cell.hyperlink = cell.hyperlink.target

# 保存并关闭Excel文件
wb.save('example.xlsx')
wb.close()