代码如下:
import requests
import json
import openpyxl
import datetime
def get_response(url, headers):
res = requests.post(url=url, headers=headers)
# 把返回字段中斜杠替换成空,把首位引号字母去掉
res = res.text.replace("\\", "").strip('"')
return json.loads(res)
def write_excel(file_name, write_list):
full_excel = openpyxl.Workbook()
full_sheet = full_excel.active
for i in range(0, len(write_list)):
full_sheet.append(write_list[i])
full_excel.save(file_name)
if __name__ == '__main__':
# 访问网页信息
url = "https://sthjt.ah.gov.cn/site/label/8888?isJson=true&cityCode=340400&timeBegin=&timeEnd=&isPage=true&pageIndex=0&pageSize=10&labelName=airQualityDailyNum"
headers = {"Content-Type": "application/x-www-form-urlencoded"}
every_page_result_list = []
# 请求网页信息
res_data = get_response(url, headers)["data"]
# 生成列名字列
col_name_list = list(dict(res_data[0]).keys())
every_page_result_list.append(col_name_list)
# 获取值列写入
for i in range(0,len(res_data)):
row_list = list(dict(res_data[i]).values())
timePoint = row_list[-2]
# 把时间戳转换成日期
change_date = datetime.datetime.fromtimestamp(int(timePoint) / 1000).strftime("%Y-%m-%d")
row_list[-2] = change_date
every_page_result_list.append(row_list)
#循环写入值
write_excel(r"D:\test.xlsx", every_page_result_list)