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.active10 sheet.title = '周杰伦歌曲集'11 sheet['A1'] = '编号'12 sheet['B1'] = '歌曲名'13 sheet['C1'] = '专辑名'14 sheet['D1'] = 'URL'15  16 num = 017 for music in musics:18     num = num +119 #    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')