xlsx

Validate formulas, generate PivotTables, and inspect OpenXML structure in Excel files.

3|2|Updated Feb 11, 2026
One-click install
npx skills add https://github.com/hewliyang/kimi-skills --skill xlsx-hewliyang
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/hewliyang/kimi-skills/tree/main/xlsx
Command: npx skills add https://github.com/hewliyang/kimi-skills --skill xlsx-hewliyang

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill provides a powerful command-line interface for advanced manipulation, analysis, and creation of spreadsheet files, addressing complex tasks beyond basic data entry.

Core Features & Use Cases

  • Formula Validation & Correction: Detects and helps fix formula errors, reference issues, and implicit array formulas.
  • PivotTable Creation: Generates PivotTables and associated charts from data.
  • File Inspection & Validation: Analyzes Excel file structure and validates OpenXML compliance for delivery.
  • Use Case: Automatically create a PivotTable summarizing sales data, validate its structure, and ensure all formulas are error-free before delivering the final report.

Quick Start

Use the xlsx skill to validate the file 'report.xlsx'.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I validate Excel formulas and check for errors in an XLSX file?

To validate Excel formulas and check for errors in an XLSX file, use the xlsx skill to detect formula errors, reference issues, and implicit array formulas, ensuring your spreadsheet is error-free before delivery.

Can I generate a PivotTable from Excel data automatically?

Yes, you can generate a PivotTable from Excel data automatically, using the xlsx skill to create PivotTables and associated charts directly from your dataset for advanced spreadsheet analysis.

Does this tool support validating OpenXML structure for XLSM and CSV files?

Yes, this tool supports OpenXML structure validation for XLSM and CSV files, analyzing the Excel file structure to ensure compliance and validate formulas before delivering the final report.

What is the best way to create Excel files using Python and pandas?

The best way to create Excel files using Python and pandas is through the xlsx skill, which supports Python-based Excel creation with openpyxl and pandas alongside a dedicated KimiXlsx CLI tool for complex operations.

How do I fix implicit array formula issues in my spreadsheet?

To fix implicit array formula issues in your spreadsheet, the xlsx skill provides formula validation and correction features that detect reference problems and help resolve errors automatically.