python创建excel表格比并存入数据

# -*- coding:utf-8-*-
import xlwt
import urllib2
import requests
from lxml import etree
c=0
workbook=xlwt.Workbook(encoding='utf-8')
booksheet=workbook.add_sheet('Sheet1', cell_overwrite_ok=True)#建立表1
usr_agent='Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36'
headers={'Usr_Agent':usr_agent}
HTML="http://list.pptv.com/?type=1&sort=1"
request=urllib2.Request(HTML,headers=headers)
html=requests.get(HTML)
seletor=etree.HTML(html.text)
content_field=seletor.xpath('//div[@class="sear-menu"]')
for each in content_field:
    type=each.xpath('dl/dd/a/@title')[1:26]
    href=each.xpath('dl/dd/a/@href')[1:26]
    for j in zip(type,href):
        kind=j[0]
        MOVIE_HTML=j[1]
        for p in range(1,30):
            Movie_html="http://list.pptv.com/channel_list.html?page=%s"%p+MOVIE_HTML[-17:]
            html2=requests.get(Movie_html)
            seletor2=etree.HTML(html2.text)
            name=seletor2.xpath('// p[@class="ui-txt"]/span/text()')
            grade=seletor2.xpath('// p[@class="ui-txt"]/em/text()')
            phtho_url=seletor2.xpath('//p[@class="ui-pic"]/img/@data-src2')
            movie_html_urls=seletor2.xpath('//a[@class="ui-list-ct"]/@href')
            for n in zip(name,phtho_url,grade,movie_html_urls):
                c+=1
                names=n[0]
                row0 = ['类型','图片网址','分数','网址','电影网址']
                for i in range(0,len(row0)):
                       booksheet.write(0,i,row0[i]) #生成表头
                booksheet.write(c,0,kind)#插入每行数据
                booksheet.write(c,1,names)
                booksheet.write(c,2,n[1])
                booksheet.write(c,3,n[2])
                booksheet.write(c,4,n[3])
                workbook.save('movies.xls')

结果展示：