Will it break the formatting in my existing templates?

No. The skill is designed to study and exactly match the existing style, formatting, and conventions of your templates when performing updates.

What libraries does this skill use for Excel operations?

It leverages pandas for high-level data analysis and openpyxl for detailed formatting and formula management, providing a complete spreadsheet toolset.

How does it prevent formula errors?

The skill uses a mandatory verification script that scans all cells for common errors like #REF!, #DIV/0!, and #NAME? to ensure the spreadsheet is fully functional.

Does this skill support complex Excel formulas?

Yes, it supports full Excel formula syntax and includes a specialized recalculation engine to ensure all values are correctly computed and error-free.

Can it handle professional financial modeling standards?

Absolutely. It follows industry standards such as blue text for hardcoded inputs, black text for formulas, and specific number formatting for currencies and multiples.

Excel & Spreadsheet Automation

Name: Excel & Spreadsheet Automation
Author: arthur0824hao

byarthur0824hao

生产力与工作流

Creates, edits, and analyzes complex Excel spreadsheets with support for professional financial modeling, dynamic formulas, and automated recalculation.

关于

This skill provides Claude with advanced capabilities to manage spreadsheet workflows including .xlsx, .xlsm, and .csv formats. It goes beyond simple data export by enforcing professional financial modeling standards, such as industry-standard color coding and rigorous formula error checking. By combining pandas for data manipulation and openpyxl for formatting, it allows for the creation of production-ready workbooks. A key feature is the integrated recalculation engine that uses LibreOffice to verify formula integrity, ensuring that every spreadsheet delivered is free of errors like #REF! or #DIV/0!.

主要功能

Support for complex Excel features including formatting, visualizations, and multi-sheet references
Smart template preservation that matches existing file styles and conventions during updates
Professional financial modeling standards including color-coded inputs and formula conventions
Data analysis and processing integration using pandas for high-performance manipulation
Automated formula recalculation and error verification using an integrated engine
0 GitHub stars

使用场景

Modifying existing business templates while maintaining original formatting and structural integrity
Automating the transformation of raw CSV/TSV data into formatted, professional Excel reports
Building dynamic financial projection models with automated assumptions and zero-error formulas

关于

主要功能

Support for complex Excel features including formatting, visualizations, and multi-sheet references
Smart template preservation that matches existing file styles and conventions during updates
Professional financial modeling standards including color-coded inputs and formula conventions
Data analysis and processing integration using pandas for high-performance manipulation
Automated formula recalculation and error verification using an integrated engine
0 GitHub stars

使用场景

Modifying existing business templates while maintaining original formatting and structural integrity
Automating the transformation of raw CSV/TSV data into formatted, professional Excel reports
Building dynamic financial projection models with automated assumptions and zero-error formulas