xlsx-author
- Repo stars 29,745
- Author repo financial-services
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_*.
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.
How to build the workbook
Write a short Python script and run it with Bash. Use openpyxl:
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)
- 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.
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.
- Fluxly category
- Data
- Author-declared agents
- No explicit declaration found; this is not inferred or tested compatibility
- Static check
- 88 / 100 · heuristic scan, not runtime safety proof
- Author / version / license
- @anthropics · no license declared
- Fluxly token estimate
- Lean
- Fluxly setup estimate
- Plug-and-play
- External API key
- No requirement detected
- Detected OS requirements
- Unspecified
- Runtime requirements
- Python
- Detected file/system behavior
-
- Read-only
- Write / modify
- Detected network behavior
- Local-only
- Install commands
- None (reference only)
Profile is derived at build time from SKILL.md and install vectors. Subject to drift from author intent.
Heads up: 未限定 allowed-tools,默认拥有全部工具权限。
The current SKILL.md does not define a fixed output example. 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.
Write a short Python script and run it with Bash. Use openpyxl:
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.
If mcpofficeexcel 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.
# 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_*`.
## 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.
## 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")
```
## Conventions (mirror `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.
## 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. Author text anchors workflow facts; Fluxly only indexes current sections, terms, files, and commands.
sections -> Output contract → How to build the workbook → Conventions (mirror audit-xls) → When NOT to use
terms -> headless · file artifact · Blue / black / green. · No hardcodes in calc cells. · Named ranges · Balance checks. · One model per file.
files/cmd -> mcpofficeexcel · ./out/<name>.xlsx · ./out/ · openpyxl · audit-xls
body sha256 -> 65403805a00a
Decide Fit First
Design Intent
How To Use It
Boundaries And Review