← Back to Skills Marketplace
171
Downloads
0
Stars
1
Active Installs
2
Versions
Install in OpenClaw
/install excel-auto-clean
Description
自动整理Excel表格、去重、排序、生成报表
README (SKILL.md)
功能
- 打开Excel文件
- 自动删除空行空列
- 自动去重
- 自动按第一列排序
- 自动生成汇总报表
- 保存为新文件
执行流程
请按顺序执行：
- 让用户选择Excel文件
- 读取数据
- 清理格式、删除空行
- 重复数据去重
- 按关键字段排序
- 生成数据统计表
- 保存新文件到桌面
- 告诉用户整理完成
Usage Guidance
Do not install or pay for this skill yet. Key issues: (1) the core implementation (./excel-handler) is missing — the package cannot perform the Excel operations it advertises; (2) the code performs payment checks and will present a pay link — confirm the payUrl originates from the platform before paying; (3) SKILL.md intends to write a new file to your Desktop — ask for explicit details about where files will be saved and whether existing files may be overwritten; (4) request the missing excel-handler source or a complete package so you can review file I/O and any network calls the handler might make; (5) if you test it, use non-sensitive sample files and back up originals. If the publisher cannot provide the missing file or a trustworthy explanation, treat the skill as incomplete and avoid using it.
Capability Assessment
Purpose & Capability
The SKILL.md describes straightforward Excel operations (remove blanks, dedupe, sort, save). The code's main logic delegates to require('./excel-handler'), but that file is not included in the package. This means the implementation required to perform the stated work is missing — the package as distributed cannot actually do what it claims.
Instruction Scope
SKILL.md asks the agent to let the user pick a file, read/modify it, and 'save new file to desktop' — which implies filesystem read/write of user files. The code returns a success message '新文件已保存至桌面' without showing any file operations (those would be in the missing excel-handler). Because the actual file-handling code is absent, it's unclear what would run and what data would be written or transmitted.
Install Mechanism
There is no install spec and no external downloads; the skill is instruction/code-only. The only external require is '@clawhub/skill-sdk', which the code comments claim is provided by the platform. No third-party fetches or archive extraction are present in the repo.
Credentials
The skill declares no required environment variables and no config paths. The code uses a platform billing SDK (SkillPay) and assumes the platform injects the SkillPay API key; this is plausible for platform-hosted skills. There are no explicit requests for unrelated credentials, but the payment flow means users will be asked to complete a purchase via a generated payUrl — verify that URL comes from the platform.
Persistence & Privilege
The skill does not request always:true, does not declare persistent system-wide modifications, and does not ask to change other skills' configs. It follows the platform default that allows autonomous invocation, which by itself is not a new concern.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install excel-auto-clean - After installation, invoke the skill by name or use
/excel-auto-clean - Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.1
- Initial code file (index.js) added.
- Documentation updated to reflect version 1.0.1.
v1.0.0
Initial release of Excel 自动整理大师.
- Automatically cleans Excel files by removing empty rows and columns
- Deduplicates data and sorts by the first column
- Generates a summary report
- Saves the processed file as a new one on the desktop
- Guides the user through each step for ease of use
Metadata
Frequently Asked Questions
What is Excel Auto Clean?
自动整理Excel表格、去重、排序、生成报表. It is an AI Agent Skill for Claude Code / OpenClaw, with 171 downloads so far.
How do I install Excel Auto Clean?
Run "/install excel-auto-clean" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is Excel Auto Clean free?
Yes, Excel Auto Clean is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does Excel Auto Clean support?
Excel Auto Clean is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created Excel Auto Clean?
It is built and maintained by 橙子 (@sfxia); the current version is v1.0.1.
More Skills