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.