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

数据科学与机器学习

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.

主要功能

Preservation of existing spreadsheet templates and established style conventions
Automated formula recalculation and error detection with LibreOffice integration
Industry-standard financial modeling color coding and number formatting
Seamless conversion between pandas DataFrames and formatted Excel workbooks
Comprehensive support for complex Excel functions, cross-sheet references, and visualizations
0 GitHub stars

使用场景

Auditing and fixing formula errors (#REF!, #DIV/0!) in existing high-stakes spreadsheets
Building dynamic financial models with automated scenario analysis and standardized formatting
Automating data extraction from raw CSV/TSV files into structured, formatted Excel reports

关于

主要功能

Preservation of existing spreadsheet templates and established style conventions
Automated formula recalculation and error detection with LibreOffice integration
Industry-standard financial modeling color coding and number formatting
Seamless conversion between pandas DataFrames and formatted Excel workbooks
Comprehensive support for complex Excel functions, cross-sheet references, and visualizations
0 GitHub stars

使用场景

Auditing and fixing formula errors (#REF!, #DIV/0!) in existing high-stakes spreadsheets
Building dynamic financial models with automated scenario analysis and standardized formatting
Automating data extraction from raw CSV/TSV files into structured, formatted Excel reports