如何将JSON正确导入Excel

import json
from openpyxl import Workbook

def import_json_to_excel(json_data, excel_file):
    # 解析JSON数据
    data = json.loads(json_data)
    
    # 创建Excel文件
    workbook = Workbook()
    sheet = workbook.active
    
    # 写入表头
    headers = list(data[0].keys())  # 假设JSON数据是一个字典列表，取第一个字典的键作为表头
    for col, header in enumerate(headers, start=1):
        sheet.cell(row=1, column=col, value=header)
    
    # 写入数据
    for row, item in enumerate(data, start=2):
        for col, value in enumerate(item.values(), start=1):
            sheet.cell(row=row, column=col, value=value)
    
    # 保存Excel文件
    workbook.save(excel_file)

# 示例数据
json_data = '[{"name": "John", "age": 30, "city": "New York"}, {"name": "Alice", "age": 25, "city": "San Francisco"}]'
excel_file = 'output.xlsx'

# 导入JSON数据到Excel
import_json_to_excel(json_data, excel_file)