如何将复杂的字典添加到excel电子表格中？

import openpyxl

workbook = openpyxl.Workbook()
worksheet = workbook.active

data = {
    '姓名': '张三',
    '年龄': 25,
    '性别': '男',
    '联系方式': {
        '手机': '123456789',
        '邮箱': 'zhangsan@example.com'
    },
    '地址': {
        '省份': '广东',
        '城市': '深圳'
    }
}

row = 1  # 起始行
for key, value in data.items():
    if isinstance(value, dict):
        # 处理嵌套字典的情况
        for sub_key, sub_value in value.items():
            column = chr(ord('A') + len(data.keys()))  # 列字母
            worksheet[column + str(row)] = sub_key
            column = chr(ord(column) + 1)  # 下一列字母
            worksheet[column + str(row)] = sub_value
            row += 1
    else:
        column = 'A'
        worksheet[column + str(row)] = key
        column = chr(ord(column) + 1)
        worksheet[column + str(row)] = value
        row += 1

workbook.save('data.xlsx')