skills.rest
qfwc258
qfwc258COMMUNITY
Explore all skills by this author →
GitHub

minimax-xlsx

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

1|Updated Mar 25, 2026
Search Tags:#pandas#spreadsheet#excel#xlsx#ooxml#financial model#formula validation
One-click install
npx skills add https://github.com/qfwc258/trae-skills --skill minimax-xlsx-qfwc258
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: minimax-xlsx
Source: https://github.com/qfwc258/trae-skills/tree/main/minimax-xlsx
Command: npx skills add https://github.com/qfwc258/trae-skills --skill minimax-xlsx-qfwc258

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 libraries round-trip the file, and generated spreadsheets frequently contain hardcoded values instead of live formulas. This Skill solves both problems by operating directly on the OOXML (SpreadsheetML) inside the xlsx package, preserving everything untouched while enforcing formula-first, professionally formatted output. ## Core Features & Use Cases - Five task paths: READ (analyze data with pandas), CREATE (build new workbooks from an XML template), EDIT (surgical unpack-edit-repack changes with zero format loss), FIX (repair broken formulas like #REF! and #DIV/0!), and VALIDATE (static formula checking). - Financial formatting standards: Applies the industry color convention (blue = input, black = formula, green = cross-sheet reference) plus currency, percentage, and year number formats through a 13-slot pre-built style system. - Helper scripts: Includes xlsx_unpack/xlsx_pack, formula_check, xlsx_add_column, xlsx_insert_row, and xlsx_shift_rows for deterministic structural edits. - Use Case: A user asks to add a "% of Total" column to an existing budget workbook. The Skill unpacks the file, inserts the column with live formulas and copied styles, repacks it, and validates the result—without touching the file's pivot tables or macros. ## Quick Start Ask the assistant to create a three-year revenue model in Excel with live formulas and financial formatting, or to edit a specific cell in an existing 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 existing xlsx file without losing formatting?▼

Unpack the xlsx into its XML parts, edit only the target nodes in the worksheet XML, then repack. This avoids openpyxl round-trips, which silently drop pivot tables, VBA macros, sparklines, and slicers when re-saving existing files.

How do I create an Excel file with formulas in Python?▼

Build the workbook from a minimal OOXML template by editing sheet XML directly, writing every calculated value as an <f> formula element rather than a hardcoded number. Pack the directory with a zip-based pack script and validate with a formula checker before delivery.

Why does openpyxl corrupt my Excel file when saving?▼

openpyxl drops content it does not understand during load-and-save, including vbaProject.bin, pivot tables, slicers, sparklines, and custom XML parts. Direct XML editing changes only the nodes you touch, leaving all other bytes identical to the original.

How do I fix #REF! and #DIV/0! errors in Excel formulas programmatically?▼

Run a static formula checker to locate error cells, unpack the file, then repair the broken <f> elements—for example wrapping division formulas in IFERROR or reconstructing broken references. Repack and re-validate until zero errors remain.

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

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

Can I insert a row into an xlsx without breaking formulas?▼

Yes, but row insertion requires cascading updates to cell addresses, formula references, merged cells, conditional formatting, and chart ranges. Use a dedicated shift-rows script that updates all of these in one pass rather than editing manually.

Related Skills

Explore More Data & Analytics Skills→
microclawmicroclaw
731

csv-tools

Inspect, filter, aggregate, and clean CSV and TSV data with Python.

Official
Basic
oimiragieooimiragieo
36

excel-generator

Generate multi-sheet Excel workbooks with formulas, charts, and formatting.

Community
Basic
silversteinsilverstein
21

xlsx

Recalculate Excel formulas and scan cells for error tokens.

Community
Advanced
felix-howardfelix-howard

ck:xlsx

Create, edit, and analyze .xlsx, .csv, and .tsv spreadsheet files.

Community
Advanced