xlsx

Create, edit, and recalculate Excel spreadsheets with formulas using openpyxl and LibreOffice.

2|Updated May 30, 2026
One-click install
npx skills add https://github.com/virahitvin8/crafty-gis --skill xlsx-virahitvin8
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/virahitvin8/crafty-gis/tree/main/GIT_STAR/assignment-generator/antigravity-skills-main/antigravity-skills-main/skills/xlsx
Command: npx skills add https://github.com/virahitvin8/crafty-gis --skill xlsx-virahitvin8

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve? Working with spreadsheet files programmatically often produces broken formulas, hardcoded values, and inconsistent formatting. This Skill provides a complete workflow for creating, editing, and analyzing .xlsx, .xlsm, .csv, and .tsv files while guaranteeing zero formula errors and professional financial-model formatting standards. ## Core Features & Use Cases - Formula-First Spreadsheet Creation: Build workbooks with live Excel formulas via openpyxl instead of hardcoded Python-computed values, keeping files dynamic and updateable. - Automated Recalculation & Error Detection: Run the bundled recalc.py script to recalculate all formulas through LibreOffice and receive a JSON report of every #REF!, #DIV/0!, #VALUE!, or #N/A error with exact cell locations. - Financial Modeling Standards: Apply industry color conventions (blue inputs, black formulas, green cross-sheet links), number formats, and assumption-cell documentation automatically. - Use Case: A user asks to build a revenue projection model from raw sales data; the Skill generates the workbook with formulas, recalculates it via LibreOffice, fixes any reported errors, and delivers a clean .xlsx file. ## Quick Start Create an Excel financial model from my sales data with growth formulas and verify it has no formula errors.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I create an Excel file with formulas in Python?

Use openpyxl to write formula strings like '=SUM(B2:B9)' directly into cells, then save the workbook. Formulas are stored but not evaluated, so run the recalc.py script with LibreOffice to compute values and verify correctness.

Should I use pandas or openpyxl for Excel files?

Use pandas for data analysis, bulk operations, and simple exports with pd.read_excel and df.to_excel. Use openpyxl when you need formulas, cell formatting, multiple sheets, or edits to existing workbooks while preserving structure.

Why do openpyxl formulas show no calculated values?

openpyxl stores formulas as strings without evaluating them, so cells appear empty when read with data_only=True. Recalculate the file with LibreOffice using the recalc.py script to populate computed values.

How do I find #REF! or #DIV/0! errors in an Excel file?

Run python scripts/recalc.py on the workbook; it recalculates all formulas and returns JSON listing every error type with exact sheet and cell locations. Fix the referenced cells and rerun until the status is success.

Can I edit an existing Excel template without breaking its formatting?

Yes, load the file with openpyxl's load_workbook to preserve existing formulas and styles, then modify only the target cells. Match the template's established conventions rather than imposing new formatting.