在python中将json写入excel文件时出现的问题

import pandas as pd

# 读取JSON数据
json_data = pd.read_json('data.json')

# 将JSON数据转换为CSV格式
csv_data = json_data.to_csv('data.csv', index=False)

# 将CSV数据写入Excel文件
excel_data = pd.read_csv('data.csv')
excel_data.to_excel('data.xlsx', index=False)

import openpyxl
import json

# 读取JSON数据
with open('data.json') as f:
    json_data = json.load(f)

# 创建Excel工作簿和工作表
workbook = openpyxl.Workbook()
worksheet = workbook.active

# 写入表头
headers = list(json_data[0].keys())
for col_num, header in enumerate(headers, 1):
    worksheet.cell(row=1, column=col_num).value = header

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

# 保存Excel文件
workbook.save('data.xlsx')

import xlwt
import json

# 读取JSON数据
with open('data.json') as f:
    json_data = json.load(f)

# 创建Excel工作簿和工作表
workbook = xlwt.Workbook()
worksheet = workbook.add_sheet('Sheet1')

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

# 写入数据
for row_num, row_data in enumerate(json_data, 1):
    for col_num, cell_value in enumerate(row_data.values()):
        worksheet.write(row_num, col_num, cell_value)

# 保存Excel文件
workbook.save('data.xls')