excel 合并

import os
import pandas as pd


def merge_excel(old_dir_path, new_path):

    file_list = []
    for file in os.listdir(old_dir_path):
        file_path = os.path.join(path,file)
        file_list.append(file_path)
    li = []
    for i in file_list:
        li.append(pd.read_excel(i, keep_default_na=False))
    writer = pd.ExcelWriter(new_path)
    pd.concat(li).to_excel(writer, 'Sheet1', index=False)
    writer.save()


if __name__ == '__main__':
    path = r'C:\Users\Administrator\Desktop\历史组新增人物'
    new_path = r'C:\Users\Administrator\Desktop\历史组新增人物.xlsx'
    merge_excel(path, new_path)