office-excel SKILL.md skillA
office-excel from huiliyi37/tianshu-harness is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.
mdr add huiliyi37/tianshu-harness/office-excel@git:20260720.5237f6cPins git:20260720.5237f6c in mdr.lock. Pin the fingerprint instead.
- Audit grade
- A, 17 of 17 checks passed
- Kind
- SKILL.md skill
- Repository
- huiliyi37/tianshu-harness
- Path
plugins/office-excel/skills/SKILL.md- Versions recorded
- 1
- Latest version
- git:20260720.5237f6c, committed Jul 20, 2026
- Size
- 2,554 bytes
- Repository stars
- 1,254
- License
- Apache-2.0
Excel 电子表格读写与编辑最佳实践 — 用 xlsx_read/xlsx_write/xlsx_edit 处理 .xlsx 时遵守的公式、数字格式与可维护性纪律.
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
# Office Excel（.xlsx 读写纪律）
> 改编自 anthropics/skills xlsx（Apache 2.0）。
用本插件（`xlsx_read` / `xlsx_write` / `xlsx_edit`）交付 Excel 文件时，遵守以下纪律。
## 1. 能用公式绝不硬编码计算值
- 汇总、合计、比率一律写公式（`{ formula: 'SUM(B2:B10)' }`），不要把算好的结果写死。
- 交付的表格必须保持**动态可重算**：用户改了源数据，合计列应自动更新。写死的数字会在源数据变更后悄悄变成错误答案。
- 公式在 `xlsx_read` 中以 `=SUM(...)` 原文显示，交付前读回自查一遍公式是否正确。
## 2. 零公式错误纪律
`#REF!` / `#DIV/0!` / `#VALUE!` / `#NAME?` 一个都不允许出现在交付物里。常见成因与预防：
- **行列从 1 开始**：`A1` 是第一个单元格，不存在第 0 行/第 0 列。越界引用直接 `#REF!`。
- **跨 sheet 引用**用 `Sheet1!A1` 语法；sheet 名含空格或特殊字符时用单引号 `'My Sheet'!A1`。
- **除零检查**：除法公式先确认分母列无空值/零值，必要时 `IF(B2=0, 0, A2/B2)`。
- **类型一致**：文本列与数字列混算得 `#VALUE!`；写入时不要把数字写成带引号的字符串。
- **函数名拼写**：`#NAME?` 几乎都是函数名拼错或用了不存在的函数。
## 3. 数字格式约定（用 number_formats 设置）
- 货币：`$#,##0`（或 `¥#,##0`）
- 百分比：`0.0%`
- 倍数：`0.0x`
- 负数用括号表示：`#,##0;(#,##0)`
- **年份作为文本**写入（如 `'2024`），防止被加千分位显示成 `2,024`
## 4. 假设参数放独立单元格
- 增长率、折扣率、汇率等假设值单独放一个单元格，公式引用它：`=B5*(1+$B$6)`，而不是 `=B5*1.05`。
- 用 `$B$6` 绝对引用锁定假设单元格，下拉填充时不会漂移。
- 这样用户改假设即可全表重算，不用改任何公式。
## 5. 修改已有模板时沿用其既有约定
- 用 `xlsx_read` 先看清原文件的表头、格式、公式风格，再动手。
- 严格沿用模板自己的数字格式、列宽、命名习惯——**不把自己的风格强加进去**。
- 只改该改的单元格（`xlsx_edit` 的 `update_cells` / `append_rows`），不要整体重写文件。Read the whole file at its exact version.
How to install
mdr add huiliyi37/tianshu-harness/office-excel@sha256:6f87ea2c45bf5ed6The line at the top of this page pins the label git:20260720.5237f6c, 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.
[](https://markdownregistry.com/a/art_wilfioxpf3dfc36d)
3 badge image fetches in 30 days. What the badge shows.
Versions
The registry has recorded 1 version of this file, committed on Jul 20, 2026.
Audit of the latest version
- pass: Frontmatter block present
- pass: Frontmatter declares a name
- pass: Frontmatter declares a description
- pass: Size between 200 bytes and 200 KB (2554 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
huiliyi37/tianshu-harness · 1,254 stars · license Apache-2.0 · pushed 2026-10-31 · branch main
API
GET https://markdownregistry.com/api/v1/artifacts/art_wilfioxpf3dfc36d GET https://markdownregistry.com/api/v1/resolve?ref=huiliyi37/tianshu-harness/office-excel GET https://markdownregistry.com/api/v1/blob/6f87ea2c45bf5ed6010f0bc0beeb002912955e8198d69a058996a5f2f6d7f358
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 huiliyi37/tianshu-harness
Every file in huiliyi37/tianshu-harness