skills.rest
nullpond
nullpondCOMMUNITY
Explore all skills by this author →
GitHub

minimax-xlsx

Generate Excel workbooks with PivotTables and OpenXML-compatible validation.

21|11|Updated Feb 17, 2026
Search Tags:#automation#validation#openpyxl#excel#libreoffice#pivot-table
One-click install
npx skills add https://github.com/nullpond/minimax-skill-analysis --skill minimax-xlsx-nullpond
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: minimax-xlsx
Source: https://github.com/nullpond/minimax-skill-analysis/tree/main/minimax/original/minimax-xlsx
Command: npx skills add https://github.com/nullpond/minimax-skill-analysis --skill minimax-xlsx-nullpond

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill enables end-to-end Excel workbook generation, with formula recalculation, validation, and PivotTable integration, ensuring production-ready outputs.

Core Features & Use Cases

  • Excel file creation and styling using Python libraries (openpyxl/pandas) with hidden gridlines and professional formatting.
  • Recalculation of all formulas via LibreOffice (recalc.py) to produce actual values for Excel.
  • Validation and PivotTable generation using the MiniMaxXlsx CLI (recheck, reference-check, pivot, validate) to guarantee OpenXML compatibility and correct pivot caches.
  • PivotTable creation using OpenXML SDK with optional charts for multi-dimensional analysis.

Quick Start

Design sheets, recalc formulas, run validation, generate PivotTables, and deliver the final workbook.

Frequently Asked Questions about minimax-xlsx

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

FAQPage Schema
How do I automate Excel workbook generation with PivotTables and charts?▼

To automate Excel workbook generation, use Python with openpyxl and pandas to design data sheets, then leverage the MiniMaxXlsx CLI to validate OpenXML compatibility and generate PivotTables with optional charts.

Why do my Excel formulas show outdated values when generating workbooks with openpyxl?▼

Excel formulas show outdated values because openpyxl does not calculate them natively. You must run LibreOffice in headless mode to recalculate formulas and produce actual values for the final workbook.

What is the best way to ensure OpenXML compatibility for PivotTables in Python?▼

The best way to ensure OpenXML compatibility is using the MiniMaxXlsx CLI to run recheck, reference-check, pivot, and validate steps, guaranteeing correct pivot caches and structured analysis across large datasets.

Do I need LibreOffice to create production-grade Excel workbooks with Python?▼

Yes, you need LibreOffice in headless mode to recalculate all formulas and generate actual values. Python with openpyxl and pandas handles file creation and styling, but LibreOffice ensures production-ready outputs.

Can I use openpyxl to generate PivotTables for multi-dimensional analysis?▼

While openpyxl handles Excel file creation and styling, PivotTable generation for multi-dimensional analysis requires the OpenXML SDK and the MiniMaxXlsx CLI to execute pivot and validate steps correctly.

How do I validate pivot caches when automating Excel workflows?▼

You validate pivot caches by running the validate and reference-check commands in the MiniMaxXlsx CLI, ensuring OpenXML compatibility and correct pivot caches for financial and analytical reporting workflows.

Related Skills

Explore More Data & Analytics Skills→
AIDotNetAIDotNet
602

xlsx

Create, edit, and audit Excel workbooks with formula validation.

Official
Advanced
AndersHsuehAndersHsueh

xlsx

Create, edit, and analyze Excel workbooks with Python and LibreOffice recalculation.

Community
Advanced
Jaydpatel01Jaydpatel01

xlsx

Create, edit, and analyze spreadsheet files in .xlsx, .xlsm, .csv, and .tsv formats.

Community
Advanced
ironkid90ironkid90

xlsx

Manage and analyze Excel files using pandas and openpyxl.

Community
Advanced