ticket

import requests
import re
import xlwt
workbook=xlwt.Workbook(encoding='utf-8')
worksheet=workbook.add_sheet('大乐透')
# from collections import Counter
# c=[]
# print(Counter(c))
path='https://webapi.sporttery.cn/gateway/lottery/getHistoryPageListV1.qry?gameNo=85&provinceId=0&pageSize=30&isVerify=1&pageNo='
rem=[]
for i in range(1,70):
    goal_text=requests.get(path+str(i)).text
    print('第'+str(i)+'页面ok')
    ret=re.findall('lotteryDrawNum":"(.*?)","lotteryDrawResult":"(.*?)","lotteryDrawStatus":20,"lotteryDrawTime":"(.*?)"',goal_text)
    rem=rem+ret
k = 1
with open('财富密码', mode='a', encoding='utf-8') as f:
    worksheet.write(0, 0, label='财富期号')
    worksheet.write(0, 1, label='财富密码')
    worksheet.write(0, 2, label='开奖日期')
    for s in rem:
        worksheet.write(k, 0, label=s[0])
        worksheet.write(k, 1, label=s[1])
        worksheet.write(k, 2, label=s[2])
        k += 1
workbook.save('财富密码.xlsx')