xlsx

Automate Excel workbook creation, editing, and analysis with OpenPyXL.

Updated Aug 23, 2026

Search Tags:#automation #formulas #excel #data-analysis #xlsx #LibreOffice

Ready to run

npx skills add https://github.com/Dedalus-ERP-PAS/foundation-skills --skill xlsx-dedalus-erp-pas

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Dedalus-ERP-PAS/foundation-skills/tree/main/skills/xlsx
Command: npx skills add https://github.com/Dedalus-ERP-PAS/foundation-skills --skill xlsx-dedalus-erp-pas

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill eliminates the tedious, error-prone work of creating, editing, and analyzing Excel workbooks by automating routine tasks and preserving data integrity.

Core Features & Use Cases

Workbook creation and modification: generate new spreadsheets, apply formatting, and insert formulas without manual editing.
Formula integrity and template preservation: ensure existing templates and formulas stay intact during updates; enforce consistent styling guidelines.
Data analysis and visualization: perform quick analyses and generate visuals from data tables, while maintaining formula-driven calculations.

Quick Start

Use the xlsx skill to create a simple workbook with a data table and a formula, then run the provided recalculation script to verify formulas.

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 editing without breaking existing templates?▼

Automating Excel workbook creation preserves template integrity by using OpenPyXL for manipulation and LibreOffice for formula recalculation. This ensures existing styling and formulas stay intact during automated updates, generating properly documented outputs with zero formula errors.

Can I use LibreOffice to recalculate formulas in OpenPyXL generated workbooks?▼

Yes, LibreOffice recalculates formulas in OpenPyXL generated workbooks via a recalc.py script. This combination applies formula-driven calculations accurately while enforcing zero-formula-errors and proper documentation in the final output files.

What is the best way to automate data analysis and visualization in Excel for financial reporting?▼

Automating data analysis and visualization in Excel handles data-heavy financial workflows by performing quick analyses and generating visuals from data tables. It maintains formula-driven calculations and consistent styling guidelines throughout the reporting process.

Does this Excel automation approach work for data-heavy analytics workflows requiring formula integrity?▼

Yes, this Excel automation approach suits data-heavy analytics workflows by handling template preservation, formula integrity, and data visualization. It enforces zero-formula-errors and proper documentation in outputs for finance, reporting, and analytics contexts.

Why do my formulas break when I programmatically edit Excel spreadsheets?▼

Formulas break during programmatic Excel editing when recalculation is missing. Using LibreOffice-based formula recalculation via recalc.py after manipulating workbooks with OpenPyXL ensures formula integrity and prevents calculation errors in the final output.