代码
import pandas as pd
file_path = filename1
excel_data = pd.read_excel(file_path, sheet_name=None)
excel_data2 = pd.read_excel(filename2, sheet_name=None)
# 创建空的DataFrame
combined_df = pd.DataFrame()
# 遍历每个sheet,并将其拼接到combined_df中
for sheet_name, df in excel_data.items():
combined_df = combined_df.append(df, ignore_index=True)
for sheet_name, df in excel_data2.items():
combined_df = combined_df.append(df, ignore_index=True)
# 输出结果
combined_df.to_csv('output.csv', index=False)