excel-author

Automates auditable Excel workbook creation with headless Python and openpyxl.

Updated Jun 17, 2026

Search Tags:#openpyxl #spreadsheet #excel #data-integrity #financial-modeling #auditable

Ready to run

npx skills add https://github.com/anilcan-kara/nozich-agent --skill excel-author-anilcan-kara

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: excel-author
Source: https://github.com/anilcan-kara/nozich-agent/tree/main/optional-skills/finance/excel-author
Command: npx skills add https://github.com/anilcan-kara/nozich-agent --skill excel-author-anilcan-kara

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

Build auditable Excel workbooks headless with openpyxl — blue/black/green cell conventions, formulas over hardcodes, named ranges, balance checks, sensitivity tables. Use for financial models, audit outputs, reconciliations.

Core Features & Use Cases

Blue/black/green cell conventions for inputs, calculations, and links to ensure clarity and auditability.
Formulas over hardcodes to maintain dynamic and transparent models.
Named ranges to simplify cross-sheet references and external consumption.
Balance checks and sensitivity tables to validate integrity and support scenario analysis.
Designed for headless execution to generate auditable Excel workbooks in automated pipelines.

Quick Start

Create an auditable Excel workbook on disk using openpyxl that applies blue inputs, black formulas, and green links.

Frequently Asked Questions about excel-author

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

FAQPage Schema

How do I build auditable Excel financial models headlessly in Python?▼

Build auditable Excel financial models headlessly by using openpyxl to apply blue inputs, black formulas, and green links, generating workbooks with transparent formulas and named ranges for strict data integrity.

What is the blue black green cell convention for spreadsheet auditing?▼

The blue black green cell convention for spreadsheet auditing color-codes blue for inputs, black for calculations, and green for cross-sheet links, ensuring clarity and structural transparency for auditable financial models.

Can I create Excel balance checks and sensitivity tables without opening Excel?▼

You can create Excel balance checks and sensitivity tables without opening Excel by running headless Python scripts that validate data integrity and support scenario analysis directly on disk.

Does openpyxl support named ranges for financial modeling and reconciliations?▼

openpyxl supports named ranges for financial modeling and reconciliations, allowing automated workbooks to simplify cross-sheet references and external consumption while maintaining transparent formulas over hardcodes.

How do I generate a Checks tab for data integrity in automated Excel outputs?▼

Generate a Checks tab for data integrity in automated Excel outputs by using headless Python to insert balance checks directly into the workbook, validating calculation accuracy without manual review.

Why use formulas over hardcodes when automating Excel workbook generation?▼

Use formulas over hardcodes when automating Excel workbook generation to maintain dynamic and transparent models, ensuring downstream calculations update automatically and remain fully auditable.