Can I use this skill to update existing financial models?

Yes. The skill is specifically designed to study existing templates and match their formatting, styles, and conventions, ensuring that updates are seamless and non-disruptive.

How does this skill handle Excel formula recalculation?

The skill uses a dedicated recalc.py script that leverages LibreOffice to evaluate formulas after creation, ensuring that the final file contains accurate calculated values rather than just formula strings.

What Python libraries are required for this skill?

It primarily uses pandas for heavy data manipulation and openpyxl for granular control over Excel formatting, styles, and formula placement.

Does it support standard financial color-coding?

Absolutely. By default, it follows industry standards: blue text for hardcoded inputs, black for formulas, green for internal links, and red for external references.

How does it prevent common formula errors?

It includes a verification checklist and automated error scanning that detects #REF!, #DIV/0!, and other common spreadsheet errors during the recalculation phase.

Advanced Excel & Spreadsheet Automation

Name: Advanced Excel & Spreadsheet Automation
Author: alijilani-dev

byalijilani-dev

0•

Data Science & ML

Manages complex spreadsheet creation, data analysis, and formula-driven financial modeling with high precision.

The xlsx skill empowers Claude to perform sophisticated spreadsheet operations, ranging from simple CSV parsing to building professional-grade financial models. It leverages powerful Python libraries like pandas and openpyxl to manipulate data while ensuring formula integrity through automated recalculation scripts. This skill is particularly useful for users needing to automate recurring reports, analyze large datasets, or generate dynamic Excel files that adhere to industry-standard formatting and color-coding conventions without manual intervention.

Key Features

01Preservation of existing spreadsheet templates and established style conventions

02Automated formula recalculation and error detection with LibreOffice integration

03Industry-standard financial modeling color coding and number formatting

04Seamless conversion between pandas DataFrames and formatted Excel workbooks

05Comprehensive support for complex Excel functions, cross-sheet references, and visualizations

060 GitHub stars

Use Cases

01Auditing and fixing formula errors (#REF!, #DIV/0!) in existing high-stakes spreadsheets

02Building dynamic financial models with automated scenario analysis and standardized formatting

03Automating data extraction from raw CSV/TSV files into structured, formatted Excel reports

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add alijilani-dev/claude xlsx

For use in Claude.ai and ChatGPT

Download Skill