Will it ruin the formatting of my existing templates?

No. The skill is designed to study and match existing formats, styles, and conventions, ensuring that template-specific patterns always override general guidelines.

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

The skill includes a mandatory verification step using a recalculation script that scans all cells for Excel errors before finalizing the file.

Can this skill handle complex Excel formulas?

Yes, it uses openpyxl to programmatically insert formulas and includes a specialized recalculation script to ensure all calculations are accurate and error-free.

Does it follow professional financial modeling standards?

Absolutely. It follows industry conventions like using blue text for hardcoded inputs, black for formulas, and green for internal worksheet links.

XLSX Spreadsheet Master

Name: XLSX Spreadsheet Master
Author: xiaxingxiaowei1983

byxiaxingxiaowei1983

0•

数据科学与机器学习

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

The XLSX Spreadsheet Master skill empowers Claude to handle complex spreadsheet tasks ranging from simple data entry to building sophisticated, production-ready financial models. It enforces strict industry standards such as color-coded cell conventions and specific number formatting while ensuring zero-error formula construction through automated recalculation scripts. By combining the data processing power of pandas with the formatting precision of openpyxl, this skill allows for the seamless manipulation of .xlsx and .csv files while strictly preserving existing template styles and conventions.

主要功能

01Strict preservation of existing workbook templates and stylistic conventions

02Robust documentation for hardcoded values including source and date tracking

03Industry-standard financial modeling with automated color coding and formatting

040 GitHub stars

05Automated formula recalculation and error verification using LibreOffice integration

06Dual-library support using pandas for data analysis and openpyxl for formatting

使用场景

01Performing complex data analysis on large datasets and generating formatted Excel reports

02Updating existing corporate spreadsheet templates while maintaining strict internal formatting

03Building dynamic financial models from scratch with zero formula errors and professional styles

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add xiaxingxiaowei1983/openclaw xlsx

For use in Claude.ai and ChatGPT