import random
from openpyxl import Workbook
import time
start_time=time.asctime(time.localtime(time.time()))
print()
#生成表头
header=[]
for h in range(1,11):
head='列{}'.format(h)
header.append(head)
#生成工作簿
for n in range(1,1001):
data=[]
wb_new=Workbook()
ws_new=wb_new.active
ws_new.append(header)
#生成行数
r=random.randint(1,100)
for row in range(1,r+1):
#生成cell随机数
data_cell=[]
i=1
while i<=10:
num=random.randint(1,1000)
data_cell.append(num)
i+=1
ws_new.append(data_cell)
wb_new.save('D:/随机数表格/{}.xlsx'.format(n))
print('第{}表完成'.format(n))
end_time=time.asctime(time.localtime(time.time()))
print('程序开始时间:{},程序结束时间:{}'.format(start_time,end_time))