import pandas as pd
import numpy as np
import glob
glob.glob("C:/Users/Desktop/*.xlsx")
all_data = pd.DataFrame()
for f in glob.glob("C:/Users/Desktop/*.xlsx"):
df = pd.read_excel(f)
all_data = all_data.append(df,ignore_index=False)
print(f)
all_data.to_excel('excel.xlsx', sheet_name='Sheet1')
合并多个excel文件
最新推荐文章于 2024-01-17 09:26:23 发布