import xlwt
import random
def write_excel_data():
workbook = xlwt.Workbook(encoding = ‘ascii’)
worksheet = workbook.add_sheet(‘sheet1’)
for i in range(6114):
worksheet.write(i, 1, random.randint(20 ,180)) # 不带样式的写入
workbook.save('22.xls') # 保存文件
if name == ‘main’:
write_excel_data()
