Is LibreOffice required for this skill?

Yes, the skill assumes LibreOffice is installed to power the recalc.py script, which ensures formulas are correctly evaluated and saved within the file.

Can I use it for data visualization?

Yes, it integrates with pandas and openpyxl to generate data visualizations, charts, and formatted tables directly within your spreadsheets.

Can it handle financial modeling standards?

Absolutely, it includes built-in rules for industry-standard color coding—such as blue for inputs and black for formulas—and professional number formatting.

Does this skill support complex Excel formulas?

Yes, it supports comprehensive formula creation and includes a mandatory recalculation step to ensure all values are updated and error-free.

How does it prevent formula errors?

The skill uses a verification script that scans for common errors like #REF!, #DIV/0!, and #VALUE!, requiring them to be fixed before the file is finalized.

Advanced Excel & Spreadsheet Manager

Name: Advanced Excel & Spreadsheet Manager
Author: ai-wes

byai-wes

0•

数据科学与机器学习

Automates the creation, editing, and analysis of professional-grade Excel spreadsheets with dynamic formulas and industry-standard financial modeling.

The xlsx skill provides Claude with a comprehensive toolkit for managing spreadsheet workflows, ranging from simple CSV exports to complex financial models. It leverages pandas for data analysis and openpyxl for sophisticated formatting, ensuring that all spreadsheets are dynamic rather than hardcoded. The skill enforces strict financial standards, including specific color-coding for inputs and calculations, and utilizes a dedicated recalculation script to guarantee zero formula errors. Whether you are generating new reports or updating existing templates, this skill ensures data integrity and professional presentation while preserving existing styles.

主要功能

01Automated formula recalculation and comprehensive error verification

02Template preservation to maintain existing file styles and conventions

030 GitHub stars

04Full support for .xlsx, .xlsm, .csv, and .tsv file manipulation

05Industry-standard financial modeling (color coding and number formatting)

06Data analysis and visualization using pandas and openpyxl integration

使用场景

01Updating corporate spreadsheet templates without breaking formulas or existing styles

02Building dynamic financial projection models with automated scenario inputs

03Analyzing large datasets and exporting insights into formatted Excel reports

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add ai-wes/glassbox-operator xlsx

For use in Claude.ai and ChatGPT

Download Skill