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.

Install it, pinned
mdr add knowflow-ai/knowwork/office-xlsx@git:20261021.536ea09

Pins 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

The exact contents, by fingerprint
mdr add knowflow-ai/knowwork/office-xlsx@sha256:f2bcd6019bcc55aa

The 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.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_lky6okaa6i2kjylx.svg)](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.

versioncommittedcommitsizeaudit
git:20261021.536ea09 latest2026-10-21 536ea09 8,911 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 (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

GitHub

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

office-docx SKILL.md skill
knowflow-ai/knowwork · runtime-host/plugins/dsh-host/skills/office-docx/SKILL.md · 处理 Word 文档(.docx / .dotx)时使用。包括:用户提到 Word、docx、Word 文件、Word 模板,或要一份带目录、标题层级、页码、页眉信头等格式的正式文档;要从 .docx 里提取或重组内容;要在 Word…
git:20261021.536ea09 · audit A · 109 stars
office-pptx SKILL.md skill
knowflow-ai/knowwork · runtime-host/plugins/dsh-host/skills/office-pptx/SKILL.md · 只要涉及 .pptx / .potx 文件就用——不论它是输入、输出还是两者。包括:做演示稿、汇报 PPT、路演材料、幻灯片;读取、解析或提取任何 .pptx…
git:20261021.536ea09 · audit A · 109 stars

Every file in knowflow-ai/knowwork

Other files named office-xlsx

office-xlsx SKILL.md skill
open-octo/octo-agent · internal/skills/defaults/office-xlsx/SKILL.md · Create, read, and edit Excel (.xlsx) spreadsheets programmatically with openpyxl — cell values, formulas, styling…
git:20260702.215028f · audit B · 142 stars

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