processing-xlsx

Create and edit Excel workbooks with dynamic formulas and template preservation.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Streamline spreadsheet creation, editing, and analysis by handling formulas, formatting, and data workflows while preserving existing templates and conventions.

Core Features & Use Cases

  • Workbook creation, editing, and analysis with formula support.
  • Template preservation and consistent formatting when updating existing workbooks.
  • Data analysis and visualization workflows across common spreadsheet formats (XLSX, XLSM, CSV).

Quick Start

Run the recalc script to recompute all formulas in an Excel workbook.

Frequently Asked Questions about processing-xlsx

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

FAQPage Schema
How do I edit an Excel template and preserve its formatting and formulas?

To edit an Excel template while preserving formatting and formulas, this Skill automates workbook updates across XLSX, XLSM, and CSV formats, ensuring existing template conventions and dynamic formulas remain intact during data injection.

How do I recalculate Excel formulas automatically using Python and LibreOffice?

You can recalculate Excel formulas automatically using the built-in recalc.py utility, which leverages LibreOffice to recompute formula values in XLSX and XLSM workbooks and generates a JSON-style summary of common errors like #REF! and #DIV/0!.

Do I need Python and pandas to automate Excel workbook analysis?

Yes, you need Python tooling including pandas and openpyxl to run this Skill's workbook analysis and editing workflows. These libraries handle data manipulation and spreadsheet structure parsing for financial models and reporting.

What is the best way to detect formula errors like #REF! in an Excel workbook?

The best way to detect formula errors like #REF! and #DIV/0! in an Excel workbook is running the recalc.py utility, which evaluates formulas via LibreOffice and outputs a JSON-style error summary flagging common spreadsheet calculation issues.

Can I update financial models in XLSM format without breaking existing macros?

You can update financial models in XLSM format while retaining template structure and formatting. The Skill supports XLSM files alongside XLSX and CSV, applying data updates dynamically while preserving existing spreadsheet conventions.