import requests import json from openpyxl import Workbook wb = Workbook() ws = wb.active ws.append(['房间名', '主播名', '人气']) headers = { "User-Agent": "Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" } params = { "m": "LiveList", "do": "getLiveListByPage", "gameId": "2336", "tagAll": "0", } for page in range(1, 29): params['page'] = page url = 'https://www.huya.com/cache.php' response = requests.get(url=url, headers=headers, params=params) ret1 = response.text ret2 = json.loads(ret1) ret_data = ret2['data']['datas'] # print(ret_data) for room in ret_data: introduction = room['introduction'] nick = room['nick'] totalCount = room['totalCount'] num = float(totalCount) / 10000 nums = round(num,2) print("房间:{0}\t主播名:{1}\t人气:{2:.1f}万".format(introduction, nick, float(totalCount) / 10000)) ws.append([introduction, nick, str(nums)+ '万']) wb.save('王者荣耀.xlsx')