
Description
Produce a .xlsx file on disk (headless) instead of driving a live Excel workbook — for managed-agent sessions with no open Office app.
SKILL.md
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.
More skills from the financial-services repository
View all 62 skills3-statement-model
fill out 3-statement financial models
May 15ExcelFinanceFinancial ModelingFinancial Statementsaccrual-schedule
build period-end accrual schedules
May 6AccountingFinanceJournal EntryMonth-End Closeai-readiness
identify AI opportunities in portfolio companies
May 21AI InfrastructureOperationsPrivate EquityStrategyaudit-xls
audit spreadsheets for formula accuracy
May 15AuditExcelFinanceSpreadsheetsbond-futures-basis
analyze bond futures basis
May 15DerivativesFinanceFixed IncomeTradingbond-relative-value
perform bond relative value analysis
May 15FinanceFixed IncomeTrading
More from Anthropic
View publisheralgorithmic-art
create algorithmic art with p5.js
skills
Apr 6CreativeDesignGenerative ArtJavaScriptbrand-guidelines
apply Anthropic brand colors and typography
skills
Apr 6BrandingDesignTypographycanvas-design
create posters and visual art as PNG or PDF
skills
Apr 6CreativeDesignPDFclaude-api
build apps with the Claude API
skills
Apr 6AgentsAnthropicAnthropic SDKClaude API +1doc-coauthoring
co-author documentation and technical specs
skills
Apr 6DocumentationTechnical Writingdocx
create and edit Word documents
skills
Jul 18DocumentsDOCXOfficeTemplates +1