xlsx

Create and edit Excel spreadsheets with formulas using openpyxl and recalc.py.

Updated Jan 16, 2026

Search Tags:#automation #Excel #openpyxl #formulas #spreadsheet #data-analysis #xlsx

Ready to run

npx skills add https://github.com/Xinm123/MyRecall --skill xlsx-xinm123

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Xinm123/MyRecall/tree/main/openrecall/.trae/skills/xlsx
Command: npx skills add https://github.com/Xinm123/MyRecall --skill xlsx-xinm123

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill automates the creation, editing, and analysis of spreadsheets (.xlsx, .xlsm) with complex formulas and formatting, helping users deliver error-free financial models and reports while preserving existing templates.

Core Features & Use Cases

Automated spreadsheet creation with formulas and formatting
Preserve existing templates and conventions when updating files
Data analysis and visualization within Excel workbooks
Recalculate and validate formulas using LibreOffice via recalc.py for accuracy

Quick Start

Create a new workbook or modify an existing one by using Python with openpyxl to add data and formulas, then run: python recalc.py output.xlsx

Frequently Asked Questions about xlsx

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I automate Excel spreadsheet creation with formulas and formatting?▼

You can automate Excel spreadsheet creation by using Python with openpyxl to inject data and formulas, then run recalc.py to validate formula-driven recalculation. This process generates formatted .xlsx files while preserving existing templates and conventions for financial models.

Can I update existing .xlsx templates without losing their original formatting?▼

Yes, you can update existing .xlsx templates without losing formatting. The Skill modifies content within .xlsx and .xlsm files while preserving existing templates and conventions, ensuring your automated reporting workflows maintain their original layout and design.

Does openpyxl recalculate formulas correctly when updating Excel workbooks?▼

openpyxl formulas are recalculated accurately using the recalc.py LibreOffice-based engine. This ensures formula-driven recalculation within Excel workbooks is validated correctly, satisfying requirements for error-free financial models and data analysis reporting.

What is the best way to validate formula-driven recalculation in automated Excel workflows?▼

The best way to validate formula-driven recalculation in automated Excel workflows is running the recalc.py script after modifying your spreadsheet with openpyxl. This LibreOffice-based engine ensures formula accuracy across .xlsx files for reliable financial models and reports.

Can I use this approach for financial modeling and data analysis in .xlsm files?▼

Yes, you can use this approach for financial modeling and data analysis in .xlsm files. The Skill supports automating spreadsheet creation, editing, and analysis across both .xlsx and .xlsm formats, delivering error-free reporting workflows.

Why does my automated Excel formula not update until I open the file manually?▼

Excel formulas may not update automatically because openpyxl writes formulas without computing their cached values. Running recalc.py uses a LibreOffice-based engine to force recalculation, ensuring formula values are accurate and updated within the output workbook.