---
name: "openpyxl-financial-model-builder"
description: "Build dynamic, multi-tab financial forecast models with Excel formulas using openpyxl."
metadata:
  author: "openpyxl"
  version: "1.0.0"
  runtime_compatibility:
    - "codex"
    - "claude-code"
    - "cursor"
    - "windsurf"
triggers:
  - "create excel financial model python"
  - "write excel formulas openpyxl"
  - "format currency in excel python"
permissions:
  fs_read: true
  fs_write: "workspace"
  shell_exec: false
  net_access: false
---

# openpyxl Financial Model Builder

Generates complex financial workbooks: multi-sheet linking, SUM/INDEX-MATCH dynamic formulas, number formatting (currency, percentages), and freeze panes.

## When to Invoke
Invoke this skill whenever you need to:
- create excel financial model python
- write excel formulas openpyxl
- format currency in excel python

## Execution SOP & Rules
1. Open workbooks with wb = Workbook() and create sheets using wb.create_sheet(title="Financials").
2. Assign Excel formula strings directly to cell values: ws['D10'] = '=SUM(D5:D9)'.
3. Apply number formats via cell.number_format = '$#,##0.00' to preserve raw numeric values for audit.
4. Freeze header rows using ws.freeze_panes = 'A2' for seamless navigation.

## Verification Checklist
- Run local linting, syntax validation, and type-checks before reporting completion.
- Ensure all created or modified files adhere to workspace boundaries and avoid uncommitted secrets.
- Verify tests or build commands exit cleanly with return code 0.