skills.rest
vadimcomanescu
vadimcomanescuCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

xlsx

Create, edit, and analyze .xlsx spreadsheets while preserving templates and formulas.

24|8|Updated Jan 14, 2026
Search Tags:#pandas#openpyxl#excel#xlsx#libreoffice#recalculation#financial-modeling
One-click install
npx skills add https://github.com/vadimcomanescu/codex-skills --skill xlsx-vadimcomanescu
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/vadimcomanescu/codex-skills/tree/main/skills/.curated/devtools/xlsx
Command: npx skills add https://github.com/vadimcomanescu/codex-skills --skill xlsx-vadimcomanescu

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill eliminates manual Excel errors and tedious spreadsheet maintenance by creating, editing, and validating .xlsx workbooks while preserving existing templates, formulas, and formatting. It enforces the use of Excel formulas instead of hardcoded values, ensures formula recalculation, and scans for common Excel error values so workbooks remain dynamic and auditable.

Core Features & Use Cases

  • Create robust spreadsheets with formulas, formatting, column widths, and basic visualization using openpyxl and pandas workflows.
  • Edit and preserve templates by matching existing styles and conventions exactly when updating files; never impose a new standard on established templates.
  • Recalculate and verify formulas using the provided scripts/recalc.py which configures LibreOffice, recalculates all formulas, and reports any Excel error values.
  • Data analysis and export: use pandas for analysis, summary statistics, and exporting results while leaving calculations to Excel formulas.
  • Financial modeling support: color coding, number formatting, assumption placement, and documentation conventions to produce audit-ready financial models.

Quick Start

Attach or point to a workbook and ask the skill to recalculate all formulas, scan and report any Excel errors, and return a corrected file that preserves formatting and templates.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I create and edit Excel xlsx files while preserving existing templates and formulas?▼

To edit xlsx files while preserving templates, use openpyxl workflows that match existing styles and conventions exactly, enforcing Excel formulas instead of hardcoded values to keep workbooks dynamic and auditable.

How do I recalculate Excel formulas in xlsx files using LibreOffice?▼

You can recalculate Excel formulas in xlsx files using LibreOffice by running a configuration script that triggers recalculation across all sheets, then scanning the workbook to report any Excel error values for verification.

What is the best way to build financial models in Excel that are audit-ready?▼

The best way to build audit-ready financial models in Excel is to apply standard conventions for color coding, number formatting, assumption placement, and documentation while using formulas instead of hardcoded values for complete transparency.

Can I use pandas for data analysis and export results into Excel formulas?▼

Yes, you can use pandas for data analysis, summary statistics, and exporting results, while leaving actual calculations to Excel formulas to ensure the spreadsheet remains dynamic and properly auditable.

Do I need LibreOffice installed to verify and recalculate formulas in xlsx workbooks?▼

Yes, you need LibreOffice installed to recalculate all formulas in xlsx workbooks, as the recalculation script configures LibreOffice specifically to process formulas and report any Excel error values present.

Why does my xlsx template lose formatting when I edit it with openpyxl?▼

Your xlsx template loses formatting when edits do not match existing styles and conventions exactly. Properly preserving templates requires enforcing strict style matching and cell convention preservation during any workbook updates.

Related Skills

Explore More Finance & Accounting Skills→
AutumnsGroveAutumnsGrove
26

xlsx

Automates Excel workbook creation, editing, and analysis via OpenPyXL and Pandas.

Community
Intermediate
eduardoabreu81eduardoabreu81
6

xlsx

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

Community
Advanced
bilalmkbilalmk
1

xlsx

Create and edit Excel workbooks with openpyxl and pandas while preserving formulas.

Community
Advanced
cxnaivecxnaive

lbo-model

Construct dynamic leveraged buyout models in Excel with automated formulas.

Community
Advanced