xlsx

Create, style, and validate Excel workbooks with Python.

332|99|Updated Jan 27, 2026
One-click install
npx skills add https://github.com/dnnyngyen/kimi-agent-internals --skill xlsx-dnnyngyen
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/dnnyngyen/kimi-agent-internals/tree/main/source-code/skills/xlsx
Command: npx skills add https://github.com/dnnyngyen/kimi-agent-internals --skill xlsx-dnnyngyen

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill automates the creation, styling, and validation of Excel workbooks (XLSX/XLSM) using Python (openpyxl & pandas), enabling deterministic outputs, built-in formula deployment, currency formatting, and charts.

Core Features & Use Cases

  • Workbook creation & styling: generate Excel files with formulas, custom formats, and charts from structured data.
  • Deterministic validation flow: integrate with KimiXlsx tools to recheck formulas, detect reference errors, inspect sheet structures, and validate the final OpenXML file.
  • Pivot-enabled reporting: create and style PivotTables and charts via the dedicated pivot command, ensuring accurate data summarization.
  • External data citation: when data is fetched externally, include per-row citations or a dedicated Sources sheet to comply with sourcing requirements.

Quick Start

Start by creating a minimal workbook with a Cover page and a Data sheet, then run the validation workflow:

  • Create a basic workbook using Python with openpyxl/pandas.
  • Run recheck and reference-check on the generated file.
  • If a PivotTable is required, use the pivot command and then run validate.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I create Excel workbooks with formulas and charts using Python?

You can create Excel workbooks with formulas, custom formats, and charts by processing structured data through Python using openpyxl and pandas. This approach generates deterministic XLSX files with built-in formulas, currency formatting, and visual charts.

How does Excel validation work for detecting reference errors in generated files?

Excel validation works by integrating with KimiXlsx tools to recheck formulas, detect reference errors, inspect sheet structures, and validate the final OpenXML file. This deterministic validation flow ensures reproducible artifacts and governed data outputs.

Can I use openpyxl and pandas to generate PivotTables in Excel?

Yes, you can generate and style PivotTables and charts in Excel using openpyxl and pandas via a dedicated pivot command. This ensures accurate data summarization and formatted reporting directly within the XLSX workbook.

What is the best way to include external data citations in an Excel workbook?

The best way to include external data citations in an Excel workbook is to add per-row citations or create a dedicated Sources sheet. This ensures compliance with sourcing requirements when data is fetched externally.

Why does my Excel file output need deterministic validation after generation?

Your Excel file output needs deterministic validation to recheck formulas, detect reference errors, and inspect sheet structures. Running validation after generation ensures the final OpenXML file is structurally sound and reproducible.