有时候需要造一点测试数据,为了让测试数据时间都看上去像真实的时间,搞个pycharm生成个随机时间 - import datetime
- import random
- import time
- import xlwt
- MINTIME = datetime.datetime(2022,5,6,8,14,59)
- MAXTIME = datetime.datetime(2022,5,7,8,14,59)
- mintime_ts = int(time.mktime(MINTIME.timetuple()))
- maxtime_ts = int(time.mktime(MAXTIME.timetuple()))
- RECORDS = 10
- book = xlwt.Workbook(encoding='utf-8',style_compression=0)
- sheet = book.add_sheet('时间',cell_overwrite_ok=True)
- for RECORD in range(RECORDS):
- random_ts = random.randint(mintime_ts, maxtime_ts)
- RANDOMTIME = datetime.datetime.fromtimestamp(random_ts)
- style = xlwt.XFStyle()
- style.num_format_str = 'YYYY-MM-DD hh:mm:ss'
- sheet.write(RECORD,0,RANDOMTIME,style)
- print (RANDOMTIME)
- savepath = 'D:\\1work\\tmp\\py_code\\date_time.xls'
- book.save(savepath)
复制代码
|