testcase-excel

生成可导入测试管理平台的手工测试用例 Excel，适用于用户要求测试用例 Excel、验收用例、用例导入表、把需求或实现转成测试用例表时使用。

IndexedMIT★ 8

Install

Works with Claude Code, Claude apps, Codex, Cursor, Gemini CLI, GitHub Copilot, VS Code, OpenCode, Goose, Windsurf. Read the repository before you give any tool access to your data.

npx agentmarket install skill/535803710-testcase-excel

Asks which of your tools to add it to (Claude Code, Codex, Cursor, VS Code, Windsurf, Gemini CLI, Claude Desktop) and shows the change first. See https://agentmart.dev/cli.

Get the weekly diff

The weekly diff: one email a week with new agent tools, notable updates and grade changes, plus security alerts for tools you follow. Double opt-in, one-click unsubscribe.

About

生成可导入测试管理平台的手工测试用例 Excel，适用于用户要求测试用例 Excel、验收用例、用例导入表、把需求或实现转成测试用例表时使用。

Use cases: spreadsheets

Reviews

Write a review

No reviews yet. Installed it? Reviews come from verified installers only. How reviews work

Permissions

What this skill can do and what it asks for, from its SKILL.md. Checked Oct 25, 2026.

Tools: No tools found
Secrets: None asked for
Install scripts: None found
Runs as: Python package

Network hosts it talks to 1

codeload.github.com · found in install command

Files it touches

~/.claude/skills/testcase-excel

What's inside

Skill name: testcase-excel
Description: 生成可导入测试管理平台的手工测试用例 Excel，适用于用户要求测试用例 Excel、验收用例、用例导入表、把需求或实现转成测试用例表时使用。
License: MIT
Instructions: 49 lines in SKILL.md · view on GitHub

Before installing

Ships executable scripts

Files (3)

SKILL.md
openai.yaml · agents/
generate_testcase_excel.py · scripts/

SKILL.md (first lines)

# Testcase Excel

## 目标

基于需求、技术说明、最终实现、已有测试点和人工走查结果，生成更贴近真实功能的测试用例 Excel。

## 工作方式

1. 先确认测试管理平台的导入字段。
2. 如果没有字段模板，使用默认通用字段。
3. 测试用例不要只来自原始需求，要结合最终实现和风险点。
4. 优先覆盖核心流程、权限、异常、空数据、回归场景。
5. 生成结构化 JSON 后，使用脚本导出 Excel。

## 默认字段

- 序号
- 用例名称
- 模块
- 优先级
- 用例类型
- 前置条件
- 测试步骤
- 预期结果
- 备注

## JSON 输入格式

```json
[
  {
    "module": "用户管理",
    "title": "按用户名查询用户列表",
    "priority": "P1",
    "type": "功能测试",
    "preconditions": "已登录并拥有查看权限",
    "steps": ["进入页面", "输入用户名", "点击查询"],
    "expected": ["列表刷新", "结果符合查询条件"],
    "remark": ""
  }
]
```

## 导出命令

```bash
python skills/testcase-excel/scripts/generate_testcase_excel.py --input testcases.json --output testcases.xlsx
```

From 535803710/ai-rd-skills, MIT.

Signals

Stars: 8
Forks: 1
Open issues: 0
Last commit (this folder): May 20, 2026 (5 months ago)

From GitHub (fetched Oct 24, 2026).

Details

License: MIT
Repository: github.com/535803710/ai-rd-skills
First seen: Oct 24, 2026
Last checked: Oct 24, 2026
Source: GitHub github-graphql

More from 535803710

Cite this page

testcase-excel skill. Agent Mart. https://agentmart.dev/skills/535803710-testcase-excel (last updated 2026-10-24)