合并多个excel表格
合并多个EXCEL
""" import os import pandas as pd import xlwt, xlrd from GINA_START.gina_baseinfo import baseinfo # 实例化 baseinfo = baseinfo() path = r'F:\小高天天乐\锚点取值\2.0项目\建设_债承项目\债承项目\债承1.0' file_list = os.listdir(path) df = pd.DataFrame() for file_name in file_list: if file_name.endswith('.xlsx'): print("-----------------", file_name) file_path = os.path.join(path, file_name) file_conect = pd.read_excel(file_path, sheet_name='业务锚点') # columns = file_conect.columns file_conect.columns = file_conect.loc[0, :].values.tolist() file_conect = file_conect.loc[1:, :] df = df.append(file_conect) print(df) df.to_excel(r'F:\小高天天乐\锚点取值\2.0项目\建设_债承项目\债承项目\债承1.0\data.xlsx')