1 import requests
2 import openpyxl
3
4 res = requests.get('https://c.y.qq.com/soso/fcgi-bin/client_search_cp?ct=24&qqmusic_ver=1298&new_json=1&remoteplace=txt.yqq.top&searchid=21993097365818170&t=0&aggr=1&cr=1&catZhida=1&lossless=0&flag_qc=0&p=32&n=10&w=%E5%91%A8%E6%9D%B0%E4%BC%A6&g_tk=5381&loginUin=0&hostUin=0&format=json&inCharset=utf8&outCharset=utf-8¬ice=0&platform=yqq.json&needNewCode=0')
5
6 musics = res.json()['data']['song']['list']
7
8 wb = openpyxl.Workbook()
9 sheet = wb.active
10 sheet.title = '周杰伦歌曲集'
11 sheet['A1'] = '编号'
12 sheet['B1'] = '歌曲名'
13 sheet['C1'] = '专辑名'
14 sheet['D1'] = 'URL'
15
16 num = 0
17 for music in musics:
18 num = num +1
19 # print(num,end='\t')
20 # print(music['name'],end='\t')
21 # print(music['album']['name'],end='\t')
22 # print(music['url'])
23 sheet.append([num,music['name'],music['album']['name'],music['url']])
24
25 wb.save('周杰伦.xlsx')
