import pandas as pd
import glob
<h1>获取所有Excel文件路径</h1><p>file_paths = glob.glob("*.xlsx")</p><h1>读取每个文件的数据并合并</h1><p>all_data = pd.DataFrame()
for file in file_paths:
df = pd.read_excel(file)
all_data = pd.concat([all_data, df], ignore_index=True)</p><h1>保存合并结果</h1><p>all_data.to_excel("合并结果.xlsx", index=False)</p>

import pandas as pd
<h1>读取整个Excel文件的所有Sheet</h1><p>excel_file = pd.ExcelFile("多个Sheet的文件.xlsx")
all_sheets = []</p><h1>遍历每个Sheet</h1><p>for sheet_name in excel_file.sheet_names:
df = pd.read_excel(excel_file, sheet_name=sheet_name)
all_sheets.append(df)</p><h1>合并所有Sheet</h1><p>combined_df = pd.concat(all_sheets, ignore_index=True)</p>
                    <div class="aritcle_card">
                        <a class="aritcle_card_img" href="/ai/1501">
                            <img src="https://img.php.cn/upload/ai_manual/000/969/633/68b7a4379566e806.png" alt="美图云修">
                        </a>
                        <div class="aritcle_card_info">
                            <a href="/ai/1501">美图云修</a>
                            <p>商业级AI影像处理工具</p>
                            <div class="">
                                <img src="/static/images/card_xiazai.png" alt="美图云修">
                                <span>50</span>
                            </div>
                        </div>
                        <a href="/ai/1501" class="aritcle_card_btn">
                            <span>查看详情</span>
                            <img src="/static/images/cardxiayige-3.png" alt="美图云修">
                        </a>
                    </div>
                <h1>保存结果</h1><p>combined_df.to_excel("合并后的Sheet.xlsx", index=False)</p>

all_data = pd.DataFrame()
for file in glob.glob("*.xlsx"):
    df = pd.read_excel(file)
    df["来源文件"] = file  # 添加来源列
    all_data = pd.concat([all_data, df], ignore_index=True)
<p>all_data.to_excel("带来源的合并结果.xlsx", index=False)</p>