Menu

Individual skill

evo-excel-workbook-formula-io

Load existing workbooks with openpyxl, validate required sheets and ranges, write Excel formulas into existing cells, save safely, and trigger headless recalculation while preserving formatting.

tasks-evolved/weighted-gdp-calc/environment/skills/evo-excel-workbook-formula-io/SKILL.md

Read pinned source

Source commit 84ca182da055fafb6453dcec4a6defdbbfd987c1

What was checked

Matches the observed repository HEAD
Yes
Scanner rules are current
Yes
Repository scan complete
No
Skill scan complete
No
Observed behavior
Network or broad shell
Last checked
Nov 6, 2026

These are observations at the recorded commit, not a guarantee of safety. Review the source before running it.

Install this skill

Choose an agent in your Stack or copy a command below. Commands fetch the pinned commit and copy only this skill directory. Existing destinations are refused. Copying a command does not install anything.

An install command is unavailable: current rules, complete repository and skill scans, an eligible behavior level and a permitted license are required.

Repository context

Repository stars (not skill ratings)
97
Repository last updated
Sep 10, 2026
License
Apache-2.0

Observed agent integration: No specific integration evidence. Standard SKILL.md installation does not imply verified compatibility.

Files and excerpt

File metadata and permitted, redacted excerpts come from the recorded scan. Source links are pinned to that commit.

Browse files
Read excerpt

This skill handles workbook I/O and formula injection only.

Knowledge internalized:
- Use `openpyxl.load_workbook(filename=..., read_only=False, data_only=False, keep_vba=False, keep_links=True)` for editable `.xlsx` workbooks.
- Access sheets with `wb['Task']` style, not deprecated APIs.
- Write formulas as English Excel formulas beginning with `=` and using comma separators.
- Preserve workbook structure by modifying only existing sheets/cells; do not create/remove sheets.
- `openpyxl` does not calculate formulas; for reliable cached values on Linux, start LibreOffice headless with a UNO socket, open the workbook, call `calculateAll()`, and save/close it. Use plain `--convert-to` only as fallback.
- Validation should confirm required sheets exist before writing.
- When multiple skills have `utils.py`, use importlib file-based loading to avoid module-name collisions.

Functions:
- `load_editable_workbook(path)`
- `load_cached_workbook(path)`