excel-workbook SKILL.md skillA

excel-workbook from adongwanai/learn-workbuddy is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add adongwanai/learn-workbuddy/excel-workbook@git:20260923.cceec3e

Pins git:20260923.cceec3e in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
adongwanai/learn-workbuddy
Path
skills/excel-workbook/SKILL.md
Versions recorded
1
Latest version
git:20260923.cceec3e, committed Sep 23, 2026
Size
3,725 bytes
Repository stars
449
License
MIT

使用此 Skill 创建、检查、编辑和验证 XLSX 工作簿。用户提到 Excel、xlsx、工作簿、工作表、表格,或要求修改、汇总、检查 Excel 文件时使用。只支持基础 XLSX 操作,不处理宏、VBA、图表、数据透视表或外部工作簿引用。.

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# Excel 工作簿基础操作

当用户要求创建、检查、编辑或验证 `.xlsx` 文件时使用本 Skill。

## 支持范围

支持以下基础操作:

- 检查工作簿、工作表、行列范围、公式、日期和合并单元格;
- 创建包含表头、数据和简单公式的新工作簿;
- 编辑单元格、追加行和基础数字格式;
- 保留已有工作表、公式、日期、数据类型和未修改区域的基础样式;
- 重新打开输出文件,验证关键内容;
- 设置 Excel/WPS 打开文件时自动重算的标记。

当前版本只支持 `.xlsx`。不处理 `.xlsm` 宏、VBA、图表、数据透视表、
Power Query、外部工作簿引用或复杂财务模型。

## 工作原则

1. 先检查,再修改。
2. 默认不覆盖原文件;编辑时输入文件和输出文件必须是不同路径。
3. 修改现有模板时,只改用户指定的单元格或区域,不重建整个工作簿。
4. 日期、数字和公式要保持正确的数据类型。公式字符串被写入不等于公式已经计算。
5. 修改后必须重新打开输出文件并验证。
6. 没有 Excel、WPS 或 LibreOffice 重算结果时,不要声称公式结果已经验证。

## 工具脚本

脚本位于当前 Skill 的 `scripts/workbook_tool.py`:

```text
python scripts/workbook_tool.py inspect input.xlsx
python scripts/workbook_tool.py create output.xlsx --spec spec.json
python scripts/workbook_tool.py edit input.xlsx output.xlsx --operations operations.json
python scripts/workbook_tool.py validate output.xlsx --expect expectations.json
python scripts/workbook_tool.py recalc output.xlsx
```

所有命令默认输出 JSON,便于继续检查和记录。

### 创建数据格式

`create` 的 spec 使用以下结构:

```json
{
  "sheet": "销售数据",
  "headers": ["日期", "商品", "金额", "含税金额"],
  "rows": [
    [
      {"date": "2026-09-16"},
      "A",
      100,
      {"formula": "=C2*1.1"}
    ]
  ],
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add adongwanai/learn-workbuddy/excel-workbook@sha256:a06bd367851419b5

The line at the top of this page pins the label git:20260923.cceec3e, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_yf6zoz6r7gklsaal.svg)](https://markdownregistry.com/a/art_yf6zoz6r7gklsaal)

3 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 1 version of this file, committed on Sep 23, 2026.

versioncommittedcommitsizeaudit
git:20260923.cceec3e latest2026-09-23 cceec3e 3,725 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (3725 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

adongwanai/learn-workbuddy · 449 stars · license MIT · pushed 2026-10-20 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_yf6zoz6r7gklsaal
GET https://markdownregistry.com/api/v1/resolve?ref=adongwanai/learn-workbuddy/excel-workbook
GET https://markdownregistry.com/api/v1/blob/a06bd367851419b5cd37d7316a7c9db239b2bdd244eaffffb1ad02135a1aac37

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from adongwanai/learn-workbuddy

git-commit SKILL.md skill
adongwanai/learn-workbuddy · skills/git-commit/SKILL.md
git:20260708.defb837 · audit C · 449 stars

Every file in adongwanai/learn-workbuddy

Browse by kind, by grade A, or by owner.