skills.rest
QvvvvvvQ
QvvvvvvQCOMMUNITY
Explore all skills by this author →
GitHub

minimax-xlsx

Automate XLSX/XLSM/CSV workbook construction, formula recalculation, and validation via CLI.

25|17|Updated Feb 14, 2026
Search Tags:#reporting#data analysis#spreadsheet#excel#charting#pivot table
One-click install
npx skills add https://github.com/QvvvvvvQ/skills_leaks --skill minimax-xlsx
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: minimax-xlsx
Source: https://github.com/QvvvvvvQ/skills_leaks/tree/main/Minimax/skills/minimax-xlsx
Command: npx skills add https://github.com/QvvvvvvQ/skills_leaks --skill minimax-xlsx

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates the creation, validation, and refinement of complex Excel spreadsheets, transforming raw data into professional, error-free deliverables.

Core Features & Use Cases

  • Workbook Construction: Build XLSX/XLSM/CSV files with data wrangling, styling, and formulas using Python (openpyxl + pandas).
  • Formula Recalculation & Auditing: Ensure all formulas are computed correctly and identify errors using LibreOffice headless mode and the MiniMaxXlsx CLI.
  • Advanced Features: Generate PivotTables, charts, and perform structural validation for MS Excel compatibility.
  • Use Case: You have a dataset of quarterly sales figures and need to generate a report with a summary table, a pivot table for regional analysis, and a line chart showing revenue trends. This Skill can automate the entire process from data loading to final validation.

Quick Start

Use the minimax-xlsx skill to create an Excel file named 'sales_report.xlsx' with sales data from the provided CSV file 'sales_data.csv'.

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 report generation from CSV data?▼

Automating Excel report generation from CSV data involves loading data with pandas, constructing styled workbooks with openpyxl, and validating structural compatibility to produce publication-ready XLSX deliverables. This workflow directly transforms raw tabular datasets into professional reports.

How do you recalculate spreadsheet formulas without opening Excel?▼

Recalculating spreadsheet formulas without opening Excel is achieved by processing XLSX files through LibreOffice headless mode to compute formula values. This ensures all numeric computations and formula dependencies are accurately resolved and audited.

Does openpyxl support pivot table synthesis and charting?▼

Yes, openpyxl supports pivot table synthesis and charting when integrated with the MiniMaxXlsx CLI for structural validation. This combination allows you to build workbooks featuring regional pivot analysis and revenue trend line charts programmatically.

What is the best way to validate XLSX files for MS Excel compatibility?▼

Validating XLSX files for MS Excel compatibility is best handled by running structural validation and formula diagnostics via the MiniMaxXlsx CLI. This process identifies formatting errors, broken formulas, and structural inconsistencies before final spreadsheet delivery.

Can I use pandas to wrangle data and build pivot tables for XLSM files?▼

Yes, you can use pandas to wrangle data and build pivot tables for XLSM files by executing data manipulation in pandas and writing the results into XLSM workbooks with openpyxl. This supports tabular data analysis and macro-enabled report generation seamlessly.

Why do my spreadsheet formulas show errors after writing with openpyxl?▼

Spreadsheet formulas show errors after writing with openpyxl because the library does not automatically compute formula values upon saving. You must run formula recalculation using LibreOffice headless mode to ensure formulas are fully computed and cached before opening.

Related Skills

Explore More Data & Analytics Skills→
cbbkrd-techcbbkrd-tech

xlsx

Create, edit, and analyze .xlsx, .xlsm, .csv, and .tsv files with pandas and openpyxl.

Community
Advanced
IsKenKenYaIsKenKenYa

Excel Analysis

Analyze Excel spreadsheets by importing data, cleaning it, and generating pivot tables and charts.

Community
Intermediate
rodrigoBermejorodrigoBermejo

Data Processing - pandas, numpy, Data Analysis

Automate data processing and analysis in Python with pandas and numpy.

Community
Intermediate
Victory-HugoVictory-Hugo
1

xlsx

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

Community
Advanced