BiSheng XLSX Workbook Builder

What it does

When your agent uses it

• Building a budget, quotation or ledger spreadsheet from scratch
• Exporting prepared data to a workbook with formulas and formatting
• Cleaning an uploaded CSV or XLS file into a standard sheet
• Filling a user's xlsx template with new numbers
• Recalculating and checking a workbook before handing it over

Example prompts

• “Make an Excel budget with monthly columns and total formulas, then recalculate it.”
• “Clean the uploaded customers.csv and write it out as a formatted xlsx workbook.”
• “Fill the attached quotation template with these line items and keep its formulas.”

Requirements

• BiSheng's code executor with openpyxl
• LibreOffice for formula recalculation

Workflow steps

10 steps, taken from the step headings in SKILL.md.

1. 1开工纪律
2. 2环境事实（照做，不要试探）
3. 3选路线
4. 4从零构建
5. 5重算公式（有公式就必做）
6. 6改用户上传的表
7. 7交付前体检（必做）
8. 8公式红线（体检会拦，但你一开始就别写）
9. 9交付纪律
10. 10绝不要做的事

What it can do on your machine

Read from SKILL.md and the folder at commit ed3b461. It shows what the files ask for, not the result of running them.

• Tool permissions

  Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

  From allowed-tools in the SKILL.md frontmatter.

• Runs code

  Ships 3 files in scripts/ (Python), which the agent can run.

  Shell commands in SKILL.md call:

  • pip
  • npm
  • python

  From the folder's file list and the shell code blocks in SKILL.md.

• Network

  No URLs in SKILL.md. Its commands use pip and npm, which can reach the network depending on how they are called.

  From URLs in SKILL.md, links to its own repository left out.

• Credentials

  Names no API keys, tokens, secrets or passwords.

  From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

BiSheng XLSX Workbook Builder loads about 1.7k tokens when it runs, and up to ~5.1k if it reads all its reference files. Until then it costs about 97 tokens; SKILL.md has 396 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it

~97

When it runs · the whole SKILL.md, loaded when a task matches

~1.7k

With references · SKILL.md plus every file in references/, read only if the agent opens them

~5.1k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); the scripts in this folder are not scanned.

SKILL.md

The full file from dataelement/bisheng at commit ed3b461, republished under its Apache-2.0 licence (© dataelement). 396 words, ~1,728 tokens.

name

bisheng-xlsx

description

制作或修改 Excel 表格（.xlsx）时使用：从零搭建数据表、明细表、汇总表、预算表、财务模型、 测算表、报价单、台账、看板底表；把整理好的数据导出成带公式和格式的工作簿；读取、清洗、 改写用户上传的 .xlsx/.xls/.csv。当用户说到「Excel」「表格」「工作簿」「xlsx」「报表」「台账」 「预算表」「测算」「明细表」「数据透视」「导出成表」，或提出「把这些数据做成 Excel」 「按这个模板填一张表」「帮我算一下并出个表」时触发。本技能给出 BiSheng 代码执行器里 唯一可行的 openpyxl 路径（该环境没有 markitdown，公式必须用 LibreOffice 重算才有值）， 以及中文表格规范、审计配色、公式禁用清单、交付前的重算与体检脚本。 如果用户要的是图表图片、Word 文档或 PPT，不要用本技能。

metadata.display-name

Excel 表格制作（BiSheng 适配）

import shutil
try:
    import openpyxl
    print("openpyxl OK", openpyxl.__version__)
except ImportError:
    print("openpyxl MISSING")
print("soffice:", shutil.which("soffice") or shutil.which("libreoffice") or "无 —— 公式无法重算，见 §4 降级方案")

import subprocess, sys
r = subprocess.run([sys.executable, "scratch/build_sheet.py"], capture_output=True, text=True)
print(r.stdout or "(no stdout)")
print(r.stderr[-2000:] if r.stderr else "(no stderr)")

import subprocess, sys
r = subprocess.run([sys.executable, "skills/bisheng-xlsx/scripts/recalc_check.py", "output/xxx.xlsx"],
                   capture_output=True, text=True)
print(r.stdout or "(no stdout)")
print(r.stderr[-2000:] if r.stderr else "(no stderr)")

import subprocess, sys
r = subprocess.run([sys.executable, "skills/bisheng-xlsx/scripts/inspect_workbook.py",
                    "uploads/原表.xlsx", "--content-only"], capture_output=True, text=True)
print(r.stdout or "(no stdout)")
print(r.stderr[-2000:] if r.stderr else "(no stderr)")

import subprocess, sys
r = subprocess.run([sys.executable, "skills/bisheng-xlsx/scripts/inspect_workbook.py", "output/xxx.xlsx"],
                   capture_output=True, text=True)
print(r.stdout or "(no stdout)")
print(r.stderr[-2000:] if r.stderr else "(no stderr)")

© dataelement, Apache-2.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 5 other files (scripts, references) in src/backend/bisheng/linsight/builtin_skills/bisheng-xlsx of dataelement/bisheng.

• SKILL.md
• references/design-zh.md
• references/openpyxl-cookbook.md
• scripts/inspect_workbook.py
• scripts/recalc_check.py
• scripts/xlsx_helpers.py

Open the folder on GitHubat commit ed3b461