def setup_theme(self):
    """專業(yè)級(jí)UI主題配置"""
    style = ttk.Style()
    primary_color = "#7B1FA2"  # 主色調(diào)紫色
    style.theme_create("custom_theme", settings={
        "TButton": {
            "configure": {"background": primary_color},
            "map": {"background": [("active", "#9C27B0")]}
        },
        # 其他組件樣式配置...
    })

pip install xlwings==0.28.1 tkinter ttkthemes

def __init__(self, master):
    self.master = master
    self.setup_theme()  # 初始化UI主題
    self.create_main_interface()  # 構(gòu)建界面
    self.center_window()  # 窗口居中

def build_image_map_from_folder(self, folder_path):
    """構(gòu)建圖片名稱到路徑的映射字典"""
    image_map = {}
    for root, _, files in os.walk(folder_path):
        for file in files:
            if file.lower().endswith(('.jpg', '.png')):
                name = os.path.splitext(file)[0].lower()
                image_map[name] = os.path.join(root, file)
    return image_map

def excel_operation(self, excel_file=None):
    """智能Excel實(shí)例管理"""
    app = xw.apps.active or xw.App(visible=True)
    if excel_file:
        return app.books.open(excel_file)
    return app.books.active

def insert_image(self, ws, image_path, cell_addr, margin):
    """帶邊距計(jì)算的智能插入"""
    cell = ws.range(cell_addr)
    ws.pictures.add(
        image_path,
        left=cell.left + margin,
        top=cell.top + margin,
        width=cell.width - 2*margin,
        height=cell.height - 2*margin
    )

# 列匹配算法
for row in range(start_row, max_row):
 name = ws.range(f"{match_col}{row}").value
 if name.lower() in image_map:
     self.insert_image(ws, image_map[name], f"{insert_col}{row}")

# 行匹配算法
for col in range(1, max_col):
 cell = f"{xw.utils.col_name(col)}{match_row}"
 name = ws.range(cell).value
 if name.lower() in image_map:
     self.insert_image(ws, image_map[name], 
                     f"{xw.utils.col_name(col)}{insert_row}")

try:
 # 執(zhí)行核心操作
except PermissionError:
 self.log_message("錯(cuò)誤：Excel文件被鎖定，請關(guān)閉文件后重試", tags="error")
except Exception as e:
 self.log_message(f"系統(tǒng)錯(cuò)誤：{str(e)}", tags="error")
 messagebox.showerror("致命錯(cuò)誤", str(e))

import os
import re
import tkinter as tk
import webbrowser
from tkinter import filedialog, messagebox, ttk
from typing import Dict, Optional, Tuple

import xlwings as xw


class ExcelImageMatcherPro:
    def __init__(self, master):
        self.master = master
        master.title("Excel批量匹配插圖工具")
        master.geometry("600x700")
        
        # 應(yīng)用主題和配色方案
        self.setup_theme()
        
        # 初始化變量
        self.col_image_map: Dict[str, str] = {}
        self.row_image_map: Dict[str, str] = {}
        self.topmost_var = tk.BooleanVar(value=True)
        
        # 創(chuàng)建主界面
        self.create_main_interface()
        
        # 窗口居中
        self.center_window(master)
        
        # 初始化幫助系統(tǒng)
        self._create_help_tags()
        self.show_help_guide()
        
        # 綁定事件
        self.notebook.bind("<<NotebookTabChanged>>", self.on_tab_changed)
        master.attributes('-topmost', self.topmost_var.get())

    def setup_theme(self):
        """設(shè)置應(yīng)用主題和配色方案"""
        style = ttk.Style()
        
        # 主色調(diào) - 紫色系
        primary_color = "#7B1FA2"
        secondary_color = "#9C27B0"
        accent_color = "#E1BEE7"
        
        # 文本顏色
        text_color = "#333333"
        light_text = "#FFFFFF"
        
        # 狀態(tài)顏色
        success_color = "#4CAF50"
        warning_color = "#FFC107"
        error_color = "#F44336"
        info_color = "#2196F3"
        
        # 配置主題
        style.theme_create("custom_theme", parent="clam", settings={
            "TFrame": {"configure": {"background": "#F5F5F5"}},
            "TLabel": {"configure": {"foreground": text_color, "background": "#F5F5F5", "font": ('Microsoft YaHei', 9)}},
            "TButton": {
                "configure": {
                    "foreground": light_text,
                    "background": primary_color,
                    "font": ('Microsoft YaHei', 9),
                    "padding": 5,
                    "borderwidth": 1,
                    "relief": "raised"
                },
                "map": {
                    "background": [("active", secondary_color), ("disabled", "#CCCCCC")],
                    "foreground": [("disabled", "#999999")]
                }
            },
            "TEntry": {
                "configure": {
                    "fieldbackground": "white",
                    "foreground": text_color,
                    "insertcolor": text_color,
                    "font": ('Microsoft YaHei', 9)
                }
            },
            "TCombobox": {
                "configure": {
                    "fieldbackground": "white",
                    "foreground": text_color,
                    "selectbackground": accent_color,
                    "font": ('Microsoft YaHei', 9)
                }
            },
            "TNotebook": {
                "configure": {
                    "background": "#F5F5F5",
                    "tabmargins": [2, 5, 2, 0]
                }
            },
            "TNotebook.Tab": {
                "configure": {
                    "background": "#E0E0E0",
                    "foreground": text_color,
                    "padding": [10, 5],
                    "font": ('Microsoft YaHei', 9, 'bold')
                },
                "map": {
                    "background": [("selected", "#FFFFFF"), ("active", "#EEEEEE")],
                    "expand": [("selected", [1, 1, 1, 0])]
                }
            },
            "TScrollbar": {
                "configure": {
                    "background": "#E0E0E0",
                    "troughcolor": "#F5F5F5",
                    "arrowcolor": text_color
                }
            },
            "Horizontal.TProgressbar": {
                "configure": {
                    "background": primary_color,
                    "troughcolor": "#E0E0E0",
                    "borderwidth": 0,
                    "lightcolor": primary_color,
                    "darkcolor": primary_color
                }
            }
        })
        style.theme_use("custom_theme")

    def create_main_interface(self):
        """創(chuàng)建主界面組件"""
        # 主容器
        main_frame = ttk.Frame(self.master)
        main_frame.pack(fill="both", expand=True, padx=10, pady=10)
        
        # 標(biāo)題欄
        title_frame = ttk.Frame(main_frame)
        title_frame.pack(fill="x", pady=(0, 10))
        
        title_label = ttk.Label(
            title_frame, 
            text="Excel批量匹配插圖工具", 
            font=('Microsoft YaHei', 12, 'bold'),
            foreground="#7B1FA2"
        )
        title_label.pack(side="left")
        
        # 標(biāo)簽頁控件
        self.notebook = ttk.Notebook(main_frame)
        self.notebook.pack(fill="both", expand=True)
        
        # 創(chuàng)建兩個(gè)標(biāo)簽頁
        self.create_column_tab()
        self.create_row_tab()
        
        # 狀態(tài)欄
        self.create_status_bar()

    def create_column_tab(self):
        """創(chuàng)建列匹配模式標(biāo)簽頁"""
        tab = ttk.Frame(self.notebook)
        self.notebook.add(tab, text="列匹配模式")
        
        # 描述區(qū)域
        desc_frame = ttk.LabelFrame(
            tab, 
            text="說明", 
            padding=10,
            style="Custom.TLabelframe"
        )
        desc_frame.pack(fill="x", padx=5, pady=5)
        
        ttk.Label(
            desc_frame, 
            text="列匹配模式：按垂直方向匹配插入，適合單列數(shù)據(jù)匹配。\n圖片名稱需與指定列中的單元格內(nèi)容完全匹配。",
            foreground="#616161",
            font=('Microsoft YaHei', 9)
        ).pack(anchor="w")
        
        # Excel文件選擇區(qū)域
        excel_frame = ttk.LabelFrame(tab, text="Excel文件設(shè)置", padding=10)
        excel_frame.pack(fill="x", padx=5, pady=5)
        
        self.col_excel_var = tk.StringVar(value="使用當(dāng)前活動(dòng)工作簿")
        ttk.Label(excel_frame, text="Excel文件:").grid(row=0, column=0, padx=5, pady=5, sticky="e")
        
        excel_entry = ttk.Entry(
            excel_frame, 
            textvariable=self.col_excel_var, 
            width=40,
            state="readonly",
            style="Custom.TEntry"
        )
        excel_entry.grid(row=0, column=1, padx=5, pady=5, sticky="ew")
        
        btn_frame = ttk.Frame(excel_frame)
        btn_frame.grid(row=0, column=2, padx=5, pady=5, sticky="e")
        
        ttk.Button(
            btn_frame, 
            text="瀏覽...", 
            command=lambda: self.select_excel_file(self.col_excel_var),
            style="Accent.TButton"
        ).pack(side="left", padx=2)
        
        ttk.Button(
            btn_frame, 
            text="清除", 
            command=lambda: self.col_excel_var.set("使用當(dāng)前活動(dòng)工作簿")
        ).pack(side="left", padx=2)
        
        # 參數(shù)設(shè)置區(qū)域
        param_frame = ttk.LabelFrame(tab, text="匹配參數(shù)設(shè)置", padding=10)
        param_frame.pack(fill="x", padx=5, pady=5)
        
        # 第一行參數(shù)
        row1_frame = ttk.Frame(param_frame)
        row1_frame.pack(fill="x", pady=5)
        
        ttk.Label(row1_frame, text="起始行號(hào):").pack(side="left", padx=5)
        self.col_start_row = ttk.Entry(row1_frame, width=8)
        self.col_start_row.pack(side="left", padx=5)
        self.col_start_row.insert(0, "2")
        
        ttk.Label(row1_frame, text="匹配列:").pack(side="left", padx=5)
        self.col_match = ttk.Entry(row1_frame, width=8)
        self.col_match.pack(side="left", padx=5)
        self.col_match.insert(0, "A")
        
        ttk.Label(row1_frame, text="插入列:").pack(side="left", padx=5)
        self.col_insert = ttk.Entry(row1_frame, width=8)
        self.col_insert.pack(side="left", padx=5)
        self.col_insert.insert(0, "B")
        
        # 第二行參數(shù)
        row2_frame = ttk.Frame(param_frame)
        row2_frame.pack(fill="x", pady=5)
        
        ttk.Label(row2_frame, text="邊距:").pack(side="left", padx=5)
        self.col_margin = ttk.Entry(row2_frame, width=8)
        self.col_margin.pack(side="left", padx=5)
        self.col_margin.insert(0, "2")
        
        # 圖片文件夾選擇
        folder_frame = ttk.Frame(param_frame)
        folder_frame.pack(fill="x", pady=10)
        
        self.col_folder_var = tk.StringVar()
        ttk.Label(folder_frame, text="圖片文件夾:").pack(side="left", padx=5)
        
        folder_entry = ttk.Entry(
            folder_frame, 
            textvariable=self.col_folder_var, 
            width=40,
            state="readonly"
        )
        folder_entry.pack(side="left", padx=5, expand=True, fill="x")
        
        ttk.Button(
            folder_frame, 
            text="瀏覽...", 
            command=lambda: self.select_folder(self.col_folder_var, mode="column"),
            style="Accent.TButton"
        ).pack(side="left", padx=5)
        
        # 執(zhí)行按鈕
        btn_frame = ttk.Frame(tab)
        btn_frame.pack(fill="x", padx=5, pady=10)
        
        ttk.Button(
            btn_frame, 
            text="執(zhí)行列匹配插入", 
            command=self.run_column_match,
            style="Primary.TButton"
        ).pack(fill="x", expand=True)
        
        # 日志區(qū)域
        log_frame = ttk.LabelFrame(tab, text="操作日志", padding=10)
        log_frame.pack(fill="both", expand=True, padx=5, pady=5)
        
        self.col_log = tk.Text(
            log_frame, 
            wrap=tk.WORD, 
            height=10,
            state="disabled", 
            font=('Microsoft YaHei', 9),
            bg="white",
            fg="#333333",
            padx=5,
            pady=5
        )
        
        scroll = ttk.Scrollbar(log_frame, command=self.col_log.yview)
        self.col_log.configure(yscrollcommand=scroll.set)
        
        self.col_log.pack(side="left", fill="both", expand=True)
        scroll.pack(side="right", fill="y")

    def create_row_tab(self):
        """創(chuàng)建行匹配模式標(biāo)簽頁"""
        tab = ttk.Frame(self.notebook)
        self.notebook.add(tab, text="行匹配模式")
        
        # 描述區(qū)域
        desc_frame = ttk.LabelFrame(tab, text="說明", padding=10)
        desc_frame.pack(fill="x", padx=5, pady=5)
        
        ttk.Label(
            desc_frame, 
            text="行匹配模式：按水平方向匹配插入，適合單行數(shù)據(jù)匹配。\n圖片名稱需與指定行中的單元格內(nèi)容完全匹配。",
            foreground="#616161",
            font=('Microsoft YaHei', 9)
        ).pack(anchor="w")
        
        # Excel文件選擇區(qū)域
        excel_frame = ttk.LabelFrame(tab, text="Excel文件設(shè)置", padding=10)
        excel_frame.pack(fill="x", padx=5, pady=5)
        
        self.row_excel_var = tk.StringVar(value="使用當(dāng)前活動(dòng)工作簿")
        ttk.Label(excel_frame, text="Excel文件:").grid(row=0, column=0, padx=5, pady=5, sticky="e")
        
        excel_entry = ttk.Entry(
            excel_frame, 
            textvariable=self.row_excel_var, 
            width=40,
            state="readonly"
        )
        excel_entry.grid(row=0, column=1, padx=5, pady=5, sticky="ew")
        
        btn_frame = ttk.Frame(excel_frame)
        btn_frame.grid(row=0, column=2, padx=5, pady=5, sticky="e")
        
        ttk.Button(
            btn_frame, 
            text="瀏覽...", 
            command=lambda: self.select_excel_file(self.row_excel_var),
            style="Accent.TButton"
        ).pack(side="left", padx=2)
        
        ttk.Button(
            btn_frame, 
            text="清除", 
            command=lambda: self.row_excel_var.set("使用當(dāng)前活動(dòng)工作簿")
        ).pack(side="left", padx=2)
        
        # 參數(shù)設(shè)置區(qū)域
        param_frame = ttk.LabelFrame(tab, text="匹配參數(shù)設(shè)置", padding=10)
        param_frame.pack(fill="x", padx=5, pady=5)
        
        # 參數(shù)行
        row_frame = ttk.Frame(param_frame)
        row_frame.pack(fill="x", pady=10)
        
        ttk.Label(row_frame, text="匹配行:").pack(side="left", padx=5)
        self.row_match = ttk.Entry(row_frame, width=8)
        self.row_match.pack(side="left", padx=5)
        self.row_match.insert(0, "1")
        
        ttk.Label(row_frame, text="插入行:").pack(side="left", padx=5)
        self.row_insert = ttk.Entry(row_frame, width=8)
        self.row_insert.pack(side="left", padx=5)
        self.row_insert.insert(0, "2")
        
        ttk.Label(row_frame, text="邊距:").pack(side="left", padx=5)
        self.row_margin = ttk.Entry(row_frame, width=8)
        self.row_margin.pack(side="left", padx=5)
        self.row_margin.insert(0, "2")
        
        # 圖片文件夾選擇
        folder_frame = ttk.Frame(param_frame)
        folder_frame.pack(fill="x", pady=10)
        
        self.row_folder_var = tk.StringVar()
        ttk.Label(folder_frame, text="圖片文件夾:").pack(side="left", padx=5)
        
        folder_entry = ttk.Entry(
            folder_frame, 
            textvariable=self.row_folder_var, 
            width=40,
            state="readonly"
        )
        folder_entry.pack(side="left", padx=5, expand=True, fill="x")
        
        ttk.Button(
            folder_frame, 
            text="瀏覽...", 
            command=lambda: self.select_folder(self.row_folder_var, mode="row"),
            style="Accent.TButton"
        ).pack(side="left", padx=5)
        
        # 執(zhí)行按鈕
        btn_frame = ttk.Frame(tab)
        btn_frame.pack(fill="x", padx=5, pady=10)
        
        ttk.Button(
            btn_frame, 
            text="執(zhí)行行匹配插入", 
            command=self.run_row_match,
            style="Primary.TButton"
        ).pack(fill="x", expand=True)
        
        # 日志區(qū)域
        log_frame = ttk.LabelFrame(tab, text="操作日志", padding=10)
        log_frame.pack(fill="both", expand=True, padx=5, pady=5)
        
        self.row_log = tk.Text(
            log_frame, 
            wrap=tk.WORD, 
            height=10,
            state="disabled", 
            font=('Microsoft YaHei', 9),
            bg="white",
            fg="#333333",
            padx=5,
            pady=5
        )
        
        scroll = ttk.Scrollbar(log_frame, command=self.row_log.yview)
        self.row_log.configure(yscrollcommand=scroll.set)
        
        self.row_log.pack(side="left", fill="both", expand=True)
        scroll.pack(side="right", fill="y")

    def create_status_bar(self):
        """創(chuàng)建狀態(tài)欄"""
        status_frame = ttk.Frame(self.master, padding=(10, 5))
        status_frame.pack(side="bottom", fill="x")
        
        # 窗口置頂按鈕
        ttk.Checkbutton(
            status_frame, 
            text="窗口置頂", 
            variable=self.topmost_var,
            command=lambda: self.master.attributes('-topmost', self.topmost_var.get())
        ).pack(side="left", padx=(0, 10))
        
        # 幫助按鈕
        ttk.Button(
            status_frame, 
            text="幫助", 
            width=8,
            command=self.show_help_guide
        ).pack(side="left", padx=(0, 10))
        
        # 版本信息
        version_label = ttk.Label(
            status_frame, 
            text="版本: 1.0.0", 
            foreground="gray"
        )
        version_label.pack(side="left", padx=(0, 10))
        
        # 作者信息
        author_label = tk.Label(
            status_frame, 
            text="By 創(chuàng)客白澤", 
            fg="gray", 
            cursor="hand2",
            font=('Microsoft YaHei', 9)
        )
        author_label.bind("<Enter>", lambda e: author_label.config(fg="#7B1FA2"))
        author_label.bind("<Leave>", lambda e: author_label.config(fg="gray"))
        author_label.bind(
            "<Button-1>", 
            lambda e: webbrowser.open("https://www.52pojie.cn/thread-2030255-1-1.html")
        )
        author_label.pack(side="right")

    def _create_help_tags(self):
        """創(chuàng)建日志文本標(biāo)簽樣式"""
        for log in [self.col_log, self.row_log]:
            log.tag_config("title", foreground="#7B1FA2", font=('Microsoft YaHei', 10, 'bold'))
            log.tag_config("success", foreground="#4CAF50")
            log.tag_config("warning", foreground="#FF9800")
            log.tag_config("error", foreground="#F44336")
            log.tag_config("info", foreground="#2196F3")
            log.tag_config("preview", foreground="#616161")
            log.tag_config("highlight", background="#E1BEE7")

    def center_window(self, window):
        """窗口居中顯示"""
        window.update_idletasks()
        width = window.winfo_width()
        height = window.winfo_height()
        screen_width = window.winfo_screenwidth()
        screen_height = window.winfo_screenheight()
        x = (screen_width - width) // 2
        y = (screen_height - height) // 2
        window.geometry(f"{width}x{height}+{x}+{y}")

    def show_help_guide(self, target_log=None):
        """顯示幫助指南"""
        help_text = """【新手操作指南 - 點(diǎn)下方"幫助"按鈕可再次顯示】

1. 準(zhǔn)備工作：
    - 選擇Excel文件或使用當(dāng)前活動(dòng)工作簿
    - 準(zhǔn)備圖片文件夾（支持jpg/png/webp/bmp格式）

2. 參數(shù)設(shè)置：
    - Excel文件：選擇要操作的工作簿（可選）
    - 起始行號(hào)：從哪一行開始匹配（默認(rèn)為2）
    - 匹配列/行：包含名稱的列或行（如A列或1行）
    - 插入列/行：圖片要插入的位置（如B列或2行）
    - 邊距：圖片與單元格邊界的距離（推薦2，0表示撐滿）

3. 執(zhí)行步驟：
    (1) 選擇Excel文件（可選）
    (2) 選擇圖片文件夾
    (3) 點(diǎn)擊"執(zhí)行匹配插入"按鈕

★ 注意事項(xiàng)：
    - 圖片名稱需與單元格內(nèi)容完全一致（不區(qū)分大小寫）
    - 示例：單元格"產(chǎn)品A" → 圖片"產(chǎn)品A.jpg"
    - 插入過程中請不要操作Excel
    """

        if target_log is None:
            current_tab = self.notebook.index("current")
            target_log = self.col_log if current_tab == 0 else self.row_log

        self.log_message(help_text, target_log, append=False, tags="info")

    def select_excel_file(self, var_tk_stringvar):
        """選擇Excel文件"""
        file_path = filedialog.askopenfilename(
            filetypes=[("Excel文件", "*.xls *.xlsx *.xlsm"), ("所有文件", "*.*")])
        if file_path:
            var_tk_stringvar.set(file_path)

    def select_folder(self, var_tk_stringvar, mode):
        """選擇圖片文件夾"""
        folder_path = filedialog.askdirectory()
        if folder_path:
            var_tk_stringvar.set(folder_path)
            log_widget = self.col_log if mode == "column" else self.row_log

            self.log_message("開始加載圖片...", log_widget, append=False)

            current_image_map = self.build_image_map_from_folder(folder_path)

            if mode == "column":
                self.col_image_map = current_image_map
            elif mode == "row":
                self.row_image_map = current_image_map

            if len(current_image_map) > 0:
                self.log_message(
                    f"加載完成：找到 {len(current_image_map)} 張支持的圖片。", 
                    log_widget,
                    tags="success"
                )
            else:
                self.log_message("警告: 未找到任何支持的圖片文件。", log_widget, tags="warning")

            self.preview_insert_positions(mode)

    def build_image_map_from_folder(self, folder_path: str) -> Dict[str, str]:
        """從文件夾構(gòu)建圖片名稱到路徑的映射"""
        image_map: Dict[str, str] = {}
        extensions = ('.jpg', '.jpeg', '.png', '.bmp', '.webp')
        try:
            for root, _, files in os.walk(folder_path):
                for file in files:
                    if file.lower().endswith(extensions):
                        name_without_ext = os.path.splitext(file)[0].strip().lower()
                        image_map[name_without_ext] = os.path.abspath(os.path.join(root, file))
        except Exception as e:
            self.log_message(
                f"構(gòu)建圖片映射出錯(cuò): {e}", 
                self.col_log if 'col' in self._current_mode else self.row_log,
                tags="error"
            )
        return image_map

    def validate_column_params(self) -> Dict:
        """驗(yàn)證列匹配參數(shù)"""
        params = {
            'match_col': self.col_match.get().upper(),
            'insert_col': self.col_insert.get().upper(),
            'start_row': self.col_start_row.get(),
            'margin': self.col_margin.get(),
            'excel_file': self.col_excel_var.get()
        }
        if not re.match(r'^[A-Z]{1,3}$', params['match_col']):
            raise ValueError("匹配列格式錯(cuò)誤 (例如: A, B, AA)")
        if not re.match(r'^[A-Z]{1,3}$', params['insert_col']):
            raise ValueError("插入列格式錯(cuò)誤 (例如: A, B, AA)")
        if not params['start_row'].isdigit() or int(params['start_row']) < 1:
            raise ValueError("起始行號(hào)必須是大于0的數(shù)字")
        if not params['margin'].isdigit() or int(params['margin']) < 0:
            raise ValueError("邊距必須是非負(fù)數(shù)字")
        return {
            'match_col': params['match_col'],
            'insert_col': params['insert_col'],
            'start_row': int(params['start_row']),
            'margin': int(params['margin']),
            'excel_file': params['excel_file']
        }

    def validate_row_params(self) -> Dict:
        """驗(yàn)證行匹配參數(shù)"""
        params = {
            'match_row': self.row_match.get(),
            'insert_row': self.row_insert.get(),
            'margin': self.row_margin.get(),
            'excel_file': self.row_excel_var.get()
        }
        if not params['match_row'].isdigit() or int(params['match_row']) < 1:
            raise ValueError("匹配行必須是大于0的數(shù)字")
        if not params['insert_row'].isdigit() or int(params['insert_row']) < 1:
            raise ValueError("插入行必須是大于0的數(shù)字")
        if not params['margin'].isdigit() or int(params['margin']) < 0:
            raise ValueError("邊距必須是非負(fù)數(shù)字")
        return {
            'match_row': int(params['match_row']),
            'insert_row': int(params['insert_row']),
            'margin': int(params['margin']),
            'excel_file': params['excel_file']
        }

    def get_excel_app(self) -> xw.App:
        """獲取Excel應(yīng)用實(shí)例，優(yōu)先使用已打開的實(shí)例"""
        try:
            # 嘗試獲取已打開的Excel應(yīng)用
            app = xw.apps.active
            if app is not None:
                return app
            
            # 如果沒有打開的Excel，嘗試獲取第一個(gè)Excel實(shí)例
            if len(xw.apps) > 0:
                return xw.apps[0]
                
            # 如果都沒有，則創(chuàng)建新實(shí)例
            return xw.App(visible=True)
        except Exception as e:
            raise Exception(f"無法獲取Excel應(yīng)用實(shí)例: {str(e)}")

    def excel_operation(self, excel_file: Optional[str] = None) -> Tuple[xw.Book, xw.Sheet]:
        """Excel操作上下文管理器，正確處理已打開的工作簿"""
        app = self.get_excel_app()
        
        try:
            if excel_file and excel_file != "使用當(dāng)前活動(dòng)工作簿":
                # 檢查工作簿是否已經(jīng)打開
                for book in app.books:
                    if book.fullname.lower() == os.path.abspath(excel_file).lower():
                        wb = book
                        break
                else:
                    wb = app.books.open(excel_file)
            else:
                # 使用活動(dòng)工作簿或第一個(gè)工作簿
                wb = app.books.active
                if wb is None and len(app.books) > 0:
                    wb = app.books[0]
                if wb is None:
                    raise Exception("沒有可用的工作簿，請先打開或創(chuàng)建一個(gè)工作簿")
            
            ws = wb.sheets.active
            if ws is None:
                raise Exception("工作簿中沒有活動(dòng)的工作表")
            
            return wb, ws
        except Exception as e:
            raise Exception(f"Excel操作錯(cuò)誤: {str(e)}")

    def insert_image(self, ws, image_path, cell_addr, margin, log_widget):
        """在Excel中插入圖片"""
        try:
            abs_image_path = os.path.abspath(image_path)
            if not os.path.exists(abs_image_path):
                self.log_message(f"錯(cuò)誤: 圖片文件不存在 - {abs_image_path}", log_widget, tags="error")
                return False

            target_cell = ws.range(cell_addr)

            left = target_cell.left + margin
            top = target_cell.top + margin
            width = target_cell.width - 2 * margin
            height = target_cell.height - 2 * margin

            ws.pictures.add(
                abs_image_path,
                left=left,
                top=top,
                width=width,
                height=height
            )
            return True

        except Exception as e:
            error_msg = f"插入圖片失敗: {str(e)}"
            self.log_message(error_msg, log_widget, tags="error")
            return False

    def run_column_match(self):
        """執(zhí)行列匹配插入"""
        self.log_message("開始列匹配處理...", self.col_log, append=False, tags="title")
        try:
            if not self.col_folder_var.get():
                messagebox.showwarning("提示", "請先選擇圖片文件夾！")
                self.log_message("錯(cuò)誤: 未選擇圖片文件夾。", self.col_log, tags="error")
                return

            params = self.validate_column_params()
            
            wb, ws = self.excel_operation(params['excel_file'])
            max_row = ws.used_range.last_cell.row
            success_inserts = 0
            processed_excel_rows = 0
            non_empty_match_cells = 0

            self.log_message(
                f"將在列 {params['match_col']} 中查找名稱，圖片插入到列 {params['insert_col']}，從行 {params['start_row']} 開始。",
                self.col_log,
                tags="info"
            )

            for row_num_excel in range(params['start_row'], max_row + 1):
                processed_excel_rows += 1
                match_cell_addr = f"{params['match_col']}{row_num_excel}"

                cell_value = ws.range(match_cell_addr).value
                name_to_match = str(cell_value).strip() if cell_value is not None else ""

                if not name_to_match:
                    continue

                non_empty_match_cells += 1
                insert_cell_addr = f"{params['insert_col']}{row_num_excel}"
                lower_name_to_match = name_to_match.lower()

                if lower_name_to_match in self.col_image_map:
                    image_file_path = os.path.abspath(self.col_image_map[lower_name_to_match])
                    if not os.path.exists(image_file_path):
                        self.log_message(
                            f"錯(cuò)誤: 圖片文件不存在 - {image_file_path}",
                            self.col_log,
                            tags="error"
                        )
                        continue

                    if self.insert_image(ws, image_file_path, insert_cell_addr, params['margin'], self.col_log):
                        success_inserts += 1
                        self.log_message(
                            f"{match_cell_addr}：{name_to_match} → {insert_cell_addr}：{os.path.basename(image_file_path)}",
                            self.col_log,
                            tags="success"
                        )
                else:
                    self.log_message(
                        f"{match_cell_addr}：{name_to_match} → 未找到匹配圖片",
                        self.col_log,
                        tags="warning"
                    )

            summary = f"\n共處理 {processed_excel_rows} 行數(shù)據(jù)，成功插入 {success_inserts} 張圖片。"
            self.log_message(summary, self.col_log, tags="info")

        except Exception as e:
            error_msg = f"列匹配錯(cuò)誤: {str(e)}"
            self.log_message(error_msg, self.col_log, tags="error")
            messagebox.showerror("錯(cuò)誤", error_msg)

    def run_row_match(self):
        """執(zhí)行行匹配插入"""
        self.log_message("開始行匹配處理...", self.row_log, append=False, tags="title")
        try:
            if not self.row_folder_var.get():
                messagebox.showwarning("提示", "請先選擇圖片文件夾！")
                self.log_message("錯(cuò)誤: 未選擇圖片文件夾。", self.row_log, tags="error")
                return

            params = self.validate_row_params()
            
            wb, ws = self.excel_operation(params['excel_file'])
            max_col = ws.used_range.last_cell.column
            success_inserts = 0
            processed_excel_cols = 0
            non_empty_match_cells = 0

            self.log_message(
                f"將在行 {params['match_row']} 中查找名稱，圖片插入到行 {params['insert_row']}。",
                self.row_log,
                tags="info"
            )

            for col_num_excel in range(1, max_col + 1):
                processed_excel_cols += 1
                match_cell_addr = f"{xw.utils.col_name(col_num_excel)}{params['match_row']}"

                cell_value = ws.range(match_cell_addr).value
                name_to_match = str(cell_value).strip() if cell_value is not None else ""

                if not name_to_match:
                    continue

                non_empty_match_cells += 1
                insert_cell_addr = f"{xw.utils.col_name(col_num_excel)}{params['insert_row']}"
                lower_name_to_match = name_to_match.lower()

                if lower_name_to_match in self.row_image_map:
                    image_file_path = os.path.abspath(self.row_image_map[lower_name_to_match])
                    if not os.path.exists(image_file_path):
                        self.log_message(
                            f"錯(cuò)誤: 圖片文件不存在 - {image_file_path}",
                            self.row_log,
                            tags="error"
                        )
                        continue

                    if self.insert_image(ws, image_file_path, insert_cell_addr, params['margin'], self.row_log):
                        success_inserts += 1
                        self.log_message(
                            f"{match_cell_addr}：{name_to_match} → {insert_cell_addr}：{os.path.basename(image_file_path)}",
                            self.row_log,
                            tags="success"
                        )
                else:
                    self.log_message(
                        f"{match_cell_addr}：{name_to_match} → 未找到匹配圖片",
                        self.row_log,
                        tags="warning"
                    )

            summary = f"\n共處理 {processed_excel_cols} 列數(shù)據(jù)，成功插入 {success_inserts} 張圖片。"
            self.log_message(summary, self.row_log, tags="info")

        except Exception as e:
            error_msg = f"行匹配錯(cuò)誤: {str(e)}"
            self.log_message(error_msg, self.row_log, tags="error")
            messagebox.showerror("錯(cuò)誤", error_msg)

    def preview_insert_positions(self, mode):
        """預(yù)覽插入位置"""
        image_map = self.col_image_map if mode == "column" else self.row_image_map
        log_widget = self.col_log if mode == "column" else self.row_log

        if not image_map:
            self.log_message("沒有圖片可供預(yù)覽。請先選擇圖片文件夾。", log_widget, tags="warning")
            return

        self.log_message("【插入位置預(yù)覽】", log_widget, tags="title")
        for name, path in image_map.items():
            self.log_message(
                f"{name} -> {os.path.basename(path)}", 
                log_widget, 
                tags="preview"
            )

    def log_message(self, message, log_widget, append=True, tags=None, clear=False):
        """記錄日志消息"""
        log_widget.config(state="normal")
        if clear:
            log_widget.delete(1.0, tk.END)
        if not append:
            log_widget.delete(1.0, tk.END)
        log_widget.insert(tk.END, message + "\n", tags)
        log_widget.see(tk.END)
        log_widget.config(state="disabled")

    def on_tab_changed(self, event):
        """標(biāo)簽頁切換事件處理"""
        self.show_help_guide()


if __name__ == "__main__":
    root = tk.Tk()
    app = ExcelImageMatcherPro(root)
    root.mainloop()