← 返回 Skills 市场
33
总下载
0
收藏
0
当前安装
1
版本数
在 OpenClaw 中安装
/install excel-xlsx-formula-cleanup-helper
功能描述
Diagnose and fix Microsoft Excel XLSX workbook issues involving formulas, named ranges, Power Query refreshes, pivot tables, VBA/macro preservation, workbook...
使用说明 (SKILL.md)
Excel XLSX Formula Cleanup
Use this skill for spreadsheet repair and automation tasks where correctness matters more than simply rewriting cells. Treat an .xlsx workbook as a structured package with formulas, styles, relationships, cached values, tables, queries, pivots, and sometimes macros.
Workflow
- Clarify the workbook goal: fix broken formulas, clean imported data, preserve macros, refresh reporting logic, repair corruption, or generate a reusable workflow.
- Protect the workbook. Work on a copy and avoid destructive recalculation or macro removal unless requested.
- Choose the right inspection path:
- Use
openpyxlfor formulas, worksheets, styles, dimensions, tables, data validation, conditional formatting, and charts it supports. - Treat
.xlsmfiles carefully; preserve the VBA project with library support or package-level copying. - Inspect ZIP/OOXML parts for workbook relationships, external links, pivot caches, slicers, Power Query metadata, and unsupported structures.
- Use
- Map each problem to a workbook layer: formula text, named range, table reference, external link, query connection, pivot cache, style, merged cell, or hidden sheet.
- Make minimal repairs and keep formulas as formulas. Do not replace formulas with stale cached values unless the user asks for a static export.
- Validate formulas and shape:
- Confirm worksheet names, table names, named ranges, and formulas still point to valid ranges.
- Check row/column counts, date and number formats, hidden sheets, filters, and merged cells.
- Note when a desktop Excel recalculation or Power Query refresh is still required.
Common Fix Patterns
- Broken formulas: trace sheet names, structured references, named ranges, separators, and external workbook links before editing formula strings.
- Power Query refresh issues: inspect connection definitions and query metadata; explain which parts require Excel desktop or Power BI tooling.
- Pivot table drift: preserve pivot caches where possible and warn when Python libraries cannot safely rebuild them.
- VBA preservation: keep
.xlsmpackage parts intact; never save through a path that drops macros unless producing a macro-free copy is the goal. - Data cleanup: normalize values in staging sheets or tables, then keep reporting formulas and dashboards stable.
Outputs
Provide:
- A workbook diagnosis tied to specific sheets, ranges, formulas, or package parts.
- A safe repair or automation plan, plus code changes when requested.
- A validation checklist covering formulas, ranges, tables, pivots, macros, and expected recalculation.
Read references/requirement-plan.md only when the original demand evidence is needed.
安全使用建议
Install this only if you want an agent to help inspect and repair Excel workbooks. For sensitive financial or business spreadsheets, use copies, review any proposed changes before replacing originals, and be aware that the publisher should narrow the trigger wording to reduce accidental invocation.
能力评估
Purpose & Capability
The stated purpose is diagnosing and repairing Excel workbook issues involving formulas, named ranges, Power Query, pivots, macros, corruption, and cleanup, and the operational guidance stays within that spreadsheet-maintenance scope.
Instruction Scope
The English runtime instructions are scoped and include safety guidance to clarify goals, work on a copy, make minimal repairs, and avoid macro removal unless requested. The Chinese description, README trigger examples, and implicit invocation setting are broader and more templated than ideal, but they do not add hidden or unrelated behavior.
Install Mechanism
The artifact contains Markdown instructions and a small YAML agent descriptor only; no executable scripts, package install steps, binaries, or post-install hooks were found.
Credentials
Inspecting and modifying user-provided Excel workbooks is expected for this skill. The artifact does not request broad filesystem indexing, unrelated file access, network services, external APIs, or credential stores.
Persistence & Privilege
No persistence, background workers, privilege escalation, credential/session/profile access, or automatic exfiltration behavior was present in the artifacts.
如何使用
- 确保已安装 OpenClaw（本地或 Docker 部署）
- 在对话框中输入安装命令：
/install excel-xlsx-formula-cleanup-helper - 安装完成后，直接呼叫该 Skill 的名称或使用
/excel-xlsx-formula-cleanup-helper触发 - 根据 Skill 的参数说明提供必要输入，即可获得结构化输出
版本历史
v1.0.1
- Improved workflow guidance for diagnosing and fixing Excel workbook issues involving formulas, named ranges, queries, pivots, macros, and data cleanup.
- Added clear instructions for non-destructive repairs and preserving workbook structure and business logic.
- Expanded common fix patterns for formulas, Power Query, pivots, VBA/macros, and repeated data cleanup.
- Clarified expected outputs: diagnosis, safe repair/automation plan, and a validation checklist.
元数据
常见问题
Excel Xlsx Formula Cleanup Helper 是什么？
Diagnose and fix Microsoft Excel XLSX workbook issues involving formulas, named ranges, Power Query refreshes, pivot tables, VBA/macro preservation, workbook... 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件，目前累计下载 33 次。
如何安装 Excel Xlsx Formula Cleanup Helper？
在 OpenClaw 或 Claude Code 对话框中运行命令「/install excel-xlsx-formula-cleanup-helper」即可一键安装，无需额外配置。
Excel Xlsx Formula Cleanup Helper 是免费的吗？
是的，Excel Xlsx Formula Cleanup Helper 完全免费，采用 MIT-0 许可证，可自由下载、安装和使用。
Excel Xlsx Formula Cleanup Helper 支持哪些平台？
Excel Xlsx Formula Cleanup Helper 跨平台运行，可在任意部署了 OpenClaw / Claude Code 的环境中使用（cross-platform）。
谁开发了 Excel Xlsx Formula Cleanup Helper？
由 Kyro（@kyro-ma）开发并维护，当前版本 v1.0.1。
推荐 Skills