12345678910111213141516171819202122232425262728 |
- # -*- coding: utf-8 -*-
- # !/usr/bin/env python
- import random
- import string
- def generate_random_seq(size=4):
- char = string.ascii_uppercase + string.digits + string.ascii_lowercase
- return "".join(random.choice(char) for _ in range(size))
- import xlwt
- wb = xlwt.Workbook()
- ws = wb.add_sheet('sheet1')
- prefix = 'G'
- start = 550000
- total = 2000
- for i in range(0, total):
- no = start + i
- url = 'https://www.washpayer.com/userLogin?l={}{}&t={}'.format(prefix, no, generate_random_seq())
- ws.write(i, 0, url)
- ws.write(i, 1, '{}{}'.format(prefix, no))
- wb.save('example.xls')
|