将JSON文件正确转换为xls

import json
import xlwt

def convert_json_to_xls(json_file, xls_file):
    # 读取JSON文件
    with open(json_file, 'r') as f:
        json_data = json.load(f)

    # 创建xls文件
    workbook = xlwt.Workbook()
    sheet = workbook.add_sheet('Sheet1')

    # 写入表头
    headers = list(json_data[0].keys())
    for i, header in enumerate(headers):
        sheet.write(0, i, header)

    # 写入数据
    for row, data in enumerate(json_data, start=1):
        for col, value in enumerate(data.values()):
            sheet.write(row, col, value)

    # 保存xls文件
    workbook.save(xls_file)

# 示例用法
json_file = 'data.json'
xls_file = 'data.xls'
convert_json_to_xls(json_file, xls_file)