Does it support industry-standard financial formatting?

Absolutely. It follows strict conventions such as blue text for hardcoded inputs, black for formulas, green for internal worksheet links, and specific currency/percentage formatting rules.

Can it modify existing Excel templates without breaking them?

Yes, it is designed to study and match existing styles. It uses openpyxl to load workbooks, allowing it to insert data or modify cells while preserving established formatting and template conventions.

Why does it prefer Excel formulas over hardcoded Python results?

Using formulas ensures the spreadsheet remains dynamic. If the user changes an input value later in Excel, the entire model will update automatically, which is impossible with hardcoded values.

What Python libraries are required for this skill?

The skill primarily utilizes pandas for data-heavy analysis and openpyxl for detailed formatting, formula management, and sheet manipulation.

How does this skill handle Excel formula errors?

The skill uses a specialized recalc.py script powered by LibreOffice to recalculate all formulas and scan for errors like #REF!, #NAME?, or #DIV/0! before final delivery to ensure a broken model is never shipped.

xlsx Claude Code Skill: Advanced Excel & Financial Modeling

The xlsx skill empowers Claude to handle complex spreadsheet tasks by leveraging Python libraries like pandas and openpyxl alongside a dedicated recalculation engine. It specializes in generating dynamic financial models that follow strict industry standards—including specific color-coding for inputs and formulas—while ensuring zero formula errors through automated verification via LibreOffice. Whether you need to analyze large datasets, preserve existing template styles, or build multi-sheet workbooks from scratch, this skill provides a robust framework for professional-grade Excel automation within the Claude Code environment.

主要功能

01High-performance data analysis, visualization, and manipulation powered by pandas.

02Automated formula recalculation and error detection (REF!, DIV/0!) using LibreOffice integration.

03Industry-standard financial model formatting, including automated color-coding and number styles.

04Dynamic formula generation to replace hardcoded values and ensure spreadsheet reactivity.

052 GitHub stars

06Precision editing capabilities that preserve existing workbook templates and formatting conventions.

使用场景

01Batch updating corporate spreadsheet templates while maintaining legacy formatting and cross-sheet references.

02Generating automated financial projection models with validated formula integrity and standardized styling.

03Performing complex data analysis on large CSV or Excel datasets and exporting formatted executive summaries.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add organvm-iv-taxis/a-i--skills xlsx

For use in Claude.ai and ChatGPT

Download Skill