skills.rest
hkw2028
hkw2028COMMUNITY
Explore all skills by this author →
GitHub

xlsx-author

Generate .xlsx workbook files with openpyxl in headless agent sessions.

Updated Sep 17, 2026
Search Tags:#python#financial modeling#openpyxl#excel#xlsx#headless#workbook generation
One-click install
npx skills add https://github.com/hkw2028/toy-project --skill xlsx-author-hkw2028
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx-author
Source: https://github.com/hkw2028/toy-project/tree/main/.agents/skills/xlsx-author
Command: npx skills add https://github.com/hkw2028/toy-project --skill xlsx-author-hkw2028

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl.

What problem does it solve? In headless or managed-agent environments there is no live Excel application to drive, so workbook deliverables must be produced as files on disk rather than through interactive Office tooling. ## Core Features & Use Cases - File-based workbook authoring: Writes .xlsx files to ./out/ using Python and openpyxl, returning the relative path for orchestration layers to collect. - Financial modeling conventions: Enforces blue/black/green font color coding, formula-only calculation cells, named ranges, and a Checks tab with balance validations. - Use Case: A headless agent is asked to build a DCF model; it writes a Python script that creates an Inputs tab with hardcoded assumptions, a DCF tab with formulas referencing those inputs, and a Checks tab, then saves ./out/model.xlsx. ## Quick Start Ask the agent to build an Excel workbook as a file, for example: create a DCF model with an Inputs tab and save it as an .xlsx file in the out folder.

Frequently Asked Questions about xlsx-author

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I create an Excel file in Python without opening Excel?▼

Use the openpyxl library to build a Workbook object, populate worksheets with values and formulas, apply styles like Font and PatternFill, then call wb.save() to write the .xlsx file to disk. No Excel installation is required.

How to write Excel formulas with openpyxl?▼

Assign the formula string directly to a cell, for example ws["C5"] = "=Inputs!C2*(1+Inputs!C3)". openpyxl stores the formula text, and Excel evaluates it when the file is opened.

When should I use file-based xlsx generation instead of Office MCP tools?▼

Use file-based generation in headless or managed-agent sessions where no live Office application is available. When mcp__office__excel_* tools are available in Cowork plugin mode, prefer those since they drive the user's live workbook with review checkpoints.

What are the blue, black, and green font conventions in financial models?▼

Blue marks hardcoded inputs, black marks formulas, and green marks links to other sheets or files. This color coding lets reviewers instantly distinguish assumptions from calculations in a workbook.

Can openpyxl append data to an existing xlsx workbook?▼

openpyxl can load and modify existing workbooks, but this skill follows a one-model-per-file convention and does not append to existing workbooks unless explicitly requested. Each run produces a fresh file in ./out/.

Related Skills

Explore More Finance & Accounting Skills→
MuzeWinterMuzeWinter
1

model-audit-tieout

Audit Excel financial models for formula integrity and source tie-outs.

Community
Advanced
opensquillaopensquilla
6.8k

meta-multi-format-export-pack

Renders one source content into docx, pptx, xlsx, and PDF deliverables.

Official
Intermediate
atlasgroupczatlasgroupcz
2

xlsx

Create and edit Excel workbooks with formulas, formatting, and recalculation-based verification.

Official
Intermediate
innFactory-AIinnFactory-AI

excel-skill

Create, read, and modify Excel spreadsheets via companyFILES MCP tools.

Official
Intermediate