| name | xlsx-author |
| description | Produce a .xlsx workbook file on disk for headless sessions or artifact-based workflows instead of driving a live Excel workbook. Use when the user needs a workbook artifact created or updated from data and instructions. |
| metadata | {"short-description":"Author workbook artifacts on disk"} |
XLSX Author
Use this skill when running headless or when the user needs an Excel workbook delivered as a file artifact rather than editing a live workbook.
Use this skill for file-producing workflows. A configured document engine may
provide a live embedded editor or visual export, but workbook authoring remains
code-driven and works without that optional integration.
Output Contract
- Write to
./out/<name>.xlsx unless the user provides a different path.
- Create
./out/ if it does not exist.
- Return the relative path in the final message.
How To Build The Workbook
Write a short script and run it. Prefer openpyxl for Python-based workbook authoring.
from openpyxl import Workbook
from openpyxl.styles import Font
wb = Workbook()
ws = wb.active
ws.title = "Inputs"
ws["B2"] = "Revenue"
ws["C2"] = 1_250_000_000
ws["C2"].font = Font(color="0000FF")
calc = wb.create_sheet("DCF")
calc["C5"] = "=Inputs!C2*(1+Inputs!C3)"
wb.save("./out/model.xlsx")
Conventions
- Blue cells are hardcoded inputs.
- Black cells are formulas.
- Green cells are links to another sheet or file.
- Do not hardcode values in calculation cells.
- Put assumptions on an Inputs tab.
- Use named ranges for values referenced from a deck or memo.
- Include a Checks tab for balance checks, cash tie-outs, and other TRUE/FALSE controls.
- Keep one model per file unless the user explicitly asks to append to an existing workbook.
