skills.rest
HalseyYang
HalseyYangCOMMUNITY
Explore all skills by this author →
GitHub

minimax-xlsx

Create, edit, analyze, and validate Excel spreadsheets via direct OOXML manipulation.

1|Updated Jul 13, 2026
Search Tags:#data analysis#formulas#spreadsheet#excel#xlsx#ooxml#financial model
One-click install
npx skills add https://github.com/HalseyYang/Skills-HY --skill minimax-xlsx-halseyyang
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: minimax-xlsx
Source: https://github.com/HalseyYang/Skills-HY/tree/main/minimax-xlsx
Command: npx skills add https://github.com/HalseyYang/Skills-HY --skill minimax-xlsx-halseyyang

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve? Working with Excel files programmatically often corrupts advanced features like pivot tables, VBA macros, and sparklines when using libraries like openpyxl, and generated spreadsheets frequently contain hardcoded values instead of live formulas. This Skill solves both problems by operating directly on the underlying OOXML, preserving every feature of existing files while enforcing formula-first, professionally formatted output. ## Core Features & Use Cases - Five Task Modes: Read and analyze existing spreadsheets with pandas, create new xlsx files from an XML template, edit existing files with zero format loss, repair broken formulas, and validate formulas statically or via LibreOffice recalculation. - Surgical XML Editing: Unpack-edit-pack workflow with helper scripts for inserting rows, adding columns, and shifting ranges while automatically updating formulas, merged cells, and conditional formatting. - Financial Formatting Standards: Applies the industry color convention (blue for inputs, black for formulas, green for cross-sheet references) with 13 pre-built style slots for currency, percentage, and year formats. - Use Case: A user provides an existing budget workbook and asks to insert a new expense row with a SUM formula. The Skill unpacks the file, locates the correct row by label, inserts the row with proper styles, repacks, and validates the result before delivery. ## Quick Start Ask the assistant to create a three-year revenue model in Excel with live growth formulas and professional financial formatting, or to edit a specific cell in an attached 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 an Excel file without losing formatting in Python?▼

Edit the underlying OOXML directly instead of using openpyxl round-trips. Unpack the xlsx as a ZIP, modify only the target XML nodes in the worksheet files, then repack. This preserves pivot tables, VBA macros, sparklines, and charts that openpyxl silently drops.

How to create an Excel file with formulas instead of hardcoded values?▼

Write every calculated cell as an <f> formula element in the worksheet XML, such as <f>SUM(B2:B9)</f>, leaving the cached <v> value empty. Only raw inputs and assumptions should be hardcoded numbers, so the workbook recalculates when source data changes.

Why does openpyxl corrupt Excel files with pivot tables or macros?▼

openpyxl drops content it does not understand during load and save, including vbaProject.bin, pivot table definitions, slicers, and sparklines. The saved file loses these features permanently, which is why direct XML editing is required for feature-rich workbooks.

How do I insert a row in Excel and update all formulas automatically?▼

Use a row-shift script that updates row attributes, cell addresses, formula text, merged cell ranges, conditional formatting, and table references in one pass. Inserting manually requires cascading updates across every worksheet and chart definition.

What is the standard color convention for financial models in Excel?▼

Financial modeling convention uses blue font for hardcoded inputs and assumptions, black font for formulas and calculated results, and green font for cross-sheet references. This lets reviewers instantly distinguish adjustable parameters from computed values.

How do I validate Excel formulas before delivering a spreadsheet?▼

Run a static formula checker that scans for cached error values like #DIV/0! and #REF!, and verifies that every sheet referenced in formulas exists in the workbook. For dynamic validation, recalculate the file with LibreOffice and re-scan the output.

Related Skills

Explore More Data & Analytics Skills→
47network47network
5

xlsx-generator

Generate Excel-compatible XLSX workbooks from structured data and CSV exports.

Community
Intermediate
devMoezdevMoez
1

pptx-author

Generate headless PowerPoint decks from workbook data using python-pptx.

Community
Intermediate
Sspanwar31Sspanwar31
4

xlsx

Create, edit, and analyze spreadsheets while preserving formulas and formatting.

Community
Advanced
EnztunEnztun

xlsx

Automate Excel spreadsheet operations with Python libraries like openpyxl, pandas, and matplotlib.

Community
Advanced