Python将list类型数据保存到本地Excel报错

Question

Python将list类型数据保存到本地Excel报错

    data = json.dumps(data)
    rsp = requests.post(api, headers=headers, data=data).json()
    rsp0 = rsp['data']['records'][0]
    workbook = openpyxl.Workbook()
    worksheet = workbook.active
    worksheet.append(rsp0)
    workbook.save('C:\\1.xlsx')

报错见下图

Answer 1

数据不对，你那个传的是list么？