skills.rest
patronus-ai
patronus-aiOFFICIAL
Explore all skills by this author →
GitHub

xlsx

Generate, edit, and validate formula-driven spreadsheet workbooks with LibreOffice recalculation.

2|2|Updated Mar 26, 2026
Search Tags:#financial modeling#data analysis#xlsx#template editing#recalculation#excel formulas#spreadsheet modeling
One-click install
npx skills add https://github.com/patronus-ai/skill-inject --skill xlsx-patronus-ai
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/patronus-ai/skill-inject/tree/main/data/skills/document-skills/xlsx
Command: npx skills add https://github.com/patronus-ai/skill-inject --skill xlsx-patronus-ai

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps you create, edit, and analyze spreadsheet files while maintaining formula correctness and preventing Excel error states that break downstream decisions.

Core Features & Use Cases

  • Create and update spreadsheets: Generate new .xlsx/.xlsm/csv/tsv-style workbooks with formulas, formatting, and analysis-ready structure.
  • Preserve and extend existing templates: Modify existing models without overwriting established layout, style, or conventions.
  • Recalculate and verify formulas: Use LibreOffice-based recalculation plus an error scan to ensure no #REF!, #DIV/0!, #VALUE!, #N/A, or related formula failures remain.
  • Financial model support: Enforce practical equity/valuation model conventions (color coding, number formats, assumption cells, and link behavior).
  • Data analysis workflows: Use pandas for reading/analysis and openpyxl for formula- and format-aware spreadsheet edits.

Quick Start

Use the xlsx skill to create a working financial model in 'model.xlsx' with correct formulas and zero Excel formula errors.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I build a financial model in Excel without formula errors?▼

Building a financial model in Excel without formula errors requires constructing formula-driven workbooks and recalculating them to verify zero Excel error values like #REF! or #DIV/0!. This approach uses LibreOffice-based recalculation and strict error scanning to ensure correctness.

Can I update an existing spreadsheet template without overwriting its formatting?▼

Yes, you can update an existing spreadsheet template without overwriting its formatting by performing template-preserving modifications. This process maintains established layout, style, and financial conventions while extending the model with new formulas and data.

What is the best way to automate Excel formula recalculation and validation?▼

Automating Excel formula recalculation and validation is best achieved through LibreOffice-based recalculation scripts combined with an automated error scan. This ensures no #VALUE!, #N/A, or related formula failures remain in your spreadsheet.

Does pandas work with openpyxl for spreadsheet modeling and editing?▼

Yes, pandas works with openpyxl for spreadsheet modeling and editing by combining their strengths. Pandas handles data reading and analysis workflows, while openpyxl performs formula- and format-aware spreadsheet edits to maintain model correctness.

Why do my spreadsheet formulas return #REF! or #DIV/0! errors after editing?▼

Spreadsheet formulas return #REF! or #DIV/0! errors after editing due to broken cell references or invalid operations. Preventing Excel error values requires strict formula validation and LibreOffice-based recalculation to scan and eliminate these failures.

Related Skills

Explore More Data & Analytics Skills→
eduardoabreu81eduardoabreu81
6

xlsx

Create and analyze XLSX workbooks with openpyxl, validating formulas and recalculations.

Community
Advanced
stefanbosakstefanbosak

xlsx

Automate Excel creation, editing, and analysis with formula-safe workflows.

Community
Advanced
zjy-devzjy-dev
2

xlsx

Create, edit, and analyze Excel files with pandas and openpyxl.

Community
Advanced
InverterNetworkInverterNetwork

dcf-model

Generate Excel DCF valuation models with WACC and sensitivity analysis.

Official
Advanced