①获取B站番剧列表
#-*- coding: UTF-8 -*-
import requests
import json
import openpyxl
wb=openpyxl.Workbook()
sheet=wb.get_active_sheet()
sheet['A1']='season_id'
sheet['B1']='title'
sheet['C1']='total_count'
sheet['D1']='favorites'
index=2
for i in range(1,10):
url='https://bangumi.bilibili.com/web_api/season/index_global?page={}&page_size=20&version=0&is_finish=0&start_year=2017&tag_id=&index_type=1&index_sort=0&quarter=0'.format(i)
res= requests.get(url)
content=res.content
myjson=json.loads(content)
for j in range(len(myjson['result']['list'])):
sheet['A{}'.format(index)] = myjson['result']['list'][j]['season_id']
sheet['B{}'.format(index)] = myjson['result