时间戳

首页 > 解决方案 > 制作excel文件合并编码python

python - 制作excel文件合并编码python

问题描述

我尝试制作excel文件合并编码。这是如下的编码。

file_content = [sample1.xls, sample2.xls, sample3.xls]


def btncmd():

    total_df = pd.DataFrame()

    for i in file_content:
        df = pd.read_excel(i)
        total_df = total_df.append(df, ignore_index=True)
    total_df

    wb = Workbook()
    ws = wb.active

    merged_excel_file = "D:/사업/발주 및 정산/정산/정산서/리빙투게더 정산서 " + datestring + ".xlsx"

    total_df.to_excel(merged_excel_file, sheet_name="sheet", index=False)

    print("생성파일:", merged_excel_file)

    wb.close()


btn = Button(frame_folder, text="클릭", command=btncmd)
btn.pack(side="left", padx=6, pady=5)

当我运行很多次时，merged_excel_file 会被重复。如果我运行很多次，我只想保存具有 [sample1.xls, sample2.xls, sample3.xls] 的 merge_excel_file

标签： pythonexcel

解决方案

推荐阅读