xlsx

Automate Excel workbook creation, editing, and analysis with formulas and formatting.

11|12|Updated Feb 28, 2026
One-click install
npx skills add https://github.com/mofa-org/mofa-skills --skill xlsx-mofa-org
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/mofa-org/mofa-skills/tree/main/mofa-xlsx
Command: npx skills add https://github.com/mofa-org/mofa-skills --skill xlsx-mofa-org

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, and includes scripts (resource) components.

What problem does it solve?

Excel often requires repetitive setup for data, formulas, and formatting. This Skill automates end-to-end workbook creation, editing, and analysis, while preserving formulas and templates to prevent errors and rework.

Core Features & Use Cases

  • Create and edit workbooks with formulas and formatting
  • Recalculate all formulas to enforce zero-error results
  • Batch-process multiple files and generate consistent reports
  • Maintain existing templates and apply standard color/number formatting rules

Quick Start

Create a new workbook, add your data and formulas, save as an .xlsx file, and run the recalc script to verify formulas.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel workbook creation with formulas and formatting?

You can automate Excel workbook creation, editing, and formatting by applying formulas and standard color and number formatting rules through scripts, then running a recalc script to verify zero-formula-errors. This eliminates repetitive manual setup for data and templates.

What is the best way to batch process Excel files for consistent reporting?

Batch processing multiple Excel files for consistent reporting is achieved by automating workbook editing across .xlsx, .xlsm, .csv, and .tsv files. This approach applies standard formatting and formulas uniformly to generate consistent reports without manual rework.

Does openpyxl support recalculation to enforce zero-formula-errors in xlsx files?

Yes, openpyxl is used as the underlying dependency, and a mandatory recalculation script (recalc.py) enforces zero-formula-errors in xlsx files. This ensures that all formulas are recalculated and verified for accurate results.

Can I use this Excel automation approach for financial modeling and data cleaning?

Excel automation for financial modeling and data cleaning is fully supported. It handles tasks like applying formulas, maintaining existing templates, and enforcing color and number formatting conventions across your .xlsx and .xlsm workbooks.

Why do my Excel formulas show errors after automated workbook editing?

Excel formulas may show errors after automated editing if recalculation is not enforced. Running the mandatory recalc.py script verifies formulas, enforces zero-error results, and ensures that all calculations are updated correctly before saving.