skills.rest
augustscl
augustsclCOMMUNITY
Explore all skills by this author →
GitHub

minimax-xlsx

Create, edit, and validate xlsx workbooks via XML templates.

2|Updated Apr 6, 2026
Search Tags:#spreadsheet#excel#xlsx#financial-modeling#xml-edit#formula-validation
One-click install
npx skills add https://github.com/augustscl/awesome-xiawang-skills --skill minimax-xlsx-augustscl
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: minimax-xlsx
Source: https://github.com/augustscl/awesome-xiawang-skills/tree/main/minimax-xlsx
Command: npx skills add https://github.com/augustscl/awesome-xiawang-skills --skill minimax-xlsx-augustscl

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Provide a deterministic, safe, production-ready workflow for creating, reading, editing, repairing, and validating Excel and spreadsheet files without corrupting advanced workbook features (macros, pivots, charts), and ensure formulas remain live and auditable.

Core Features & Use Cases

  • Formula-First Creation: Build new xlsx workbooks from XML templates where every computed value is an Excel formula, not a hardcoded number.
  • Surgical Editing: Unpack → XML-edit → repack flow that preserves VBA, pivot tables, sparklines, and other advanced objects while making minimal, targeted changes.
  • Validation & Recalc: Static validation with formula_check.py plus optional LibreOffice headless recalculation to surface runtime errors before delivery.
  • Financial Formatting: Apply a consistent color-and-number-format system (blue inputs, black formulas, green cross-sheet refs) and append-only styles to avoid global breakage.
  • Use Case Example: Fill template inputs, add a computed column of percentages, update totals, validate all formulas, and return a production-ready output.xlsx.

Quick Start

Ask the skill to open or create an .xlsx, apply the requested edits or formulas using the XML template path, run validation, and return the final output.xlsx file.

Frequently Asked Questions about minimax-xlsx

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

FAQPage Schema
How do I edit xlsx files without losing pivot tables and VBA macros?▼

To edit xlsx files without losing pivot tables and VBA macros, you need a surgical unpack-edit-repack workflow that modifies the XML structure directly while avoiding standard library write-roundtrips that strip advanced objects.

How do I create Excel financial models with live formulas instead of hardcoded values?▼

You can create Excel financial models with live formulas by generating new xlsx workbooks from XML templates where every computed value is defined as an Excel formula, ensuring outputs remain auditable and dynamically recalculated.

Can I validate and recalculate Excel formulas before delivering a spreadsheet?▼

Yes, you can validate Excel formulas before delivery by running static formula validation scripts and optionally using LibreOffice headless mode to dynamically recalculate values and surface runtime errors.

Does openpyxl corrupt advanced Excel features like charts and sparklines?▼

Standard openpyxl write-roundtrips can corrupt advanced Excel features like charts and sparklines because they rewrite the workbook structure. To preserve these objects, you should apply targeted XML edits instead of full workbook rewrites.

What is the best way to repair broken formulas in an existing spreadsheet?▼

The best way to repair broken formulas in a spreadsheet is to unpack the xlsx file, apply targeted XML edits to fix the formula definitions, repack the file, and then run formula validation to confirm the repairs are error-free.

How do I apply standard financial formatting to an Excel workbook?▼

You apply standard financial formatting to an Excel workbook by enforcing a consistent color and number format system, using blue for inputs, black for formulas, and green for cross-sheet references, while appending styles to avoid global breakage.

Related Skills

Explore More Finance & Accounting Skills→
KanishKumar11KanishKumar11

xlsx

Manage and analyze Excel files using Python libraries.

Community
Advanced
pablomat555pablomat555
1

xlsx

Clean, transform, and format spreadsheet data into finalized .xlsx files.

Community
Intermediate
mkurmanmkurman
321

xlsx

Automate spreadsheet manipulation and data cleaning with pandas and openpyxl.

Community
Intermediate
xuyannan0321xuyannan0321

minimax-xlsx

Read, create, edit, repair, and validate Excel files with formulas.

Community
Advanced