Does this skill support existing Excel templates?

Yes, it is designed to study and exactly match existing formats, styles, and conventions to ensure seamless integration with your established spreadsheet patterns.

How does it ensure formula accuracy?

The skill uses a mandatory recalculation process via LibreOffice that identifies and reports errors like #REF! or #DIV/0!, ensuring every file is delivered error-free.

Can I use this for professional financial modeling?

Absolutely. It follows industry standards for color coding, number formatting (currency, percentages, multiples), and requires detailed documentation for all hardcoded inputs.

Is it limited to .xlsx files?

While optimized for .xlsx and .xlsm files, it also supports reading and processing common data formats like .csv and .tsv using pandas.

Why does it need LibreOffice?

LibreOffice is used to physically recalculate formula values within the file, allowing Claude to verify that logic works correctly before you ever open the document.

Advanced Excel & Spreadsheet Manager

Name: Advanced Excel & Spreadsheet Manager
Author: Weiwei-Mao

byWeiwei-Mao

데이터 과학 및 ML

Enables professional-grade spreadsheet creation, financial modeling, and data analysis with automated formula verification and industry-standard formatting.

소개

The xlsx skill provides Claude with comprehensive capabilities for managing complex Excel workbooks, ranging from basic data entry to sophisticated financial modeling. It ensures high-quality output by enforcing strict standards such as zero-formula-error policies and industry-standard color coding (e.g., blue for inputs, black for formulas). By integrating with pandas for data analysis and openpyxl for structural editing, alongside a specialized LibreOffice recalculation engine, the skill allows for the creation of truly dynamic spreadsheets that maintain functional integrity and professional aesthetics.

주요 기능

0 GitHub stars
Professional financial modeling standards including color-coded inputs and assumptions
Automated Excel formula generation and real-time recalculation using LibreOffice
Preservation of existing templates, formatting, and stylistic conventions
Multi-sheet data analysis and visualization using pandas and openpyxl
Robust error detection and verification for #REF!, #DIV/0!, and #VALUE! errors

사용 사례

Building dynamic financial projection models with automated scenario analysis
Generating formatted corporate reports from raw data sources with interactive formulas
Modifying and updating complex legacy spreadsheets without breaking existing styles or logic

소개

주요 기능

0 GitHub stars
Professional financial modeling standards including color-coded inputs and assumptions
Automated Excel formula generation and real-time recalculation using LibreOffice
Preservation of existing templates, formatting, and stylistic conventions
Multi-sheet data analysis and visualization using pandas and openpyxl
Robust error detection and verification for #REF!, #DIV/0!, and #VALUE! errors

사용 사례

Building dynamic financial projection models with automated scenario analysis
Generating formatted corporate reports from raw data sources with interactive formulas
Modifying and updating complex legacy spreadsheets without breaking existing styles or logic