用Python在Excel中保存字典

pip install openpyxl

import openpyxl

def save_dict_to_excel(dictionary, filename):
    workbook = openpyxl.Workbook()
    sheet = workbook.active

    # 写入表头
    headers = list(dictionary.keys())
    for col_num, header in enumerate(headers, 1):
        sheet.cell(row=1, column=col_num).value = header

    # 写入数据
    data = list(dictionary.values())
    for row_num, row_data in enumerate(data, 2):
        for col_num, cell_value in enumerate(row_data, 1):
            sheet.cell(row=row_num, column=col_num).value = cell_value

    # 保存Excel文件
    workbook.save(filename)

# 示例字典
dictionary = {
    '姓名': ['张三', '李四', '王五'],
    '年龄': [20, 25, 30],
    '性别': ['男', '女', '男']
}

# 保存字典到Excel文件
save_dict_to_excel(dictionary, 'data.xlsx')