Pythonは空白のxlsxファイルを作成します

417 ワード

import os,time
from openpyxl import load_workbook,Workbook

def createexcel():
    wb = Workbook()
    log_path = os.path.dirname(os.path.abspath('.')) + '\\data\\'
    t = time.strftime('%Y%m%d%H%M%S', time.localtime(time.time()))
    suffix = '.xlsx' #     
    newfile = t + suffix
    path = log_path + t + suffix
    wb.save(path)
    return newfile