← 返回 Skills 市场
excel-clean
作者
Martin-SH-Ni
· GitHub ↗
· v1.0.0
· MIT-0
97
总下载
0
收藏
0
当前安装
1
版本数
在 OpenClaw 中安装
/install excel-clean
功能描述
Clean Excel data — deduplication, fill missing values, format conversion.
使用说明 (SKILL.md)
Excel Cleaner（Excel数据清洗）
去重 / 空值填充 / 格式转换 | Pandas驱动
功能 | Features
- ✅ 批量去重 — 按指定列组合去重
- ✅ 空值填充 — 支持填充固定值、前值、后值
- ✅ 格式转换 — 数值/文本/日期格式互转
- ✅ 保留原文件 — 输出为
_cleaned.xlsx，原文件不变
使用场景 | Use Cases
| 场景 | 说明 |
|---|---|
| 名单去重 | 删除重复客户/订单记录 |
| 数据补全 | 用"未知"或0填充空值 |
| 格式标准化 | 日期统一为 YYYY-MM-DD |
使用方式 | Usage
输入参数:
file_path Excel文件路径
dedup_cols 去重列名列表（可选）
fill_value 空值填充内容（可选）
convert_type 格式类型转换（可选）
输出:
success 是否成功
output 输出文件路径
rows 处理后行数
示例 | Example
result = excel_clean(
file_path="/data/orders.xlsx",
dedup_cols=["订单号", "手机号"],
fill_value="未知",
convert_type="日期:YYYY-MM-DD"
)
依赖 | Dependencies
pandas >= 1.3.0
openpyxl >= 3.0.0
版本 v1.0
安全使用建议
This skill appears coherent for cleaning Excel files, but note it is instruction-only: it assumes a Python runtime with pandas and openpyxl are available (or that the agent will pip-install them). Before installing or running: confirm the agent/environment will run Python safely; verify where files are read from and written to (ensure the agent has only the filesystem access you expect); avoid processing sensitive spreadsheets with an agent you don't fully trust; if you need guarantees, ask the skill author for an explicit install script or a packaged implementation so you can review the exact code that will run.
功能分析
Type: OpenClaw Skill
Name: excel-clean
Version: 1.0.0
The skill bundle describes a standard Excel data cleaning utility using Pandas and openpyxl. The documentation in SKILL.md and metadata in _meta.json are consistent with the stated purpose of deduplication and formatting, with no evidence of malicious instructions, data exfiltration, or suspicious execution patterns.
能力评估
Purpose & Capability
Name/description (Excel cleaning) align with the SKILL.md operations (dedupe, fill, convert) and the listed dependencies (pandas, openpyxl). The requirements requested are proportionate to the stated purpose. One minor gap: the SKILL.md implies Python usage but the skill does not declare a Python runtime or install steps.
Instruction Scope
Instructions stay within scope: they describe reading an input Excel file, performing local transforms, and writing a _cleaned.xlsx output. The SKILL.md does not instruct reading unrelated files, accessing environment secrets, or transmitting data externally. It describes a function signature but provides no implementation code.
Install Mechanism
This is an instruction-only skill with no install spec. Dependencies are Python packages (pandas, openpyxl) — reasonable for the task, but the skill does not provide how/when those packages will be installed or whether a Python runtime is available.
Credentials
No environment variables, credentials, or config paths are requested. The skill does not ask for unrelated secrets or broad system access.
Persistence & Privilege
No elevated privileges requested: always:false and user-invocable:true. The skill does not request to modify other skills or system-wide settings.
如何使用
- 确保已安装 OpenClaw（本地或 Docker 部署）
- 在对话框中输入安装命令：
/install excel-clean - 安装完成后，直接呼叫该 Skill 的名称或使用
/excel-clean触发 - 根据 Skill 的参数说明提供必要输入，即可获得结构化输出
版本历史
v1.0.0
首发
元数据
常见问题
excel-clean 是什么？
Clean Excel data — deduplication, fill missing values, format conversion. 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件，目前累计下载 97 次。
如何安装 excel-clean？
在 OpenClaw 或 Claude Code 对话框中运行命令「/install excel-clean」即可一键安装，无需额外配置。
excel-clean 是免费的吗？
是的，excel-clean 完全免费，采用 MIT-0 许可证，可自由下载、安装和使用。
excel-clean 支持哪些平台？
excel-clean 跨平台运行，可在任意部署了 OpenClaw / Claude Code 的环境中使用（cross-platform）。
谁开发了 excel-clean？
由 Martin-SH-Ni（@martin-sh-ni）开发并维护，当前版本 v1.0.0。
推荐 Skills