据 AlphaMoat 统计,截至 2026-10,Excel / XLSX 累计下载 403,727 次、获 453 个星标,按累计下载量在本次参与排名的 10,914 个 AI 技能中排名第 60 位,在「办公效率」分类(909 个)中排名第 9 位。
列表默认按累计下载量排序,也可按星标排序;详情页排名按累计下载量计算。
| 平台 | 累计下载 | 星标 | 评论 |
|---|---|---|---|
| ClawHub ↗ | 8.4万 | 299 | 1 |
| SkillHub ↗ | 40.4万 | 453 | — |
各平台的计数口径不同,统计时间不一致。
正文按作业类型选工具:分析、重塑与表格式数据用 pandas,涉及公式、样式、批注、合并单元格或模板保真时用 openpyxl。它把几类坑写得很细:日期其实是序列号且带历史遗留偏差,长编号与前导零要按文本存,Excel 会静默截断超限的数值精度,而 openpyxl 只保存公式、不做重算,所以交付前要重新计算并清掉 #REF!、#DIV/0! 一类错误。模板里的列宽、冻结、筛选、打印设置与数据验证都算业务含义,除非任务明确要求否则不动。
资料发布于 2026-10-27
以下是根据技能文档生成的示例,不代表实际运行结果。
2026-09 起统计方法调整:同名技能按作者分别统计,并覆盖全部技能。图中虚线为调整前的月份,与之后的数据不直接比较,也不计算跨越调整的增长。 该技能有同名的其他版本,调整前的数据归属当前下载量最大的这一个。
| 月份 | 累计下载 | 环比 | 星标 |
|---|---|---|---|
| 2026-10 | 40.4万 | — | 453 |
| 2026-09 | 21.7万 | — | 452 |
| 2026-08 | 18.2万 | +13.4% | 447 |
| 2026-07 | 16.1万 | +8.3% | 425 |
| 2026-06 | 14.8万 | +11.9% | 392 |
| 2026-05 | 13.3万 | — | 343 |
| 2026-03 | 7.2万 | — | 216 |
以下是作者发布的原始文件,按纯文本显示,本站未做修改或审核;其中的链接不可点击,命令请核实后再运行。抓取于 2026-10-23。
---
name: Excel / XLSX
slug: excel-xlsx
version: 1.0.2
homepage: https://clawic.com/skills/excel-xlsx
description: "Create, inspect, and edit Microsoft Excel workbooks and XLSX files with reliable formulas, dates, types, formatting, recalculation, and template preservation. Use when (1) the task is about Excel, `.xlsx`, `.xlsm`, `.xls`, `.csv`, or `.tsv`; (2) formulas, formatting, workbook structure, or compatibility matter; (3) the file must stay reliable after edits."
changelog: Tightened formula anchoring, recalculation, and model traceability after a stricter external spreadsheet audit.
metadata: {"clawdbot":{"emoji":"📗","requires":{"bins":[]},"os":["linux","darwin","win32"]}}
---
## When to Use Use when the main artifact is a Microsoft Excel workbook or spreadsheet file, especially when formulas, dates, formatting, merged cells, workbook structure, or cross-platform behavior matter. ## Core Rules ### 1. Choose the workflow by job, not by habit - Use `pandas` for analysis, reshaping, and CSV-like tasks. - Use `openpyxl` when formulas, styles, sheets, comments, merged cells, or workbook preservation matter. - Treat CSV as plain data exchange, not as an Excel feature-complete format. - Reading values, preserving a live workbook, and building a model from scratch are different spreadsheet jobs. ### 2. Dates are serial numbers with legacy quirks - Excel stores dates as serial numbers, not real date objects. - The 1900 date system includes the false leap-day bug, and some workbooks use the 1904 system. - Time is fractional day data, so formatting and conversion both matter. - Date correctness is not enough if the number format still displays the wrong thing to the user. ### 3. Keep calculations in Excel when the workbook should stay live - Write formulas into cells instead of hardcoding derived results from Python. - Use references to assumption cells instead of magic numbers inside formulas. - Cached formula values can be stale, so do not trust them blindly after edits. - Check copied formulas for wrong ranges, wrong sheets, and silent off-by-one drift before delivery. - Absolute and relative references are part of the logic, so copied formulas can be wrong even when they still "work". - Test new formulas on a few representative cells before filling them across a whole block. - Verify denominators, named ranges, and precedent cells before shipping formulas that depend on them. - A workbook should ship with zero formula errors, not with known `#REF!`, `#DIV/0!`, `#VALUE!`, `#NAME?`, or circular-reference fallout left for the user to fix. - For model-style work, document non-obvious hardcodes, assumptions, or source inputs in comments or nearby notes. ### 4. Protect data types before Excel mangles them - Long identifiers, phone numbers, ZIP codes, and leading-zero values should usually be stored as text. - Excel silently truncates numeric precision past 15 digits. - Mixed text-number columns need explicit handling on read and on write. - Scientific notation, auto-parsed dates, and stripped leading zeros are common corruption, not cosmetic issues. ### 5. Preserve workbook structure before changing content - Existing templates override generic styling advice. - Only the top-left cell of a merged range stores the value. - Hidden rows, hidden columns, named ranges, and external references can still affect formulas and outputs. - Shared strings, defined names, and sheet-level conventions can matter even when the visible cells look simple. - Match styles for newly filled cells instead of quietly introducing a new visual system. - If the workbook is a template, preserve sheet order, widths, freezes, filters, print settings, validations, and visual conventions unless the task explicitly changes them. - Conditional formatting, filters, print areas, and data validation often carry business meaning even when users only mention the numbers. - If there is no existing style guide and the file is a model, keep editable inputs visually distinguishable from formulas, but never override an established template to force a generic house style. ### 6. Recalculate and review before delivery - Formula strings alone are not enough if the recipient needs current values. - `openpyxl` preserves formulas but does not calculate them. - Verify no `#REF!`, `#DIV/0!`, `#VALUE!`, `#NAME?`, or circular-reference fallout remains. - If layout matters, render or visually review the workbook before calling it finished. - Be careful with read modes: opening a workbook for values only and then saving can flatten formulas into static values. - If assumptions or hardcoded overrides must stay, make them obvious enough that the next editor can audit the workbook. ### 7. Scale the workflow to the file size - Large workbooks can fail for boring reasons: memory spikes, padded empty rows, and slow full-sheet reads. - Use streaming or chunked reads when the file is big enough that loading everything at once becomes fragile. - Large-file workflows also need narrower reads, explicit dtypes, and sheet targeting to avoid accidental damage. ## Common Traps - Type inference on read can leave numbers as text or convert IDs into damaged numeric values. - Column indexing varies across tools, so off-by-one mistakes are common in generated formulas. - Newlines in cells need wrapping to display correctly. - External references break easily when source files move. - Password protection in old Excel workflows is not serious security. - `.xlsm` can contain macros, and `.xls` remains a tighter legacy format. - Large files may need streaming reads or more careful memory handling. - Google Sheets and LibreOffice can reinterpret dates, formulas, or styling differently from Excel. - Dynamic array or newer Excel functions like `FILTER`, `XLOOKUP`, `SORT`, or `SEQUENCE` may fail or degrade in older viewers. - A workbook can look fine while still carrying stale cached values from a prior recalculation. - Saving the wrong workbook view can replace formulas with cached values and quietly destroy a live model. - Copying formulas without checking relative references can push one bad range across an entire block. - Hidden sheets, named ranges, validations, and merged areas often keep business logic that is invisible in a quick skim. - A workbook can appear numerically correct while still failing because filters, conditional formats, print settings, or data validation were stripped. - A workbook can be numerically correct and still fail visually because wrapped text, clipped labels, or narrow columns were never reviewed. ## Related Skills Install with `clawhub install <slug>` if user confirms: - `csv` — Plain-text tabular import and export workflows. - `data` — General data handling patterns before spreadsheet output. - `data-analysis` — Higher-level analysis that can feed workbook deliverables. ## Feedback - If useful: `clawhub star excel-xlsx` - Stay updated: `clawhub sync`
通过 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 操作金山文档云文档的官方技能。
把用户纠正与自我复盘沉淀成分层记忆、并按使用情况升降级的技能。
处理 Word 与 DOCX 文档的作业规范,重点是改完之后样式、编号与版式不跑偏。
面向多家视频模型 API 的 AI 视频生成与编排技能。
把数据库、表格与导出的原始数据变成可决策结论的数据分析技能。
改 PPT 之前先看清结构的一套规范,目标是改完还能干净渲染。
数据月份:2026-10 · 下载/星标数聚合自公开技能注册库(ClawHub、SkillHub),按月更新。口径说明见数据方法。