skills.rest
quangtuyennguyen
quangtuyennguyenCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create, edit, and analyze Excel spreadsheets with formulas, formatting, and recalculation.

Updated Apr 16, 2026
Search Tags:#pandas#openpyxl#spreadsheet#excel#xlsx#financial model#formula recalculation
One-click install
npx skills add https://github.com/quangtuyennguyen/loan-application-workflow --skill xlsx-quangtuyennguyen
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/quangtuyennguyen/loan-application-workflow/tree/main/.claude/skills/xlsx
Command: npx skills add https://github.com/quangtuyennguyen/loan-application-workflow --skill xlsx-quangtuyennguyen

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 leads to broken formulas, hardcoded values that can't update, 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 output standards. ## Core Features & Use Cases - Formula-first spreadsheet generation: Builds Excel files using openpyxl with live formulas instead of hardcoded values, so spreadsheets recalculate when source data changes. - Automated recalculation and error detection: Uses the bundled recalc.py script with LibreOffice to recalculate all formulas and report exact cell locations of errors like #REF!, #DIV/0!, and #VALUE!. - Financial modeling standards: Enforces industry color conventions (blue inputs, black formulas, green cross-sheet links), number formatting rules, and source documentation for hardcoded values. - Use Case: Ask the assistant to build a three-year revenue projection model from a CSV of historical sales, and receive a formatted .xlsx with assumption cells, growth formulas, and verified zero formula errors. ## Quick Start Use the xlsx skill to create a formatted Excel financial model from my sales data CSV with live formulas and no calculation 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. Run the recalc.py script afterward so LibreOffice calculates the formula values and reports any errors.

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.

Why do openpyxl formulas show no calculated values?▼

openpyxl stores formulas as strings but never evaluates 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 and fix #REF! or #DIV/0! errors in Excel files?▼

Run recalc.py on the workbook; it returns JSON listing each error type with exact sheet and cell locations. Fix invalid references or unguarded divisions, then recalculate again until the status is success.

Can I edit an existing Excel template without losing its formatting?▼

Yes, load the file with openpyxl's load_workbook, modify cells, rows, or sheets, and save. Avoid opening with data_only=True before saving, since that permanently replaces formulas with static values.

Related Skills

Explore More Data & Analytics Skills→
brainbrewlabsbrainbrewlabs
7

data-cleaning

Profile and clean tabular datasets, then write a cleaned file with a change report.

Official
Intermediate
Duzhenyang111Duzhenyang111

audit-xls

Validate Excel workbooks for formula errors and structural flaws using Python.

Community
Advanced
jacob-dietlejacob-dietle
104

epistemic-context-grounding

Verify implementation assumptions against canonical domain documentation.

Community
Advanced
cellarwoodcellarwood

gws-sheets-read

Read cell values from Google Sheets via the gws CLI.

Official
Basic