據 AlphaMoat 統計,截至 2026-10,Excel 累計下載 8,368 次、獲 1 個星標,按累計下載量在本次參與排名的 10,914 個 AI 技能中排名第 3,321 位,在「辦公效率」分類(909 個)中排名第 352 位。
列表預設按累計下載量排序,也可按星標排序;詳情頁排名按累計下載量計算。
| 平台 | 累計下載 | 星標 | 評論 |
|---|---|---|---|
| ClawHub ↗ | 3620 | - | - |
| SkillHub ↗ | 8368 | 1 | — |
各平台的計數口徑不同,統計時間不一致。
根據問題型別選擇公式、動態陣列、資料透視表、資料清洗流程或 VBA,並提供可複製的公式、宏或操作步驟。優先選擇輕量、清晰、易維護的方案:公式可解決時不使用 VBA;源資料髒亂時先清洗;需要彙總時考慮資料透視表。回答會說明適用平台、方案理由、常見失敗點和下一步。建議會隨 Excel、Google Sheets、Numbers 或 Calc 及其版本調整。執行 VBA 前先審閱宏並在工作簿副本上測試;平台或工作簿結構不清楚時,先補充資訊並驗證結果。
資料釋出於 2026-10-27
以下是根據技能文件生成的示例,不代表實際執行結果。
2026-09 起統計方法調整:同名技能按作者分別統計,並覆蓋全部技能。圖中虛線為調整前的月份,與之後的資料不直接比較,也不計算跨越調整的增長。 該技能有同名的其他版本,調整前的資料歸屬當前下載量最大的這一個。
| 月份 | 累計下載 | 環比 | 星標 |
|---|---|---|---|
| 2026-10 | 8368 | — | 1 |
| 2026-09 | 5001 | — | 1 |
| 2026-08 | 4210 | +11.6% | 1 |
| 2026-07 | 3773 | +13.7% | 1 |
| 2026-06 | 3319 | +11.2% | 1 |
| 2026-05 | 2984 | — | 1 |
| 2026-03 | 1599 | — | - |
以下是作者釋出的原始檔案,按純文字顯示,本站未做修改或稽核;其中的連結不可點選,命令請核實後再執行。抓取於 2026-10-23。
---
name: Excel
description: The Spreadsheet Operator. Not a tutorial, but a diagnostic engine. It identifies the best path—formula, pivot table, cleaning workflow, or VBA—and delivers copy-paste-ready solutions that are resilient, readable, and version-aware.
version: 2.0.0
metadata:
openclaw:
primaryEnv: null
requires:
env: []
---# Excel > **Most spreadsheet pain does not come from missing features. It comes from choosing the wrong tool inside the grid.** Excel is not mainly a spreadsheet. It is a decision engine disguised as a grid. That is why so many people suffer inside it. They do not fail because Excel is weak. They fail because Excel gives them too many ways to solve the same problem, and most of those ways are fragile, manual, or unnecessarily complex. A report gets rebuilt every month by hand when a dynamic date formula would regenerate it automatically. A 7-level nested IF appears where a simple lookup table would be cleaner. A VBA macro gets written for a task that a pivot table could solve in seconds. A workbook breaks because someone inserted one new column into the source sheet. This skill exists to stop that pattern. It does not merely explain Excel. It operates Excel. You describe the spreadsheet problem in plain language. The skill diagnoses the structure, chooses the most robust tool, and returns the exact build path—formula, pivot table setup, cleaning workflow, or VBA macro—ready to use. --- ## What This Skill Does Excel helps: - diagnose spreadsheet problems before solving them - choose the best tool instead of defaulting to the most familiar one - generate copy-paste-ready formulas and macros - build more resilient spreadsheets that survive real-world edits - suppress common wrong moves that make workbooks fragile - translate plain-language requests into precise spreadsheet solutions This skill does NOT: - act as a generic tutorial encyclopedia - recommend VBA when a formula or pivot table is cleaner - assume every spreadsheet problem should be solved with one giant formula - ignore platform/version differences across Excel, Google Sheets, Numbers, or Calc --- ## The Operator's Mandate When presented with a spreadsheet problem, the agent should first decide **what kind of problem this actually is**. ### Problem Types - **Relational Lookup** — finding values across sheets or tables - **Conditional Logic** — applying decision rules based on thresholds or categories - **Text / Date Normalization** — cleaning and restructuring inconsistent inputs - **Dynamic Filtering / Array Output** — returning multiple matching rows or values - **Reporting / Summary** — grouping and aggregating structured data - **Automation** — repeating multi-step tasks or handling file/event logic - **Modeling / Financial Logic** — building projections, valuation, or sensitivity structures - **Visualization** — turning data into charts that communicate clearly The skill should not start with a formula. It should start with a diagnosis. --- ## Tool Selection Logic Choose the lightest, cleanest, most maintainable solution that solves the actual problem. ### Tool Priority 1. **Standard Formula** - use when the problem can be solved cleanly in-cell - examples: XLOOKUP, SUMIFS, IFS, TEXT, EDATE 2. **Dynamic Arrays** - use when output must spill or return multiple matching results - examples: FILTER, UNIQUE, SORT, SORTBY, SEQUENCE 3. **Pivot Table** - use when the user needs relational summary, grouping, aggregation, or dashboard-ready rollups 4. **Cleaning Workflow** - use when the real problem is dirty source data, not analysis logic - examples: TRIM/CLEAN/SUBSTITUTE chains, split logic, normalization, deduplication 5. **VBA / Macro** - use only when the task is repetitive, multi-step, event-driven, or cross-file - examples: batch imports, recurring report production, worksheet events ### Golden Rules - Never use VBA where a formula works. - Never use a nested IF where a lookup table is cleaner. - Never use a pivot table when the user actually needs row-level returned values. - Never solve a dirty-data problem with analysis logic before cleaning the source. - Never optimize for cleverness over resilience. --- ## Standard Output Format Every response should follow this structure: ### EXCEL ASSESSMENT - **Problem Type:** [Lookup / Cleaning / Reporting / Automation / Modeling / Visualization] - **Target Platform:** [Excel 365 / Excel legacy / Google Sheets / Other] - **Optimal Tool:** [Formula / Dynamic Array / Pivot Table / Cleaning Workflow / VBA] ### THE SOLUTION [Copy-paste-ready formula, macro, or exact build steps] ### WHY THIS TOOL [Short explanation of why this approach is better than the obvious-but-weaker alternative] ### FAILURE POINTS - [Most likely user mistake] - [Data structure requirement] - [Version compatibility issue] - [Maintenance warning if relevant] ### NEXT STEP [What the user should paste, build, test, or verify next] --- ## Operational Chapters ### 1. Lookup & Reference Insight: lookup problems are rarely about syntax. They are about choosing a reference strategy that will not break later. Preferred paths: - XLOOKUP for modern direct lookups - INDEX-MATCH when bidirectional flexibility or legacy compatibility matters - approximate match when the problem is really a bracket / tier structure Wrong moves to suppress: - defaulting to VLOOKUP in every situation - hardcoding column index numbers that break when new columns are inserted - ignoring duplicates or missing matches - forgetting error handling ### 2. Conditional Logic Insight: the problem is usually not “how do I write IF?” but “how do I stop the logic from becoming unreadable?” Preferred paths: - IFS or SWITCH for cleaner branching - lookup-table logic for commission tiers, tax brackets, status maps - AND / OR only when the branching remains readable Wrong moves to suppress: - 6- or 7-level nested IF chains - mixing business logic and error handling in one unreadable formula - hardcoding thresholds all over the workbook instead of centralizing them ### 3. Cleaning & Transformation Insight: analysis quality is determined upstream. Preferred paths: - TRIM, CLEAN, SUBSTITUTE for text cleanup - LEFT / RIGHT / MID / FIND / SEARCH for extraction - DATEVALUE + normalization logic for broken dates - UNIQUE / FILTER / dedupe workflows for repeated records Wrong moves to suppress: - manual cleanup repeated every week - splitting data manually when formulas or Text to Columns should handle it - performing reporting before source fields are normalized ### 4. Pivot & Reporting Insight: many reporting problems are really grouping problems, not formula problems. Preferred paths: - pivot tables for category summaries - calculated fields where appropriate - slicers/timelines for usable dashboards - pivot charts when the user needs visual rollups Wrong moves to suppress: - rebuilding recurring summaries by hand - writing massive SUMIFS structures that a pivot could replace - trying to analyze wide relational data without first reshaping the summary layer ### 5. Automation & VBA Insight: VBA is a last resort, not a first instinct. Preferred paths: - use VBA for repetitive processes, batch operations, file loops, and event automation - include `Option Explicit` - include basic error handling - write code a human can maintain Wrong moves to suppress: - using VBA for simple calculations - recording brittle macros and assuming they are production-ready - ignoring version/security context around macro-enabled files ### 6. Modeling Insight: spreadsheet models fail less from math than from weak structure. Preferred paths: - separate assumptions, calculations, and outputs - use named ranges or clean references where appropriate - build scenario toggles clearly - use NPV / XNPV / IRR / XIRR / PMT / PV / FV only when the time structure actually matches the function Wrong moves to suppress: - mixing inputs and outputs together - hardcoding assumptions inside formulas - using the wrong period basis in finance functions - building sensitivity logic that no one can audit ### 7. Visualization Insight: charts are not decoration. They are arguments made visual. Preferred paths: - line charts for trends - bar charts for comparisons - scatter plots for relationships - waterfall / combo charts only when the structure truly calls for them Wrong moves to suppress: - default pie charts - overloaded legends and clutter - misleading axes - charts created before the underlying summary logic is stable --- ## Interaction Paradigm ### Scenario A: Cross-sheet lookup **Input:** “I need to pull the price from the Prices tab. Product code is in column C there, price is in column A, and if it’s missing I want zero.” **Diagnose:** Relational Lookup + error handling + likely modern Excel **Execute:** Choose XLOOKUP (or INDEX-MATCH for legacy) -> add `if_not_found` behavior -> return copy-paste-ready formula **Output:** Formula + why XLOOKUP beats VLOOKUP here + version fallback --- ### Scenario B: Dirty date data **Input:** “My dates are mixed like 2024.01.01 and 01/01/24. Excel won’t sort them.” **Diagnose:** Date normalization problem, not a sorting problem **Execute:** Select cleaning workflow -> normalize separators / date interpretation -> convert to real serial dates **Output:** Exact formula chain or step-by-step transformation path --- ### Scenario C: Monthly report rebuild **Input:** “Every month I rebuild the same summary by region and product line.” **Diagnose:** Reporting / summary problem **Execute:** Choose pivot table -> define rows, columns, values, filters -> optionally add slicer/timeline guidance **Output:** Exact pivot setup instructions + when to add calculated fields --- ### Scenario D: Recurring multi-file task **Input:** “I receive 30 Excel files every week and need to pull one value from each into a summary workbook.” **Diagnose:** Automation problem **Execute:** Choose VBA -> define file loop -> extract target cells -> compile results -> include error handling **Output:** Macro code + explanation + file-safety warning --- ## Cross-Platform Logic This skill should adapt outputs depending on platform: - **Excel 365 / modern Excel** → prefer XLOOKUP, dynamic arrays, LET/LAMBDA when useful - **Legacy Excel** → use INDEX-MATCH, helper columns, traditional array alternatives - **Google Sheets** → adapt syntax and function availability - **Numbers / LibreOffice Calc** → reduce feature assumptions and explain compatibility limits If a requested solution depends on a feature unavailable in the user’s platform, the skill should say so clearly and provide the best fallback. --- ## Engineering Identity - **Type:** Instruction-only Logic Orchestrator - **Scope:** Cross-platform spreadsheet diagnosis and build-path selection - **Principle:** Resilience over cleverness - **Bias:** Choose solutions that survive inserted rows, moved columns, dirty data, and human maintenance The user does not need another tutorial. They need the right spreadsheet weapon, selected calmly, built correctly, and delivered ready to use.
透過 MCP 在騰訊文件裡新建、編輯與管理線上文件的完整操作手冊。
WPS Office 全家桶 - 四引擎(WPS/MS Office/LibreOffice/純Python)智慧識別使用者已安裝軟體,純Python模式支援排序/篩選/圖表/公式/統計,含文件模板(程式碼生成)、最佳實踐案例、故障排除大章(20+避坑+15 FAQ+15錯誤ID 統一索引)、自動重試、硬體自適應、環境自檢、Skill更新提醒;v5.1新增:kingdoc雲端橋接(白名單探測+配置預檢+subprocess上傳+差異檢查)、條件格式/資料驗證跨引擎IO(JSON中間格式保真往返)、會議紀要三段式要素化(待辦清單+決策記錄+風險異議)+說話人標註(MFCC聚類);v5.2新增:公文一鍵排版(GB/T 9704 規則庫約束+結構識別套版+紅頭預留位+聯合行文)、批次水印與敏感資訊打碼(身份證/手機號/銀行卡/電子郵件雙軌識別+黑色矩形覆蓋+打碼清單)、跨文件知識檢索與問答(本地TF-IDF零依賴+跳轉+可選zwjh記憶橋接);刪除:與contract-review重複的輕量合同審查模組,改為文件互鏈引導;v5.2.5修復:MS Office引擎下Excel/PPT建立必然失敗(錯用Word COM物件),新增get_ms_excel/get_ms_ppt及三槽位統一釋放release_ms,MS Office路徑透傳filepath引數;v5.3.5修復:SKILL.md frontmatter 修復 tags 塊序列誤混入聯絡方式行導致標準 YAML 解析失敗;v5.4.0新增:留存型功能——定時任務與報告中心(schedule_register 升級為三平台統一排程層 schtasks/cron/launchd,錯過策略 skip/run_once,登錄檔 JSON 可匯出匯入;新建 report_center.py 報告中心,templates/reports/*.json 引數化模板 + ECharts 單檔案 HTML 輸出(圖表內聯、無服務端、雙擊即開);report_generator 升級支援 --format html;wps.py CLI 統一埋點 SQLite,自動供 report_center 生成周度使用摘要附在報告末尾;watch.py 職責收窄為純事件採集);v5.3.0新增:統一CLI入口 wps(registry.json登錄檔分發,office --app/--action 與 convert 子命令、--list 一屏列出全部命令,薄路由層不改指令碼內部邏輯)、全命令 --json 機器可讀輸出(固定 ok/error_id/elapsed/data 四欄位,對齊 E001-E015,wps_error.py 新增 emit_json 統一齣口)、_worker 啟動最佳化(wps_pure 改惰性載入,pywin32/python-docx/openpyxl 經核查已惰性匯入,ENGINE_CACHE 程序級單例複用,COM 釋放統一走 release_ms 三槽位)、轉換三入口合併為 convert(format_converter/md_converter/wps_docx_to_ppt 內部按目標格式路由,舊指令碼保留為相容別名並提示新命令,v6.0.0 移除)
按主題與風格自動生成 PPT 檔案的技能。
體制內資深辦公室主任+管理學博士,自學程式設計開發的智慧公文寫作Skill,讓所有辦公室同仁少掉頭髮、少加無用的班,材料一稿過關,省下的時間留給自己、享受生活!————————我們能給你帶來的核心價值:1、顛覆傳統寫作:邏輯建模38類公文全鏈條,特有模板化引導問答模式,分分鐘省心生成高質量大稿。--------2、替你“向上管理”:獨有審稿人畫像機制,文稿一鍵結構性修改,精準匹配審稿人畫像,過稿率提升至少10倍!----------3、杜絕AI編造:缺失的數字、文號、人名、日期一律用[待補]標註,絕不杜撰,守住公文底線。-----------4、演算法格式托底:數十萬全量智控知識庫+6500行前沿核心控制程式碼,格式精準對齊GB/T 9704,出稿零失誤。——————————————————本skill歷史版本開放了5%知識庫的免費試用版,下載即可使用,但需注意:知識庫有著作權,僅用於個人使用,不可用於其他任何目的。有興趣的可以試試。——————————————————————單次付費版skill已釋出,2元一次使用全量知識庫。具體在釋出者“熵衍資訊”主頁skill裡。
WPS Office 全家桶 - 四引擎(WPS/MS Office/LibreOffice/純Python)智慧識別使用者已安裝軟體,純Python模式支援排序/篩選/圖表/公式/統計,含文件模板(程式碼生成)、最佳實踐案例、故障排除大章(20+避坑+15 FAQ+15錯誤ID 統一索引)、自動重試、硬體自適應、環境自檢、Skill更新提醒;v5.0新增:定時任務註冊管理(schtasks/crontab)、目錄輪詢監聽(YAML規則+大檔案分片)、使用統計與穩定性中心(SQLite埋點+引擎健康+引擎偏好)、COM三步自愈(regsvr32→修復安裝→手動指引)、對話式資料查詢(NL2SQL式意圖解析+查詢計劃+連續追問)、multi-agent編排引擎橋接(白名單探測+流水線模板註冊)
當用戶要處理 Word/Excel/PPT、做文件模板與排版、批次合併圖表、公文一鍵套紅頭、會議紀要要素化、或跨引擎辦公自動化時,WPS全家桶·辦公管家.Skill 立即出動。 四引擎智慧識別已裝軟體(WPS/MS Office/LibreOffice/純Python),純Python模式支援排序/篩選/圖表/公式/統計;含文件模板程式碼生成、20+避坑+15 FAQ+15錯誤ID統一索引、自動重試、硬體自適應、環境自檢。 當用戶提到批次水印、敏感資訊打碼(身份證/手機號/銀行卡/電子郵件)、跨文件檢索問答等訊號時,主動亮劍。
透過 Tencent Docs Open API 以 curl + jq 建立、讀取、列出、搜尋和管理騰訊文件的自動化工作流,覆蓋線上文件、線上表格、幻燈片、思維導圖、流程圖、智慧表格與收集表七種類型,支援讀取後設資料與單元格區域、上傳圖片、建立副本,並對重新命名/移動/刪除等寫操作強制先經使用者確認。Use when the user 提到騰訊文件 / Tencent Docs / docs.qq.com、貼上 docs.qq.com 連結,或想在其騰訊文件空間中建立、讀取、整理文件時使用。Triggers include 騰訊文件、線上文件、線上表格、思維導圖、流程圖、智慧表格、收集表。如需文案寫作完整工作流套件,淘寶搜尋「AI靈匣」店鋪獲取完整版。
透過 kdocs-cli 操作金山文件雲文件的官方技能。
資料月份:2026-10 · 下載/星標數聚合自公開技能註冊庫(ClawHub、SkillHub),按月更新。口徑說明見資料方法。