Why does it require LibreOffice?

LibreOffice is used as a headless calculation engine to ensure all formulas are properly evaluated and verified after the file is created or modified.

How does it prevent formula errors?

It includes a mandatory recalculation step using a script that scans for errors like #REF!, #DIV/0!, and #VALUE!, requiring a fix before the model is finalized.

Can it be used for professional financial modeling?

Yes, it follows industry standards for financial models, including blue text for inputs, black for formulas, and specific currency/multiple formatting.

Does this skill support existing Excel templates?

Yes, the skill is designed to analyze and match existing formats, styles, and conventions when modifying files, ensuring template consistency.

Does it hardcode calculated values?

No, the skill specifically avoids hardcoding. It uses Python to write the actual Excel formulas into the cells so the sheet remains dynamic for the end user.

Excel & Spreadsheet Automation

Name: Excel & Spreadsheet Automation
Author: danhhungthaii

bydanhhungthaii

0•

Data Science & ML

Generates, edits, and analyzes complex Excel workbooks using dynamic formulas, professional financial formatting, and automated data validation.

This skill equips Claude with the ability to handle professional-grade spreadsheet tasks, ranging from large-scale data analysis to the creation of high-fidelity financial models. It prioritizes data integrity by enforcing a 'zero formula error' policy and strictly utilizes Excel formulas over hardcoded values to ensure workbooks remain dynamic and updateable. With specialized support for industry-standard color coding, professional number formatting, and automated formula recalculation via LibreOffice, this skill is ideal for developers and analysts who need to automate complex reporting workflows while maintaining professional presentation standards.

Key Features

01Dynamic formula injection to ensure spreadsheets remain interactive and updateable

02Style-aware editing that preserves existing workbook templates and formatting

030 GitHub stars

04Automated formula recalculation and error detection via LibreOffice integration

05Advanced data manipulation and visualization using pandas and openpyxl

06Professional financial modeling standards with industry-standard color coding

Use Cases

01Performing complex data analysis on large CSVs and exporting to formatted Excel dashboards

02Automating the generation of monthly financial reports from raw data sources

03Updating existing calculation templates without breaking established formulas or styles

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add danhhungthaii/doancs2 xlsx

For use in Claude.ai and ChatGPT

Download Skill