运行程序后会自动打开网易云音乐,把指定歌单中的指定信息提取到excel中
最终在excel中的效果是:
代码如下:
from selenium import webdriver
import time
driver=webdriver.Chrome()
driver.get('https://music.163.com/#/playlist?id=2829844572')
time.sleep(2)
iframe=driver.find_element_by_id('g_iframe')
driver.switch_to.frame(iframe)
parent=driver.find_element_by_id('m-playlist')
tbody=parent.find_element_by_tag_name('tbody')
trs=tbody.find_elements_by_tag_name('tr')
data=[]
for index,each in enumerate(trs):
#序号
num=each.find_element_by_class_name('num').text
href=each.find_elements_by_tag_name('td')[1].find_element_by_tag_name('a').get_attribute('href')
name=each.find_elements_by_tag_name('td')[1].find_element_by_tag_name('b').get_attribute('title')
singer = each.find_elements_by_tag_name('td')[3].find_element_by_tag_name('div').get_attribute('title')
data.append([num,href,name,singer])
# ============================================保存到excel中================================
#下面的语法具体含义见我的上一篇文章,存储数据到Excel
from openpyxl import Workbook
wb=Workbook()
sheet=wb.active
sheet.title='音乐'
for each in data:
sheet.append(each)
wb.save('放松时听的歌1.xlsx')