import requests
from openpyxl import workbook
# 获取返回数据,先打开文件,写入完成之后,再关闭
res = requests.get("http://www.10086.cn/support/selfservice/help/sh/5010801_4073_8801.json")
data_list = res.json()
data_list = data_list["cData"]["list"]
# 新建一个工作簿
wb = workbook.Workbook()
sheet = wb.worksheets[0]
row_index = 1
# 遍历数据,获取对应的值
for item in data_list:
question = item["question"]
answer = item["answer"]
orderId = item["_orderId"]
cell1 = sheet.cell(row_index, 1)
cell1.value = question
cell2 = sheet.cell(row_index, 2)
cell2.value = answer
cell3 = sheet.cell(row_index, 3)
cell3.value = orderId
row_index = row_index + 1
# 保存到Excel中
wb.save("question.xlsx")
【爬虫获取数据后保存至Excel中】
最新推荐文章于 2024-03-29 16:44:41 发布