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