import requests
from lxmlimport etree
import xlwt
#定义列表
all_info_list = []
def get_info(url):
res = requests.get(url)
html = etree.HTML(res.text)
infos=html.xpath('//div[@class="rightContentBox"]/ul/li')
for infoin infos:
pm = info.xpath('div[1]/p/text()')[0]
song = info.xpath('div[2]/a/text()')[0]
singer = info.xpath('div[3]/a/text()')[0]
info_list = [pm, song, singer]
all_info_list.append(info_list)
if __name__ =='__main__':
book = xlwt.Workbook(encoding='utf-8')
sheet = book.add_sheet('Sheet1')
header = ['pm', 'song', 'singer']
for tin range(len(header)):
sheet.write(0, t, header[t])
url ='http://www.kuwo.cn/bang/index'
get_info(url)
#循环取列表值写入EXCEL
i =1
for listin all_info_list:
j =0
for datain list:
sheet.write(i, j, data)
j +=1
i +=1
book.save('C:/Users/madin/Desktop/kuwoTOP200.xls')
