# -*- 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')