xlsx

Create and validate Excel workbooks with openpyxl and LibreOffice recalculation.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates the end-to-end lifecycle of Excel workbooks, reducing manual spreadsheet work and eliminating formula drift.

Core Features & Use Cases

  • Create and edit Excel workbooks (.xlsx) from data sources using openpyxl, with formula-driven calculations and consistent formatting.
  • Recalculate and validate formulas using a LibreOffice-based pipeline (scripts/recalc.py) to ensure zero formula errors across sheets.
  • Validate, repair, and package OOXML documents to support reliable sharing, auditing, and deployment.

Quick Start

Build and validate a sample workbook by running a small Python script that creates a workbook, writes data, applies formulas, and then recalculates with recalc.py.

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 formula recalculation in Python?

You can automate Excel workbook creation and formula recalculation using Python by leveraging openpyxl for data entry and a LibreOffice-based recalculation pipeline to ensure deterministic, zero-error outputs across complex spreadsheets.

Why do my Excel formulas show errors after editing xlsx files with openpyxl?

Excel formulas show errors after editing xlsx files because openpyxl writes formulas without recalculating them. A LibreOffice-based recalculation pipeline is required to validate formulas and ensure zero formula drift across sheets.

Does this Excel automation approach support validating and repairing OOXML documents?

Yes, this Excel automation approach supports validating, repairing, and packaging OOXML documents to maintain workbook reliability for auditing, sharing, and deployment in data-driven finance and operations workflows.

Can I use this spreadsheet automation for data-driven financial reporting workflows?

Yes, you can use this spreadsheet automation for data-driven financial reporting workflows. It applies formula-driven calculations and consistent formatting to generate reliable workbooks for operations and reporting.

Do I need LibreOffice installed to recalculate formulas in xlsx files?

Yes, you need a LibreOffice-based pipeline because openpyxl alone cannot execute formula recalculations. The included recalculation script bridges this gap to maintain workbook reliability and deterministic outputs.

What is the best way to eliminate formula drift in complex Excel spreadsheets?

The best way to eliminate formula drift in complex Excel spreadsheets is to apply a deterministic recalculation pipeline that validates formulas and repairs OOXML documents, ensuring zero formula errors across all sheets.