XLSX Processing

SkillFiles & storage

Processes Excel spreadsheet files (.xlsx, .xlsm, .csv). Creates workbooks, builds formulas, preserves formatting, analyzes tabular data, and validates financial models with zero-formula-error delivery. Use when working with spreadsheet files or tabular data analysis. Do NOT use for Word documents, PDFs, presentations, or database pipelines.

Available today. Use it from your connected AI after setup.

Connect ahel once, and every AI you use reads what you have installed.

Then ask your AI: use the XLSX Processing skill

What this skill tells your AI

The instructions your AI receives, as published by telagod/code-abyss in skills/analyzing-spreadsheets/SKILL.md and read by ahel’s review.

Create, edit, analyze .xlsx files. LibreOffice required for formula recalculation via recalc.py.

Iron Rule

Zero formula errors at delivery. All formulas must compute — no #REF!, #DIV/0!, #VALUE!, #N/A, #NAME?. Always run recalc.py after writing formulas.

Decision Matrix

TaskToolReference
Data analysis, bulk ops, simple exportpandasrecipes.md
Formulas, formatting, Excel featuresopenpyxlrecipes.md
Financial model standardsfinancial-model.md
Recalculate formulasrecalc.pyrecipes.md

Common Workflow

  1. Choose tool: pandas for data, openpyxl for formulas/formatting
  2. Create/Load workbook
  3. Modify data, formulas, formatting
  4. Save
  5. Recalculate (MANDATORY if formulas): python recalc.py output.xlsx
  6. Verify & fix errors — check JSON output, fix #REF! / #DIV/0! / #VALUE! / #NAME?

Hard Constraints

  • Use formulas, not hardcoded values — calculations stay dynamic. See recipes.md.
  • Preserve existing templates — match existing format/style EXACTLY when updating; user template overrides defaults.
  • Financial models — follow color/format conventions in financial-model.md.

Code Style

  • Concise Python, no unnecessary comments or print statements.
  • Excel files: comment cells with complex formulas, document hardcode sources.

Signals

GitHub stars
239
Forks
32
Last commit
Jul 2026

ahel review

  • K6low
    bundled executables the agent is told to run

Automated review, not a security audit. Ruleset v1+k2.

Advanced
Catalog kind
skill
Gateway key
analyzing-spreadsheets
Source
github.com/telagod/code-abyss