python爬虫数据存储到xlsx文件中

import requests
import time
from openpyxl import Workbook
headers={
    'user-agent':'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36'
}
page=1

wb = Workbook()
while True:
    url='链接'+str(int(time.time()))
    res=requests.get(url,headers=headers)
    #print(res.text)
    res_json=res.json()['data']
    #print(res_json)
    #创建子表
    sheet=wb.create_sheet(f"第{page}页")
    sheet.append(['姓名','英文名','所属球队','球衣号码','位置','身高','体重','NBA经验','国籍'])
    for item in res_json:
        name=item['firstName']+item['lastName']#姓名
        ename=item['displayName']#英文名
        team=item['teamName']#所属球队
        jerseyNo=item['jerseyNo']   #球衣号码
        position=item['position']   #位置
        heightMetric=item['heightMetric']#身高
        weightMetric=item['weightMetric']#体重
        experience=item['experience']#NBA经验
        country=item['country']    #国籍
        sheet.append([name, ename, team,jerseyNo, position, heightMetric, weightMetric, experience, country])

        print(name)
    page+=1
    if page>11: break

#删除默认子表
wb.remove(wb.active)
wb.save('./index/nba球员信息.xlsx')