skills.rest
jason660519
jason660519COMMUNITY
Explore all skills by this author →
GitHub

excel-author

Generate auditable Excel workbooks from Python using openpyxl.

Updated May 11, 2026
Search Tags:#openpyxl#excel#headless#financial-modeling#checks#auditable#named-ranges
One-click install
npx skills add https://github.com/jason660519/Project-Manager --skill excel-author-jason660519
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: excel-author
Source: https://github.com/jason660519/Project-Manager/tree/main/hermes-agent/optional-skills/finance/excel-author
Command: npx skills add https://github.com/jason660519/Project-Manager --skill excel-author-jason660519

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

Automates the creation of auditable Excel workbooks from Python, reducing manual modeling errors and improving reproducibility.

Core Features & Use Cases

  • Banker-grade conventions: blue cells for inputs, black for formulas, and green for links between sheets or external data.
  • Formulas over hardcodes: every calculation is a live Excel formula, with named ranges for cross-sheet references.
  • Data provenance and checks: includes a Checks tab and per-cell comments documenting data sources and dates.
  • Headless output: writes to ./out with a ready-to-deliver workbook suitable for automated pipelines or audits.

Quick Start

Generate an auditable Excel workbook on disk using openpyxl that follows the banker-grade conventions.

Frequently Asked Questions about excel-author

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

FAQPage Schema
How do I generate auditable Excel workbooks from Python without opening Excel?▼

You can generate auditable Excel workbooks headless using openpyxl in Python to enforce banker-grade conventions, live formulas, and named ranges, outputting a ready-to-deliver file directly to disk.

What are banker-grade conventions for financial modeling in Excel?▼

Banker-grade conventions for financial modeling enforce blue cells for inputs, black for formulas, and green for cross-sheet links, ensuring clear data provenance and reproducible calculations.

How do I create live Excel formulas instead of hardcoded values using openpyxl?▼

You can create live Excel formulas instead of hardcoded values by applying openpyxl to write formula strings directly into cells, utilizing named ranges for cross-sheet references to maintain calculation integrity.

Can I add a Checks tab and data provenance comments to an Excel workbook programmatically?▼

Yes, you can add a Checks tab and per-cell comments programmatically by using openpyxl to document data sources and dates, embedding audit-ready validation directly within the workbook structure.

Does openpyxl support deterministic cell styles for automated budgeting reports?▼

Yes, openpyxl supports deterministic cell styles for automated budgeting reports by allowing Python scripts to enforce consistent formatting rules, such as color-coded inputs and formulas, reproducibly.

Related Skills

Explore More Finance & Accounting Skills→
NONEitnonameNONEitnoname

xlsx

Create and edit Excel workbooks with formulas using OpenPyXL.

Community
Advanced
sheawinklersheawinkler
78

excel-author

Generate auditable Excel workbooks with openpyxl using formulas and named ranges.

Community
Intermediate
markwang2658markwang2658
31

excel-author

Build auditable Excel workbooks headless with openpyxl and named ranges.

Community
Advanced
aayushsoamaayushsoam
1

excel-author

Generates auditable Excel workbooks for financial models using openpyxl.

Community
Advanced