手动操作的坑我们直接帮你踩过：

100 个 Excel 逐个打开看行数，至少半小时起步，还容易数错；文件一多，根本记不住哪个文件多少行，后续核对完全没依据。

✅ 全目录扫描：指定文件夹，自动识别所有.xlsx/.xls文件

✅ 精准计数：支持单 / 多 Sheet，可自定义是否剔除表头

✅ 异常兼容：跳过加密文件、损坏文件、空表，不中断运行

✅ 可视化输出：控制台实时打印进度，同步生成 Excel 统计报表

✅ 低门槛使用：Python 环境 + 两行安装命令，零基础也能跑

✅ 业务适配：完美匹配分省、分市、分地区拆分存储的爬虫数据

pip install pandas openpyxl 

import os
import pandas as pd
import tkinter as tk
from tkinter import ttk, filedialog, messagebox
import threading

class ExcelCounterApp:
    def __init__(self, root):
        self.root = root
        self.root.title("📊 目录Excel内容条数统计工具")
        self.root.geometry("750x550")
        self.root.resizable(False, False)

        # 变量
        self.target_path = tk.StringVar()
        self.total_count = 0

        # 顶部：路径选择
        tk.Label(root, text="目标文件夹：").place(x=20, y=20)
        tk.Entry(root, textvariable=self.target_path, width=60).place(x=100, y=20)
        tk.Button(root, text="选择文件夹", command=self.select_path, bg="#4CAF50", fg="white").place(x=520, y=15)

        # 按钮
        self.start_btn = tk.Button(root, text="开始统计", command=self.start_count, bg="#2196F3", fg="white", width=15)
        self.start_btn.place(x=20, y=60)
        tk.Button(root, text="清空结果", command=self.clear_result, bg="#f44336", fg="white", width=15).place(x=180, y=60)

        # 状态
        self.status_label = tk.Label(root, text="状态：等待操作", fg="blue")
        self.status_label.place(x=350, y=65)

        # 表格展示
        self.tree = ttk.Treeview(root, columns=("目录", "文件数", "总行数"), show="headings")
        self.tree.heading("目录", text="目录路径")
        self.tree.heading("文件数", text="Excel文件数量")
        self.tree.heading("总行数", text="内容总条数")
        self.tree.column("目录", width=450)
        self.tree.column("文件数", width=100)
        self.tree.column("总行数", width=120)
        self.tree.place(x=20, y=100, width=700, height=400)

        # 汇总
        self.summary_label = tk.Label(root, text="📊 汇总：共 0 个目录 | 总计 0 条数据", font=("Arial", 12, "bold"))
        self.summary_label.place(x=20, y=510)

    def select_path(self):
        path = filedialog.askdirectory()
        if path:
            self.target_path.set(path)

    def clear_result(self):
        for item in self.tree.get_children():
            self.tree.delete(item)
        self.total_count = 0
        self.status_label.config(text="状态：已清空")
        self.summary_label.config(text="📊 汇总：共 0 个目录 | 总计 0 条数据")

    def start_count(self):
        path = self.target_path.get().strip()
        if not os.path.isdir(path):
            messagebox.showerror("错误", "请选择有效文件夹！")
            return

        self.start_btn.config(state=tk.DISABLED)
        self.status_label.config(text="状态：正在统计...")
        self.clear_result()

        # 子线程运行，防止界面卡死
        thread = threading.Thread(target=self.do_count, args=(path,))
        thread.daemon = True
        thread.start()

    def do_count(self, root_path):
        dir_data = {}  # key:目录路径 value:[文件数, 总行数]
        excel_ext = (".xlsx", ".xls", ".csv")

        try:
            # 遍历所有目录和文件
            for folder_path, _, files in os.walk(root_path):
                file_count = 0
                row_count = 0

                for file in files:
                    if file.lower().endswith(excel_ext):
                        file_path = os.path.join(folder_path, file)
                        try:
                            if file.endswith(".csv"):
                                df = pd.read_csv(file_path, on_bad_lines="skip")
                            else:
                                df = pd.read_excel(file_path, sheet_name=None)
                                row_count += sum(len(sheet) for sheet in df.values())
                            file_count += 1
                        except Exception as e:
                            print(f"读取失败：{file_path} => {str(e)}")

                if file_count > 0:
                    dir_data[folder_path] = [file_count, row_count]

            # 统计完成，更新界面
            total_dir = len(dir_data)
            total_rows = sum(v[1] for v in dir_data.values())

            for folder, (f_cnt, r_cnt) in dir_data.items():
                self.tree.insert("", tk.END, values=(folder, f_cnt, r_cnt))

            self.status_label.config(text="状态：✅ 统计完成", fg="green")
            self.summary_label.config(
                text=f"📊 汇总：共 {total_dir} 个目录 | 总计 {total_rows} 条数据",
                fg="red"
            )
        except Exception as e:
            messagebox.showerror("异常", f"统计出错：{str(e)}")
            self.status_label.config(text="状态：❌ 统计失败", fg="red")
        finally:
            self.start_btn.config(state=tk.NORMAL)

if __name__ == "__main__":
    window = tk.Tk()
    app = ExcelCounterApp(window)
    window.mainloop()