xlsx

Create, edit, and validate Excel workbooks with openpyxl and LibreOffice recalculation.

Updated Mar 15, 2026
One-click install
npx skills add https://github.com/jaguarliuu/miniclaw --skill xlsx-jaguarliuu
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/jaguarliuu/miniclaw/tree/main/.miniclaw/skills/xlsx
Command: npx skills add https://github.com/jaguarliuu/miniclaw --skill xlsx-jaguarliuu

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Excel-based data work often involves manual formatting, inconsistent formulas, and error-prone edits. This Skill automates creation, editing, and validation of spreadsheets to ensure formula integrity, formatting consistency, and reproducible results.

Core Features & Use Cases

  • Automate creation, editing, and formatting of Excel workbooks using Python libraries (openpyxl) and data-pipeline tooling.
  • Ensure formula integrity and reproducible recalculation via the provided LibreOffice-based recalculation script (scripts/recalc.py).
  • Maintain template fidelity and content-type correctness during packaging/unpacking workflows for Office files.

Quick Start

Open a workbook, apply formatting and formulas, run the recalculation script, and save a validated workbook.

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 and formatting using Python?▼

You can validate Excel formulas and ensure reproducible recalculation using the provided LibreOffice-based recalculation script (scripts/recalc.py). This ensures formula integrity and correct data outputs by validating formulas after applying edits programmatically.

What's the best way to clean and format Excel data for reporting pipelines?▼

The best way to clean and format Excel data for reporting is to automate the workflow using Python. This Skill applies formatting, audits formulas, and validates data cleanliness, providing a repeatable pipeline that ensures template fidelity and reproducible results across standard spreadsheet workflows.

Can I use openpyxl and pandas together for Excel data cleaning and conversion?▼

Yes, you can use openpyxl and pandas together for Excel data cleaning and conversion. This Skill leverages both dependencies to automate workbook editing, maintain content-type correctness during packaging, and handle CSV/TSV conversions within standard spreadsheet workflows.

Does automating Excel formula auditing work with CSV and TSV file conversions?▼

Automating Excel formula auditing works with CSV and TSV file conversions as part of standard spreadsheet workflows. The Skill handles template packaging and unpacking, ensuring content-type correctness and formula integrity when converting between Excel and CSV/TSV formats.

Why do my Excel formulas show errors after automated editing with Python?▼

Excel formulas may show errors after automated editing if recalculation is not validated. This Skill solves the problem by providing a LibreOffice-based recalculation script (scripts/recalc.py) to validate formulas, ensuring formula integrity and reproducible results after programmatic edits.