说明

import random
import string
import xlwt
import datetime
from time import strftime

#输入生成个数
sums = input("请输入生成个数:")

#检查参数
if not sums.isdigit():
    print("输入非法")
    exit(0)


#创建workbook 设置编码
workbook = xlwt.Workbook(encoding='utf-8')

#创建一个worksheet
worksheet  =workbook.add_sheet('worksheet')

#第一列宽度
worksheet.col(1).width = 3333

#输出
for i in range(int(sums)):
    print('{}...'.format(i))
    val1 = ''.join(random.sample(string.digits, 7))
    val2 = ''.join(random.sample(string.digits, 8))
    val = '2022-{}-{}'.format(val1, val2)
    worksheet.write(i, 0, label=val)

#文件名
data_s = datetime.datetime.now().strftime("%Y-%m-%d-%H-%M-%S")
file_s = '随机订单号-{}-{}.xls'.format(sums, data_s)

#保存
workbook.save(file_s)