Work on an EXISTING Excel workbook with the GridCraft engine in one command: recalculate and VERIFY formulas (an oracle that recomputes every formula and reports cells whose cached value differs), evaluate a formula against a workbook, print a range as a table, convert xlsx to CSV/JSON/HTML/PDF, add a chart, set cells or ranges and save. Use for: check this spreadsheet's formulas, what does cell X compute, xlsx to csv or pdf, add a chart to my sheet, fill cells in a given workbook. For a NEW workbook from CSV or a spec use sheet-builder. Triggers: verify formulas, recalculate, audit spreadsheet, xlsx to csv, add chart, evaluate formula, what is in this sheet.
Say it in your own words; the assistant finds this recipe by itself. Examples:
Work on an EXISTING Excel workbook with the GridCraft engine in one command: recalculate and VERIFY formulas (an oracle that recomputes every formula and reports cells whose cached value differs), evaluate a formula against a workbook, print a range as a table, convert xlsx to CSV/JSON/HTML/PDF, add a chart, set cells or ranges and save. Use for: check this spreadsheet's formulas, what does cell X compute, xlsx to csv or pdf, add a chart to my sheet, fill cells in a given workbook. For a NEW workbook from CSV or a spec use sheet-builder. Triggers: verify formulas, recalculate, audit spreadsheet, xlsx to csv, add chart, evaluate formula, what is in this sheet.
python3 /skills/grid-craft/scripts/grid.py <verb> … wraps gridcraft-cli, a native spreadsheet
engine (514 Excel functions) that reads and writes real .xlsx without Excel. Every verb prints one
OK … or one ERROR … line. Inputs are in /work/in; write results to /work/out.
| Need | Command |
|---|---|
| Verify every formula (recompute, compare with saved values) | grid.py check /work/in/budget.xlsx |
| What does a formula give on this workbook | grid.py eval /work/in/budget.xlsx "=SUM(Sheet1!B2:B20)" |
| Show a range (values or formulas) | grid.py cat /work/in/budget.xlsx --range A1:F12 [--sheet Data] [--formulas] |
| Sheets, ranges, tables, charts, names | grid.py info /work/in/budget.xlsx |
| xlsx → CSV / JSON / HTML / PDF | grid.py convert /work/in/budget.xlsx /work/out/budget.pdf [--sheet Data] |
| Add a chart | grid.py chart /work/in/sales.xlsx /work/out/sales.xlsx --range A1:B13 --type column --title "Revenue by month" --at H2 |
| Set cells or a range | grid.py set /work/in/budget.xlsx /work/out/budget.xlsx --cell C2 --input "=B2*1.1" (repeat --cell/--input, or --range A1 --values '[[1,2],[3,4]]') |
Other edits: gridcraft-cli commands lists every command and gridcraft-cli functions the function
library; grid.py edit IN OUT --script edit.json runs a list of {"command", "params"}.
After an edit, run grid.py check on the result and give the person the links.
SKILL.mdscripts/grid.pyWritten by Percerno, MIT licence.