← Back to Skills Marketplace
119
Downloads
0
Stars
0
Active Installs
1
Versions
Install in OpenClaw
/install testcase-filter
Description
筛选测试用例Excel文件，提取P0/P1优先级用例，删除项目/产品列，重新编号并保持原格式
Usage Guidance
总体上这是一个功能与描述一致的 Excel 处理工具，但在安装或运行前请注意：
- 不要直接运行仓库中的 batch_process.py、check_headers.py 或 verify_output.py，除非你已检查并修改其中的硬编码路径，否则它们会尝试访问开发者机器上的特定路径。\n- 在受控环境（例如虚拟环境或隔离的测试机器）中先运行并用备份的 Excel 文件验证输出。\n- 如果只需主功能，调用 testcase_filter.process_excel(...) 或运行通过 setup.py 安装后的控制台脚本（并在命令行中显式指定输入/输出路径）。\n- 若在企业环境中使用，审查代码以确认没有额外日志/上报逻辑后再部署；可在本地替换或删除带绝对路径的示例脚本以消除误操作风险。
Capability Analysis
Type: OpenClaw Skill
Name: testcase-filter
Version: 1.0.0
The skill is a legitimate utility designed to filter Excel test case files by priority (P0/P1) and reformat them using the openpyxl library. While several helper scripts (batch_process.py, check_headers.py, and verify_output.py) contain hardcoded file paths specific to a developer's local environment (C:\Users\yanghua1\...), the core logic in testcase_filter.py is focused entirely on file manipulation and lacks any indicators of malicious intent, such as data exfiltration, network communication, or unauthorized command execution.
Capability Assessment
Purpose & Capability
Skill 名称、描述、SKILL.md 与主模块 testcase_filter.py 的实现相符：查找优先级/编号列、拆分合并单元格、删除项目/产品列、筛选 P0/P1、重新编号并复制样式。setup.py 列出的依赖（openpyxl）与实现一致。
Instruction Scope
SKILL.md 的运行说明本身只建议调用 process_excel(input_file, output_file) 并不会要求访问网络或任意系统区域。但仓库中存在若干辅助脚本（batch_process.py、check_headers.py、verify_output.py）包含硬编码的绝对 Windows 路径（例如 C:\Users\yanghua1\...）和对特定本地文件的直接读取，这些文件若被直接运行会访问本地文件系统。该行为可以是开发遗留问题而非恶意，但它增加了误执行本地文件的风险，应在运行前审查或移除这些脚本。
Install Mechanism
无安装规范（instruction-only 风格），仅在源码中通过 setup.py 提供可选安装项，依赖仅为 openpyxl（在 SKILL.md 与 setup.py 中一致）。没有从不可信 URL 下载或执行远程代码的安装指令。
Credentials
不要求环境变量、凭据或配置路径；所需权限仅限于读取/写入用户指定的 Excel 文件，与技能目的相符。
Persistence & Privilege
flags 显示 always:false、user-invocable:true，技能不会强制常驻或修改其他技能/全局配置。代码也不尝试持久化凭据或改变平台级设置。
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install testcase-filter - After installation, invoke the skill by name or use
/testcase-filter - Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.0
Initial release of testcase-filter.
- Filters Excel test case files to extract P0/P1 priority cases only.
- Deletes project/product columns automatically.
- Renumbers remaining test cases starting from TC001 for each sheet.
- Splits merged cells and fills content to all resulting cells.
- Skips sheets without a priority column or with empty priority columns.
- Preserves all original formatting, styles, and layout in the output file.
Metadata
Frequently Asked Questions
What is '提取高优先级测试用例'?
筛选测试用例Excel文件，提取P0/P1优先级用例，删除项目/产品列，重新编号并保持原格式. It is an AI Agent Skill for Claude Code / OpenClaw, with 119 downloads so far.
How do I install '提取高优先级测试用例'?
Run "/install testcase-filter" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is '提取高优先级测试用例' free?
Yes, '提取高优先级测试用例' is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does '提取高优先级测试用例' support?
'提取高优先级测试用例' is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created '提取高优先级测试用例'?
It is built and maintained by yontlly (@yontlly); the current version is v1.0.0.
More Skills