office-xlsx SKILL.md skillA
office-xlsx from knowflow-ai/knowwork is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.
mdr add knowflow-ai/knowwork/office-xlsx@git:20261021.536ea09Pins git:20261021.536ea09 in mdr.lock. Pin the fingerprint instead.
- Audit grade
- A, 17 of 17 checks passed
- Kind
- SKILL.md skill
- Repository
- knowflow-ai/knowwork
- Path
runtime-host/plugins/dsh-host/skills/office-xlsx/SKILL.md- Versions recorded
- 1
- Latest version
- git:20261021.536ea09, committed Oct 21, 2026
- Size
- 8,911 bytes
- Repository stars
- 109
- License
- Apache-2.0
表格文件是主要输入或输出时使用。包括:打开、读取、修改或修复已有的 .xlsx、.xlsm、.xltx、.csv、.tsv 文件(加列、算公式、调格式、画图表、清洗脏数据);从零或从其他数据来源新建表格;在表格格式之间转换。用户提到某个表格文件名时尤其要用——哪怕说得很随意(比如"我传的那个 Excel")——只要他要对它做点什么或从它产出东西。把格式混乱的表格数据(错行、表头错位、垃圾数据)整理成规范表格也用它。交付物必须是表格文件。主要交付物是 Word 文档、HTML 报告、单独的 Python 脚本、数据库流程或在线表格接口时,即使涉及表格数据也不要用。.
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
# XLSX:生成、修改与分析
| 任务 | 做法 |
|---|---|
| 带公式/格式地**生成**或**修改** | `openpyxl`——坑点见下 |
| **大批量**数据读写 | `pandas`(`read_excel`、`to_excel`) |
| **快速看一眼**某张表 | `markitdown 文件.xlsx`——每张表一个 `## 表名`,也能读 `.xlsm`。没有单元格坐标,不要据此规划修改 |
| **读懂**一个模型(公式**和**值) | `load_workbook` 读两遍——见坑点 |
> `openpyxl`、`pandas`、`markitdown` 都已装好,直接 import。沙箱没有网络,不要 `pip install`。
> 脚本在 `/opt/knowwork/office/`。用户给的原文件在 `/workspace/input`(只读),中间文件放
> `/workspace/tmp`,要交给用户的放 `/workspace/output`,写好后调用 `present` 交付(例如 `present({"files":[{"path":"/workspace/output/表格.xlsx"}]})`)。
## 每份输出的要求
- **全表用正规字体**(Arial、Times New Roman;中文内容用 等线 或 微软雅黑),用户另有要求除外。
- **零公式错误。** `recalc.py` 报 `errors_found` 时绝不交付。你认为某个错误是原来就有的,就证明它:
用 `data_only=True` 打开**原文件**看那个格子。你引入的错误和继承来的错误看起来一模一样。
- **用公式,不要写死结果。** 写 `sheet['B10'] = '=SUM(B2:B9)'`,而不是 Python 算好的合计。输入变了,
表格要能自己重算。
- **严格按用户的要求做。** 表名、列标题、用户写出来的公式都一字不差。算的是别的东西的"重新设计",
再漂亮也是失败。
- **每个假设和写死的数字都要写明**,写在读的人看得到的地方——单元格批注,或表格末尾相邻的格子。
有真实出处就注明(`来源:公司 2024 年年报,第 45 页,营业收入附注`);数字是用户给的,就直说。
- **你新建、要别人填写的表格**,要有一段简短的图例说明哪些格子可以改,并给一行真实的示例数据示范格式。
要求你**修改**的文件里绝不要加这样的示例行。
- **修改已有文件:完全遵循它的惯例。** 它的惯例优先于这里的所有规则。先找出它指定的输入格——
特别的字体颜色、填充或底纹通常就是标记——只往那里写,已有的公式一个都不动。
…Read the whole file at its exact version.
How to install
mdr add knowflow-ai/knowwork/office-xlsx@sha256:f2bcd6019bcc55aaThe line at the top of this page pins the label git:20261021.536ea09, 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_lky6okaa6i2kjylx)
0 badge image fetches in 30 days. What the badge shows.
Versions
The registry has recorded 1 version of this file, committed on Oct 21, 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 (8911 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
knowflow-ai/knowwork · 109 stars · license Apache-2.0 · pushed 2026-11-07 · branch main
API
GET https://markdownregistry.com/api/v1/artifacts/art_lky6okaa6i2kjylx GET https://markdownregistry.com/api/v1/resolve?ref=knowflow-ai/knowwork/office-xlsx GET https://markdownregistry.com/api/v1/blob/f2bcd6019bcc55aac08cfce14b561e4fb22196f0b67726369eb06af2a888c06f
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 knowflow-ai/knowwork
Every file in knowflow-ai/knowwork