Can it detect errors in my spreadsheet?

Yes, it uses a recalculation script that scans every cell for common Excel errors like #REF! or #DIV/0! and provides a detailed summary to fix them.

Does this skill support complex Excel formulas?

Yes, it specifically prioritizes creating functional Excel formulas over hardcoded values to ensure your spreadsheets remain dynamic and interactive.

How does it handle financial modeling standards?

The skill follows strict industry conventions, such as blue text for inputs, black for formulas, and yellow backgrounds for key assumptions needing attention.

What Python libraries are used for Excel tasks?

It primarily uses pandas for heavy data manipulation and openpyxl for managing formulas, cell styles, and complex workbook structures.

XLSX Spreadsheet Expert

Name: XLSX Spreadsheet Expert
Author: lngyneric

bylngyneric

0•

데이터 과학 및 ML

Automates professional spreadsheet creation, financial modeling, and data analysis with dynamic formulas and industry-standard formatting.

This skill enables Claude to perform advanced spreadsheet operations, ranging from simple CSV conversions to complex financial modeling. It leverages pandas for data manipulation and openpyxl for intricate formatting, ensuring that all spreadsheets remain dynamic by prioritizing Excel formulas over hardcoded values. The skill includes built-in support for industry-standard financial conventions, automated formula recalculation via LibreOffice, and rigorous error-checking to guarantee professional-grade outputs with zero formula errors.

주요 기능

01Comprehensive documentation requirements for hardcoded assumptions and data sources.

02Automated error detection for common spreadsheet issues like #REF!, #DIV/0!, and #VALUE!.

03Dynamic Excel formula generation with automated recalculation and error verification.

04Industry-standard financial modeling including color-coding and number formatting rules.

05Dual-library support using pandas for data analysis and openpyxl for stylistic preservation.

060 GitHub stars

사용 사례

01Processing large datasets with pandas and exporting them into professionally formatted Excel reports.

02Building automated financial models with dynamic projections and valuation multiples.

03Auditing, repairing, and updating legacy spreadsheets while preserving existing styles and templates.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add lngyneric/my-notebook-github xlsx

For use in Claude.ai and ChatGPT

Download Skill