13、 使用openpyxl存储周杰伦的歌曲信息

 
 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')

 

 
 
 
 
posted @ 2019-04-16 22:29  三角形  阅读(243)  评论(0)    收藏  举报