xlsx

Name: xlsx
Availability: InStock
Author: nullpond

Automates Excel workbook creation, formatting, and PivotTables with Python.

21|11|Updated Feb 17, 2026

Search Tags:#automation #validation #openpyxl #excel #workbook #pivot-table

Ready to run

npx skills add https://github.com/nullpond/minimax-skill-analysis --skill xlsx-nullpond

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/nullpond/minimax-skill-analysis/tree/main/kimi/xlsx
Command: npx skills add https://github.com/nullpond/minimax-skill-analysis --skill xlsx-nullpond

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Automate the creation and validation of complex Excel workbooks (with formatting, formulas, and PivotTables) to reduce manual effort and human error.

Core Features & Use Cases

Python-based workbook creation using openpyxl and pandas for data manipulation, styling, and export.
Built-in per-sheet planning, deterministic steps, and a strict validation workflow (recheck, reference-check, inspect, validate) to guarantee Excel compatibility.
PivotTable integration and OpenXML-based output for reliable Excel 2019+ compatibility, including optional chart generation.

Quick Start

Create a sample workbook that includes a cover page, data sheet, and a simple PivotTable using the provided KimiXlsx tool and the Python openpyxl/pandas workflow.

Frequently Asked Questions about xlsx

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

FAQPage Schema

How do I automate Excel workbook creation with Python and ensure the file opens correctly?▼

Automate Excel workbook creation and validation by using Python with openpyxl and pandas to process data, then enforce a strict validation pipeline to guarantee files open reliably in Microsoft Excel.

What's the best way to generate Excel PivotTables programmatically without manual formatting?▼

Generate Excel PivotTables programmatically by orchestrating workflows with openpyxl and pandas, applying strict OpenXML validation before delivery to ensure reliable compatibility in Excel 2019+.

Why do my automated Excel workbooks corrupt or fail to open in Microsoft Excel?▼

Automated Excel workbooks corrupt when output lacks strict OpenXML validation. Applying a per-sheet pipeline of recheck, reference-check, inspect, and validate ensures structural integrity and reliable compatibility.

Can I use pandas to style Excel workbooks and export valid PivotTables?▼

Yes, you can use pandas for data manipulation alongside openpyxl for styling and export, integrating PivotTable orchestration with strict OpenXML validation to guarantee valid Excel deliverables.

Does openpyxl support automated Excel formatting and PivotTable generation for large datasets?▼

Openpyxl supports automated Excel formatting and PivotTable generation by orchestrating workflows with pandas, enforcing deterministic steps and OpenXML validation to ensure reliable output for large datasets.

How to validate Excel files programmatically before exporting to prevent reference errors?▼

Validate Excel files programmatically by enforcing a per-sheet pipeline that performs recheck, reference-check, inspect, and validate steps before final export, guaranteeing structural integrity and eliminating reference errors.