Does this skill support existing Excel formulas?

Yes, it is designed to read, preserve, and modify existing formulas using openpyxl, ensuring that spreadsheets remain dynamic rather than static.

How does it handle formula errors like #REF! or #DIV/0!?

The skill includes a mandatory recalculation step using a LibreOffice-based script (recalc.py) that scans all cells for errors and requires fixes before the file is considered complete.

Is it better for data processing or visual formatting?

It excels at both by using pandas for efficient data manipulation and openpyxl for granular control over fonts, colors, borders, and cell alignment.

Can I use this for professional financial models?

Absolutely. The skill follows industry-standard conventions such as blue text for hardcoded inputs and black text for formulas, and enforces strict documentation for data sources.

Do I need any external software to use the recalculation feature?

Yes, it assumes LibreOffice is installed. The recalc.py script automatically configures the necessary environment to evaluate formulas and detect errors across all worksheets.

Excel & Spreadsheet Expert

Name: Excel & Spreadsheet Expert
Author: macnversion

bymacnversion

数据科学与机器学习

Automates the creation, editing, and analysis of professional Excel spreadsheets with advanced formula support and industry-standard financial modeling.

关于

This skill provides a robust framework for Claude to interact with Excel files (.xlsx, .xlsm, .csv) at a professional level. It goes beyond simple data dumping by enforcing strict financial modeling standards, such as color-coding hardcodes and formulas, preserving existing template styles, and ensuring zero formula errors through automated LibreOffice recalculation. By combining the data processing power of pandas with the granular formatting capabilities of openpyxl, it allows for the generation of dynamic, production-ready workbooks that are ready for immediate corporate use.

主要功能

Automated formula verification and error detection using LibreOffice integration
0 GitHub stars
Industry-standard financial model formatting and color-coding conventions
Smart template preservation that respects existing workbook styles
Comprehensive support for data analysis, visualization, and multi-sheet management
Dynamic formula construction to avoid brittle hardcoded values

使用场景

Performing complex data analysis on large datasets and exporting results to formatted Excel reports
Building automated financial projection models with separate assumption sheets and dynamic growth rates
Updating corporate spreadsheet templates while maintaining strict adherence to existing formatting patterns

关于

主要功能

Automated formula verification and error detection using LibreOffice integration
0 GitHub stars
Industry-standard financial model formatting and color-coding conventions
Smart template preservation that respects existing workbook styles
Comprehensive support for data analysis, visualization, and multi-sheet management
Dynamic formula construction to avoid brittle hardcoded values

使用场景

Performing complex data analysis on large datasets and exporting results to formatted Excel reports
Building automated financial projection models with separate assumption sheets and dynamic growth rates
Updating corporate spreadsheet templates while maintaining strict adherence to existing formatting patterns