一个在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, padding20) frame.pack(filltk.BOTH, expandTrue) ttk.Label(frame, text请输入图片名称不含扩展名留空则自动命名).pack(anchortk.W, pady(0,5)) self.name_var tk.StringVar(value) self.entry ttk.Entry(frame, textvariableself.name_var, width40) self.entry.pack(filltk.X, pady(0,15)) self.entry.focus_set() btn_frame ttk.Frame(frame) btn_frame.pack(filltk.X) ttk.Button(btn_frame, text确定, commandself._on_confirm, styleAccent.TButton).pack(sidetk.RIGHT, padx(5,0)) ttk.Button(btn_frame, text取消, commandself._on_cancel).pack(sidetk.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(valueos.path.join(os.path.expanduser(~), Desktop, WPS截图)) self.rename_enabled tk.BooleanVar(valueFalse) 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, rSoftware\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, padding15) main_frame.pack(filltk.BOTH, expandTrue) # --- 保存设置卡片 --- dir_frame ttk.LabelFrame(main_frame, text保存设置, padding10) dir_frame.pack(filltk.X, pady(0,10)) ttk.Label(dir_frame, text图片保存路径).grid(row0, column0, stickytk.W, pady(0,5)) path_entry ttk.Entry(dir_frame, textvariableself.save_dir, width60) path_entry.grid(row1, column0, padx(0,5), stickytk.EW) ttk.Button(dir_frame, text浏览..., commandself._browse_folder).grid(row1, column1) # ★ 新增“打开文件夹”按钮 ttk.Button(dir_frame, text 打开文件夹, commandself._open_folder).grid(row1, column2, padx(5,0)) dir_frame.columnconfigure(0, weight1) ttk.Checkbutton( dir_frame, text每次复制后弹出窗口自定义文件名, variableself.rename_enabled ).grid(row2, column0, columnspan3, stickytk.W, pady(10,0)) # --- 控制栏 --- ctrl_frame ttk.Frame(main_frame) ctrl_frame.pack(filltk.X, pady(0,10)) self.start_btn ttk.Button(ctrl_frame, text开始监控, styleAccent.TButton, commandself._toggle_monitoring) self.start_btn.pack(sidetk.LEFT, padx(0,10)) self.status_label ttk.Label(ctrl_frame, text● 未启动, foregroundgray) self.status_label.pack(sidetk.LEFT) # --- 日志区 --- log_frame ttk.LabelFrame(main_frame, text运行日志, padding5) log_frame.pack(filltk.BOTH, expandTrue) self.log_text tk.Text(log_frame, height12, width80, statetk.DISABLED, wraptk.WORD, bg#1E1E1E if sv_ttk.get_theme() dark else #FAFAFA, fg#D4D4D4 if sv_ttk.get_theme() dark else #1E1E1E, insertbackgroundwhite, borderwidth0) scrollbar ttk.Scrollbar(log_frame, orienttk.VERTICAL, commandself.log_text.yview) self.log_text.configure(yscrollcommandscrollbar.set) self.log_text.pack(sidetk.LEFT, filltk.BOTH, expandTrue) scrollbar.pack(sidetk.RIGHT, filltk.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_okTrue) 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_okTrue) except: messagebox.showerror(错误, f无法创建目录{path}) return self.monitoring True self.stop_event.clear() self.monitor_thread threading.Thread(targetself._monitor_loop, daemonTrue) 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● 已停止, foregroundgray) 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)], fillwhite) return img def _tray_thread(self): # ★ 托盘菜单增加“打开保存文件夹” menu Menu( MenuItem(显示窗口, self._show_window, defaultTrue), 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(targetself._tray_thread, daemonTrue) th.start() def _show_window(self, iconNone, itemNone): 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, iconNone, itemNone): 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, titletitle) 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 fWPS_{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(statetk.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(statetk.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.pyWPS-Copy-Excel-To-PNG/README.md at main · zzlKevin/WPS-Copy-Excel-To-PNG