import requests

from lxml import etree

import xlwt

all_info_list=[]

def get_info(url):

      res = requests.get(url)

      html = etree.HTML(res.text)

      infos = html.xpath('//ul[@class="rank_list"]/li')

      for infoin infos:

           rank1 = info.xpath('em ')[0]

           rank = rank1.xpath('string(.)').strip()

           name = info.xpath('a/text()')[0]

           size = info.xpath('i/text()')[0]

           popularity = info.xpath('span/text()')[0]

           # print(game,size,popularity)

           info_list = [rank,name,size,popularity]

           all_info_list.append(info_list)

if __name__ =='__main__':

      book = xlwt.Workbook(encoding='utf-8')

      sheet = book.add_sheet('Sheet1')

      header = ['rank','name','size','popularity']

      for t  in range(len(header)):

            sheet.write(0, t, header[t])

      urls = ['http://www.doyo.cn/rank/shouji/100/page/{}'.format(str(i))for i  in range(1,4)]

      for url in urls:

              get_info(url)

       i =1

       for list in all_info_list:

             j =0

             for datain list:

                    sheet.write(i, j, data)

                     j +=1

              i +=1

    book.save('C:/Users/Xumeiling/Desktop/手机游戏排行榜.xls')