xlsx

Creates, edits, and verifies Excel spreadsheets with pandas and openpyxl.

Updated May 5, 2026
One-click install
npx skills add https://github.com/wachawo/claude-skills --skill xlsx-wachawo
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/wachawo/claude-skills/tree/main/skills/xlsx
Command: npx skills add https://github.com/wachawo/claude-skills --skill xlsx-wachawo

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This skill solves the challenge of managing complex spreadsheet workflows, ensuring that Excel files are not just created, but are dynamic, error-free, and professionally formatted.

Core Features & Use Cases

  • Dynamic Modeling: Enforces the use of Excel formulas over hardcoded values to ensure spreadsheets remain updatable.
  • Automated Verification: Uses integrated LibreOffice scripts to recalculate formulas and identify common errors like #REF! or #DIV/0!.
  • Professional Formatting: Applies industry-standard color coding and number formatting for financial models and data reports.

Quick Start

Use the xlsx skill to process the financial model in budget.xlsx and verify that all formulas are calculating correctly.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel spreadsheet creation and ensure formulas calculate correctly?

Automate Excel spreadsheet creation and ensure formulas calculate correctly by using pandas and openpyxl to enforce formulas over hardcoded values. LibreOffice headless scripts recalculate formulas and detect errors like #REF! or #DIV/0!.

Do I need LibreOffice to verify Excel formulas and detect spreadsheet errors?

Yes, LibreOffice is required for headless formula recalculation and validation of spreadsheet integrity. It automatically identifies common calculation errors like #REF! or #DIV/0! during the Excel verification process.

Can I use pandas and openpyxl for automated financial modeling in Excel?

Yes, you can use pandas and openpyxl for automated financial modeling in Excel. This approach supports complex data restructuring and formula-based calculations while applying industry-standard formatting to your financial models.

What is the best way to repair Excel files with broken formulas and formatting?

The best way to repair Excel files with broken formulas and formatting is through automated verification using openpyxl and LibreOffice. This recalculation process identifies formula errors and applies professional color coding and number formatting.

Does this approach support dynamic data restructuring for Excel reports?

Yes, this approach supports dynamic data restructuring for Excel reports. It uses openpyxl and pandas to automate complex data restructuring, formula-based calculations, and professional number formatting for financial models and data reports.

Why do my Excel formulas show errors after automated data restructuring?

Excel formulas show errors after automated data restructuring due to broken references. Automated verification uses LibreOffice to recalculate formulas and identify common errors like #REF! or #DIV/0! to ensure spreadsheet integrity.