import random
import xlwt
b = []
for i in range(1, 1500):
a = []
#data = random.uniform(0.5, 4)
data = random.randint(1, 154)
data = round(data, 6)
a.append(data)
if a not in b:
b.append(a)
print (i)
print (b)
workbook = xlwt.Workbook(encoding='utf-8')
data_sheet = workbook.add_sheet("show_data")
index = 0
for i in b:
for j, item in enumerate(i):
data_sheet.write(index, j, item)
index += 1
workbook.save("data.xls")
python生成随机数并存到excel中的一列
最新推荐文章于 2024-04-22 10:13:44 发布