VBA脚本写的合并多张EXCEL表的地址为: EXCEL VBA 合并多张相同格式的工作表的宏
以下是Python脚本编写的用于合并多张excel表的代码:
# -*- coding: utf-8 -*-
"""
Created on Fri Jul 13 18:09:06 2018
@author: Neil
"""
import os
import pandas as pd
if __name__=="__main__":
for root, dirs, files in os.walk("./excel_orig/"): #需要合并的excel表的文件夹
break
excel_read = []
nums = []
for file in files:
file_path = root + file
if not(file[0] == '~'):
f = pd.read_excel(file_path)
excel_read.append(f)
nums.append(file + " num is: " + str(len(f)))
print("read sucessfully...")
concat_excel = pd.concat(excel_read, ignore_index = True)
print("concat sucessfully...")
writer = pd.ExcelWriter("./excel_concat/concat_excel.xlsx") #合并结果存储文件夹
concat_excel.to_excel(writer, index = False)
writer.save()
print("save sucessfully...")
with open('./excel_concat/logs.txt','w') as f_log:
for line in nums:
f_log.write(line + '\n')
f_log.write("total num is: " + str(len(concat_excel))) #各表数据行数统计日志
print("logs save sucessfully...")