【疫情体温随机记录表】

#!/usr/bin/env python
# -*- coding = utf-8 -*-
# @Time : 2021/3/19 9:55
# @Author : 陈良兴
# @File : 随机温度 
# @Software : PyCharm

import xlwt         # 进行excel操作
import random

def get_temperature():
    temperature_list = []
    for i in range(440):
        a = random.randint(1, 9)
        temperature = 36 + float(a*0.1)
        temperature_list.append(temperature)
    return temperature_list


#保存数据
def saveData(datalist, savepath):
    print("save......")
    book = xlwt.Workbook(encoding="utf-8", style_compression=0)               # 创建workbook对象
    sheet = book.add_sheet('体温', cell_overwrite_ok=True)        # 创建工作表

    num = 0
    for i in range(44):
        print("第%d条" % (i+1))
        for j in range(10):
            sheet.write(i, j, datalist[num])                        # 数据
            num += 1

    book.save(savepath)                                      # 保存数据表


if __name__ == '__main__':
    saveData(get_temperature(), r".\\体温.xls")