爬取网易云排名并放入excel
from selenium import webdriver
from openpyxl import Workbook
browser=webdriver.Chrome()
browser.get('https://music.163.com/#/discover/toplist')
browser.switch_to.frame('g_iframe')
tbody=browser.find_element_by_tag_name('tbody')
tbody
trs=tbody.find_elements_by_tag_name('tr')
trs
list1=[]
for tr in trs:
list2=[]
list2.append(tr.find_element_by_tag_name('span').text)
list2.append(tr.find_element_by_tag_name('b').get_attribute('title'))
list2.append(tr.find_element_by_class_name('text').get_attribute('title'))
list1.append(list2)
wb=Workbook()
sheet=wb.active
for each in list1:
sheet.append(each)
wb.save('网抑云.xlsx')