如何使用python从get方法将值写入excel

import requests
import openpyxl

url = "https://example.com/api/data"  # 替换为实际的API URL
response = requests.get(url)
data = response.json()  # 假设API返回的是JSON格式数据

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

row_num = 1
for item in data:
    sheet.cell(row=row_num, column=1, value=item['key1'])  # 替换为实际的键名
    sheet.cell(row=row_num, column=2, value=item['key2'])  # 替换为实际的键名
    # 继续添加其他键值对的写入操作
    row_num += 1

workbook.save("data.xlsx")  # 替换为实际的文件名和路径