一个在wps复制表格后直接存储图片到指定位置的工具，无需中转微信复制为图片再另存为
https://download.csdn.net/download/z1696853278/92959326
功能特点
- Excel 复制的excel区域后，直接存储剪贴板的 PNG 图片到文件夹
- 支持自定义输出路径和自定义图片命名
- 图形界面操作，简单易用
- 支持托盘图标后台运行
- 支持Windows托盘气泡通知
代码
#cmd: & "D:\Program Files\Python313\python.exe" -m PyInstaller --onefile --noconsole --clean --collect-submodules PIL --collect-binaries PIL --hidden-import pystray --hidden-import win32clipboard --hidden-import win32ui --hidden-import win32gui --hidden-import win32con --hidden-import PIL._imaging --collect-data sv_ttk --noupx "wpsexceltopng.py" import os import sys import time import io import threading import queue from datetime import datetime import tkinter as tk from tkinter import ttk, filedialog, messagebox import sv_ttk # Win11 风格主题 import win32clipboard import win32ui import win32gui import win32con from PIL import Image, ImageDraw from pystray import Icon, Menu, MenuItem # ----------------------------- 剪贴板工具函数 ----------------------------- def get_clipboard_format_names(): names = [] try: win32clipboard.OpenClipboard() fmt = 0 while True: fmt = win32clipboard.EnumClipboardFormats(fmt) if fmt == 0: break try: name = win32clipboard.GetClipboardFormatName(fmt) except: name = "" if name: names.append(name) finally: win32clipboard.CloseClipboard() return names def is_wps_clipboard(): for name in get_clipboard_format_names(): upper = name.upper() if "KINGSOFT" in upper or "WPS" in upper: return True return False def hbitmap_to_pil(hbitmap): bmp = win32ui.CreateBitmap() bmp.Attach(hbitmap) info = bmp.GetInfo() width, height = info['bmWidth'], info['bmHeight'] bmp.Detach() hdc = win32gui.GetDC(0) mfc_dc = win32ui.CreateDCFromHandle(hdc) mem_dc = mfc_dc.CreateCompatibleDC() bmi = win32gui.GetObject(hbitmap, win32con.BITMAP) bits = bytearray(bmi.bmWidthBytes * bmi.bmHeight) win32gui.GetBitmapBits(hbitmap, len(bits), bits) mem_dc.DeleteDC() mfc_dc.DeleteDC() win32gui.ReleaseDC(0, hdc) return Image.frombuffer('RGB', (width, height), bytes(bits), 'raw', 'BGRX', 0, 1) def get_image_from_clipboard(): try: win32clipboard.OpenClipboard() if win32clipboard.IsClipboardFormatAvailable(win32clipboard.CF_DIBV5): data = win32clipboard.GetClipboardData(win32clipboard.CF_DIBV5) win32clipboard.CloseClipboard() return Image.open(io.BytesIO(data)) elif win32clipboard.IsClipboardFormatAvailable(win32clipboard.CF_DIB): data = win32clipboard.GetClipboardData(win32clipboard.CF_DIB) win32clipboard.CloseClipboard() return Image.open(io.BytesIO(data)) elif win32clipboard.IsClipboardFormatAvailable(win32clipboard.CF_BITMAP): hbitmap = win32clipboard.GetClipboardData(win32clipboard.CF_BITMAP) win32clipboard.CloseClipboard() return hbitmap_to_pil(hbitmap) else: win32clipboard.CloseClipboard() return None except: try: win32clipboard.CloseClipboard() except: pass return None # ----------------------------- 自定义文件名对话框 ----------------------------- class FilenameDialog(tk.Toplevel): def __init__(self, parent): super().__init__(parent) self.result = None self.title("保存图片") self.geometry("380x150") self.resizable(False, False) self.configure(bg="#2B2B2B" if sv_ttk.get_theme() == "dark" else "#F3F3F3") self.attributes('-topmost', True) self.grab_set() self.focus_force() frame = ttk.Frame(self, padding=20) frame.pack(fill=tk.BOTH, expand=True) ttk.Label(frame, text="请输入图片名称（不含扩展名，留空则自动命名）：").pack(anchor=tk.W, pady=(0,5)) self.name_var = tk.StringVar(value="") self.entry = ttk.Entry(frame, textvariable=self.name_var, width=40) self.entry.pack(fill=tk.X, pady=(0,15)) self.entry.focus_set() btn_frame = ttk.Frame(frame) btn_frame.pack(fill=tk.X) ttk.Button(btn_frame, text="确定", command=self._on_confirm, style="Accent.TButton").pack(side=tk.RIGHT, padx=(5,0)) ttk.Button(btn_frame, text="取消", command=self._on_cancel).pack(side=tk.RIGHT) self.protocol("WM_DELETE_WINDOW", self._on_cancel) self.bind("<Return>", lambda e: self._on_confirm()) self.bind("<Escape>", lambda e: self._on_cancel()) self.update_idletasks() w = self.winfo_width() h = self.winfo_height() x = parent.winfo_x() + (parent.winfo_width() - w) // 2 y = parent.winfo_y() + (parent.winfo_height() - h) // 2 self.geometry(f"+{x}+{y}") def _on_confirm(self): name = self.name_var.get().strip() self.result = name if name else None self.destroy() def _on_cancel(self): self.result = None self.destroy() # ----------------------------- GUI + 托盘 主程序 ----------------------------- class WpsImageSaverApp: def __init__(self, root): self.root = root root.title("WPS 表格图片自动保存 作者：朱梓练") root.geometry("680x550") root.minsize(600, 450) sv_ttk.set_theme("dark" if self._is_system_dark() else "light") self.save_dir = tk.StringVar(value=os.path.join(os.path.expanduser("~"), "Desktop", "WPS截图")) self.rename_enabled = tk.BooleanVar(value=False) self.monitoring = False self.monitor_thread = None self.stop_event = threading.Event() self.msg_queue = queue.Queue() self.tray_icon = None self.tray_running = False self._build_ui() self._poll_queue() self.root.protocol("WM_DELETE_WINDOW", self._on_window_close) def _is_system_dark(self): try: import winreg key = winreg.OpenKey(winreg.HKEY_CURRENT_USER, r"Software\Microsoft\Windows\CurrentVersion\Themes\Personalize") value, _ = winreg.QueryValueEx(key, "AppsUseLightTheme") return value == 0 except: return False def _build_ui(self): main_frame = ttk.Frame(self.root, padding=15) main_frame.pack(fill=tk.BOTH, expand=True) # --- 保存设置卡片 --- dir_frame = ttk.LabelFrame(main_frame, text="保存设置", padding=10) dir_frame.pack(fill=tk.X, pady=(0,10)) ttk.Label(dir_frame, text="图片保存路径：").grid(row=0, column=0, sticky=tk.W, pady=(0,5)) path_entry = ttk.Entry(dir_frame, textvariable=self.save_dir, width=60) path_entry.grid(row=1, column=0, padx=(0,5), sticky=tk.EW) ttk.Button(dir_frame, text="浏览...", command=self._browse_folder).grid(row=1, column=1) # ★ 新增“打开文件夹”按钮 ttk.Button(dir_frame, text="📂 打开文件夹", command=self._open_folder).grid(row=1, column=2, padx=(5,0)) dir_frame.columnconfigure(0, weight=1) ttk.Checkbutton( dir_frame, text="每次复制后弹出窗口自定义文件名", variable=self.rename_enabled ).grid(row=2, column=0, columnspan=3, sticky=tk.W, pady=(10,0)) # --- 控制栏 --- ctrl_frame = ttk.Frame(main_frame) ctrl_frame.pack(fill=tk.X, pady=(0,10)) self.start_btn = ttk.Button(ctrl_frame, text="开始监控", style="Accent.TButton", command=self._toggle_monitoring) self.start_btn.pack(side=tk.LEFT, padx=(0,10)) self.status_label = ttk.Label(ctrl_frame, text="● 未启动", foreground="gray") self.status_label.pack(side=tk.LEFT) # --- 日志区 --- log_frame = ttk.LabelFrame(main_frame, text="运行日志", padding=5) log_frame.pack(fill=tk.BOTH, expand=True) self.log_text = tk.Text(log_frame, height=12, width=80, state=tk.DISABLED, wrap=tk.WORD, bg="#1E1E1E" if sv_ttk.get_theme() == "dark" else "#FAFAFA", fg="#D4D4D4" if sv_ttk.get_theme() == "dark" else "#1E1E1E", insertbackground='white', borderwidth=0) scrollbar = ttk.Scrollbar(log_frame, orient=tk.VERTICAL, command=self.log_text.yview) self.log_text.configure(yscrollcommand=scrollbar.set) self.log_text.pack(side=tk.LEFT, fill=tk.BOTH, expand=True) scrollbar.pack(side=tk.RIGHT, fill=tk.Y) def _browse_folder(self): folder = filedialog.askdirectory(title="选择图片保存文件夹") if folder: self.save_dir.set(folder) def _open_folder(self): """在资源管理器中打开保存目录""" path = self.save_dir.get().strip() if not path: messagebox.showinfo("提示", "请先设置保存目录") return try: os.makedirs(path, exist_ok=True) os.startfile(path) except Exception as e: messagebox.showerror("错误", f"无法打开文件夹：{e}") def _toggle_monitoring(self): if not self.monitoring: path = self.save_dir.get().strip() if not path: messagebox.showerror("错误", "请先设置保存目录") return try: os.makedirs(path, exist_ok=True) except: messagebox.showerror("错误", f"无法创建目录：{path}") return self.monitoring = True self.stop_event.clear() self.monitor_thread = threading.Thread(target=self._monitor_loop, daemon=True) self.monitor_thread.start() self.start_btn.configure(text="停止监控") self.status_label.configure(text="● 监控中", foreground="#13A10E") self._log("监控已启动") if not self.tray_icon: self._start_tray() else: self.monitoring = False self.stop_event.set() self.start_btn.configure(text="开始监控") self.status_label.configure(text="● 已停止", foreground="gray") self._log("监控已停止") # ------------------- 托盘相关 ------------------- def _create_tray_image(self): img = Image.new("RGBA", (64, 64), (0, 0, 0, 0)) draw = ImageDraw.Draw(img) draw.ellipse([4, 4, 60, 60], fill=(0, 200, 83)) draw.polygon([(18, 32), (28, 44), (46, 20)], fill="white") return img def _tray_thread(self): # ★ 托盘菜单增加“打开保存文件夹” menu = Menu( MenuItem("显示窗口", self._show_window, default=True), MenuItem("打开保存文件夹", self._open_folder), MenuItem("退出", self._quit_from_tray) ) self.tray_icon = Icon("WPS_Saver", self._create_tray_image(), "WPS 图片自动保存", menu) self.tray_icon.run() def _start_tray(self): th = threading.Thread(target=self._tray_thread, daemon=True) th.start() def _show_window(self, icon=None, item=None): self.root.after(0, self.root.deiconify) def _on_window_close(self): if self.monitoring: self.root.withdraw() else: self._full_quit() def _quit_from_tray(self, icon=None, item=None): self._full_quit() def _full_quit(self): self.monitoring = False self.stop_event.set() if self.tray_icon: self.tray_icon.stop() self.root.destroy() os._exit(0) # ------------------- 监控与通知 ------------------- def _log(self, msg): self.msg_queue.put(("LOG", msg)) def _send_tray_notification(self, title, message): if self.tray_icon: try: self.tray_icon.notify(message, title=title) except: pass def _request_filename(self): event = threading.Event() result_container = [] self.msg_queue.put(("REQUEST_FILENAME", event, result_container)) event.wait() if result_container: return result_container[0] return None def _monitor_loop(self): last_seq = win32clipboard.GetClipboardSequenceNumber() while not self.stop_event.is_set(): time.sleep(0.2) if self.stop_event.is_set(): break try: current_seq = win32clipboard.GetClipboardSequenceNumber() if current_seq == last_seq: continue last_seq = current_seq if not is_wps_clipboard(): continue img = get_image_from_clipboard() if img is None: self._log("检测到 WPS 复制，但未找到图片数据") continue timestamp = datetime.now().strftime("%Y%m%d_%H%M%S") default_name = f"WPS_{timestamp}" base_name = default_name if self.rename_enabled.get(): user_name = self._request_filename() if user_name: base_name = user_name.strip() save_path = os.path.join(self.save_dir.get(), f"{base_name}.png") img.save(save_path, "PNG") self._log(f"已保存：{os.path.basename(save_path)}") self._send_tray_notification( "图片已保存", f"{os.path.basename(save_path)}" ) except Exception as e: self._log(f"出错：{e}") # ------------------- 队列轮询 ------------------- def _poll_queue(self): try: while True: msg = self.msg_queue.get_nowait() if msg[0] == "LOG": self._write_log(msg[1]) elif msg[0] == "REQUEST_FILENAME": event, result_container = msg[1], msg[2] dialog = FilenameDialog(self.root) self.root.wait_window(dialog) result_container.append(dialog.result) event.set() except queue.Empty: pass self.root.after(100, self._poll_queue) def _write_log(self, msg): self.log_text.configure(state=tk.NORMAL) self.log_text.insert(tk.END, f"[{datetime.now().strftime('%H:%M:%S')}] {msg}\n") self.log_text.see(tk.END) self.log_text.configure(state=tk.DISABLED) # ----------------------------- 启动入口 ----------------------------- if __name__ == "__main__": root = tk.Tk() app = WpsImageSaverApp(root) root.mainloop()技术栈
- Python 3.13
- PyInstaller 打包
- PIL/Pillow 图像处理
- pystray 系统托盘
- sv_ttk 现代化界面主题
安装依赖
pip install pyinstaller pillow pystray pywin32 sv-ttk打包exe参考
& "D:\Program Files\Python313\python.exe" -m PyInstaller --onefile --noconsole --clean --collect-submodules PIL --collect-binaries PIL --hidden-import pystray --hidden-import win32clipboard --hidden-import win32ui --hidden-import win32gui --hidden-import win32con --hidden-import PIL._imaging --collect-data sv_ttk --noupx "wpsexceltopng.py"WPS-Copy-Excel-To-PNG/README.md at main · zzlKevin/WPS-Copy-Excel-To-PNG
