员工考勤统计与异常标记工具：导入打卡记录、自动计算工时、迟到早退缺卡标记、月度汇总导出Excel

🖥️ 运行效果

🚀 实例简介

一款实用的考勤管理桌面工具，支持导入员工打卡记录CSV文件，自动计算每日工时，智能标记迟到、早退、缺卡等异常情况，并支持月度汇总报表一键导出Excel。适合HR和行政人员快速处理考勤数据。

💻 核心代码

import os
import csv
import tkinter as tk
from tkinter import ttk, filedialog, messagebox
import platform

CHINESE_FONT = "WenQuanYi Zen Hei" if platform.system() == "Linux" else "Microsoft YaHei"

class AttendanceApp:
    """员工考勤统计与异常标记工具"""
    
    def __init__(self, root):
        self.root = root
        self.root.title("员工考勤统计与异常标记工具")
        self.root.geometry("820x580")
        self.root.configure(bg="#f0f4f8")
        self.records = []
        
        # 标题
        tk.Label(root, text="📋 员工考勤统计与异常标记工具",
                 font=(CHINESE_FONT, 16, "bold"), bg="#f0f4f8", fg="#1a365d").pack(pady=10)
        
        # 按钮区
        btn_frame = tk.Frame(root, bg="#f0f4f8")
        btn_frame.pack(pady=5)
        tk.Button(btn_frame, text="📂 导入打卡记录", command=self.load_csv,
                  font=(CHINESE_FONT, 11), bg="#3182ce", fg="white",
                  relief="flat", padx=12, pady=4).pack(side="left", padx=5)
        tk.Button(btn_frame, text="📊 统计分析", command=self.show_stats,
                  font=(CHINESE_FONT, 11), bg="#38a169", fg="white",
                  relief="flat", padx=12, pady=4).pack(side="left", padx=5)
        tk.Button(btn_frame, text="💾 导出Excel", command=self.export_excel,
                  font=(CHINESE_FONT, 11), bg="#d69e2e", fg="white",
                  relief="flat", padx=12, pady=4).pack(side="left", padx=5)
        
        # 表格
        cols = ("姓名", "日期", "上班打卡", "下班打卡", "工时(h)", "状态")
        self.tree = ttk.Treeview(root, columns=cols, show="headings", height=14)
        for c in cols:
            self.tree.heading(c, text=c)
            self.tree.column(c, width=120, anchor="center")
        self.tree.pack(padx=20, pady=8, fill="both", expand=True)
        
        # 颜色标签
        self.tree.tag_configure("late", background="#fed7d7")
        self.tree.tag_configure("early", background="#fefcbf")
        self.tree.tag_configure("absent", background="#e2e8f0")
        self.tree.tag_configure("normal", background="#c6f6d5")
        
        # 状态栏
        self.status = tk.Label(root, text="就绪 - 请导入打卡记录CSV文件",
                               font=(CHINESE_FONT, 10), bg="#f0f4f8", fg="#718096")
        self.status.pack(pady=5)
        
        # 自动加载示例数据
        sample = os.path.join(os.path.dirname(os.path.abspath(__file__)), "attendance.csv")
        if os.path.exists(sample):
            self.load_csv_file(sample)
    
    def load_csv(self):
        path = filedialog.askopenfilename(filetypes=[("CSV文件", "*.csv")])
        if path:
            self.load_csv_file(path)
    
    def load_csv_file(self, path):
        """读取CSV并分析考勤状态"""
        self.tree.delete(*self.tree.get_children())
        self.records = []
        try:
            with open(path, "r", encoding="utf-8-sig") as f:
                reader = csv.DictReader(f)
                for row in reader:
                    name = row.get("姓名", "")
                    date = row.get("日期", "")
                    clock_in = row.get("上班打卡", "")
                    clock_out = row.get("下班打卡", "")
                    # 计算工时
                    hours = self.calc_hours(clock_in, clock_out)
                    # 判断状态
                    status = self.check_status(clock_in, clock_out)

💡 适用场景

HR考勤管理、行政部门数据统计、企业人事管理