Back to Details

xlsx-author

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

xlsx-author

xlsx-author

Use this skill when running headless (managed-agent / CMA mode) and you need to deliver an Excel workbook as a file artifact rather than editing a live workbook via 
mcp__office__excel_*
.
当以无头模式（托管Agent/CMA模式）运行，且需要将Excel工作簿作为文件产物交付，而非通过
mcp__office__excel_*
编辑实时工作簿时，可使用此技能。

Output contract

输出约定

  • Write to 
    ./out/<name>.xlsx
    . Create 
    ./out/
    if it does not exist.
  • Return the relative path in your final message so the orchestration layer can collect it.
  • 写入至
    ./out/<name>.xlsx
    。若
    ./out/
    目录不存在则创建该目录。
  • 在最终消息中返回相对路径，以便编排层收集文件。

How to build the workbook

工作簿构建方法

Write a short Python script and run it with Bash. Use 
openpyxl
:
python
from openpyxl import Workbook
from openpyxl.styles import Font, PatternFill

wb = Workbook()
ws = wb.active; ws.title = "Inputs"
ws["B2"] = "Revenue"; ws["C2"] = 1_250_000_000
ws["C2"].font = Font(color="0000FF")           # blue = hardcoded input
calc = wb.create_sheet("DCF")
calc["C5"] = "=Inputs!C2*(1+Inputs!C3)"        # black = formula
wb.save("./out/model.xlsx")
编写简短的Python脚本并通过Bash运行。使用
openpyxl
库：
python
from openpyxl import Workbook
from openpyxl.styles import Font, PatternFill

wb = Workbook()
ws = wb.active; ws.title = "Inputs"
ws["B2"] = "Revenue"; ws["C2"] = 1_250_000_000
ws["C2"].font = Font(color="0000FF")           # blue = hardcoded input
calc = wb.create_sheet("DCF")
calc["C5"] = "=Inputs!C2*(1+Inputs!C3)"        # black = formula
wb.save("./out/model.xlsx")

Conventions (mirror 
audit-xls
)

约定（镜像
audit-xls
）

  • Blue / black / green. Blue = hardcoded input, black = formula, green = link to another sheet/file.
  • No hardcodes in calc cells. Every calculation cell is a formula; every input lives on an Inputs tab.
  • Named ranges for any value referenced from a deck or memo.
  • Balance checks. Include a Checks tab that ties (BS balances, CF ties to cash, etc.) and surfaces TRUE/FALSE.
  • One model per file. Do not append to an existing workbook unless explicitly asked.
  • 蓝色/黑色/绿色：蓝色代表硬编码输入，黑色代表公式，绿色代表链接至其他工作表/文件。
  • 计算单元格中无硬编码：每个计算单元格均为公式；所有输入都存放在Inputs标签页中。
  • 对于演示文稿或备忘录中引用的任何值，使用命名区域。
  • 余额检查：包含一个Checks标签页，用于验证（资产负债表余额、现金流与现金匹配等）并显示TRUE/FALSE结果。
  • 一个文件对应一个模型：除非明确要求，否则不要追加至现有工作簿。

When NOT to use

不适用场景

If 
mcp__office__excel_*
tools are available (Cowork plugin mode), use those instead — they drive the user's live workbook with review checkpoints. This skill is the file-producing fallback for headless runs.
如果
mcp__office__excel_*
工具可用（Cowork插件模式），则优先使用这些工具——它们可操作用户的实时工作簿并提供审核检查点。此技能是无头模式运行时生成文件的备选方案。