import xlwt
import random
def write_excel_data():
workbook = xlwt.Workbook(encoding = 'ascii')
worksheet = workbook.add_sheet('sheet1')
for i in range(6114): # 生成6114条数据
worksheet.write(i, 1, random.randint(20 ,180)) # 不带样式的写入(行,列,数据)
workbook.save('22.xls') # 保存文件
if __name__ == '__main__':
write_excel_data()
python随机数写入excel
于 2022-04-19 09:19:47 首次发布