qrcode.py 623 B

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