思路：爬取到網頁數據之後並生成到excel中，涉及到爬蟲和python處理excel的導出
一、代碼
import json
import requestsimport xlwt
# 設置頭部信息，防止被檢測出是爬蟲headers = { 'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.116 Safari/537.36'}url = "https://game.gtimg.cn/images/lol/act/img/js/heroList/hero_list.js"response = requests.get(url=url, headers=headers).textloads = json.loads(response)dic = loads['hero']# 創建一個workbook 設置編碼workbook = xlwt.Workbook(encoding='utf-8')# 創建一個worksheetworksheet = workbook.add_sheet('LOL')try: for i in range(len(dic)): # 設置單元格寬度大小 worksheet.col(i).width = 4000 # 設置單元格高度大小 style = xlwt.easyxf('font:height 300') worksheet.row(i).set_style(style) # 第一行用於寫入表頭 if i == 0: worksheet.write(i, 0, '編號') worksheet.write(i, 1, '名稱') worksheet.write(i, 2, '英文名') worksheet.write(i, 3, '中文名') worksheet.write(i, 4, '角色') worksheet.write(i, 5, '物攻') worksheet.write(i, 6, '物防') worksheet.write(i, 7, '魔攻') worksheet.write(i, 8, '魔防') continue worksheet.write(i, 0, dic[i - 1]['heroId']) worksheet.write(i, 1, dic[i - 1]['name']) worksheet.write(i, 2, dic[i - 1]['alias']) worksheet.write(i, 3, dic[i - 1]['title']) roles_ = dic[i - 1]['roles'] roles = [] for data in roles_: if 'mage' == data: roles.append('法師') if 'tank' == data: roles.append('坦克') if 'fighter' == data: roles.append('戰士') if 'marksman' == data: roles.append('ADC') if 'assassin' == data: roles.append('刺客') if 'support' == data: roles.append('輔助') worksheet.write(i, 4, str(roles)) worksheet.write(i, 5, dic[i - 1]['attack']) worksheet.write(i, 6, dic[i - 1]['defense']) worksheet.write(i, 7, dic[i - 1]['magic']) worksheet.write(i, 8, dic[i - 1]['difficulty']) # 保存 workbook.save('C:\\Users\\Jonsson\\Desktop\\lol.xls')except Exception as e: print(e)
二、效果
求關注求贊求轉發，你的支持是我最大的動力！我們下期見