agent-sheet
INLINECODE0 is a local spreadsheet CLI for agents. Prefer it when the task needs real workbook structure, formulas, sheet lifecycle, import/export handoff, or a safe shell roundtrip instead of plain CSV cleanup or ad-hoc xlsx library use.
Use it for
- - resolving a workbook and keeping the target explicit with INLINECODE2
- inspecting workbook structure, sheets, ranges, formulas, and search hits
- writing sparse cells, bounded ranges, anchored review tables, or formula fills
- importing a local workbook, continuing edits, and exporting a final file
- streaming workbook data through shell tools, then writing verified results back
- using bounded
script js only when built-in commands do not express the workbook change cleanly
Do not default to
- - reopening the workbook with a local workbook library for reads or writes that
agent-sheet already covers - using shell transforms when a direct
write cells, write range, write table, write fill, or sheet ... command is clearer - trusting metadata-only surfaces such as
file info as proof of workbook structure - finishing after a write without a task-specific verification pass
First path
- 1. Run playbooks/00-preflight.md.
- Resolve the workbook and keep using
--entry-id. - Choose the smallest matching command via references/command-selection-matrix.md.
- Verify with playbooks/15-verify.md before finishing.
Hard defaults
- - prefer
entryId over unitId for local workbooks and imports - treat
write range as a full bounded rectangle replacement - treat
write table --sheet <name> as an A1-anchored table write with header semantics - verify shell roundtrips with structure plus sample rows, not row count alone
- use
sheet list or inspect workbook for sheet existence and handoff verification
Highest-signal gotchas
- - imported local entries can be healthy even when later
file info shows unitId: null; keep operating on INLINECODE20 - INLINECODE21 is metadata only; it does not prove sheet count, sheet names, or formula state
- do not run
init inside an already initialized workspace tree; nested workspace refusal is expected - non-English sheet names work, but quote the full A1 range string in the shell
- shell pipelines can preserve the expected row count while still shifting headers or keys; verify the first rows and key columns after writeback
Read references/gotchas.md when the task looks routine but has import/handoff, shell roundtrip, or workspace ambiguity.
Task routing
| Task | Read next |
|---|
| workspace root, CLI resolution, or workbook target is unclear | playbooks/00-preflight.md |
| inspect workbook state, extract data, search, or review formulas |
playbooks/10-read-analyze.md |
| plan the smallest safe mutation path |
references/command-selection-matrix.md |
| make data-visible edits or structural workbook changes |
playbooks/20-write-safe.md |
| verify a mutation, shell roundtrip, or handoff |
playbooks/15-verify.md |
| create, import, open, or export a local workbook |
playbooks/30-file-lifecycle.md |
| stream workbook data through shell tools |
references/shell-patterns.md |
| formatting, layout, or other built-in command gaps |
playbooks/40-script-fallback.md |
| import/handoff,
entryId targeting,
file info, or shell verification edge cases |
references/gotchas.md |
Output style
- - prefer bounded previews, file paths, or stream output over oversized inline dumps
- use
--to-stdout for shell pipelines - use
--to-file --output <path> for large reusable extracts - when reporting success, include the verification surface you actually used
Ready-made assets
Use these before improvising shell snippets:
exporting, importing, and proving handoff structure |
|
examples/template-import-anchor-check.md | importing a template workbook and checking anchor cells |
|
scripts/verifycsv_preview.py | comparing header, head sample rows, and a key column |
|
scripts/checkcsv_cells.py | asserting anchor values or non-empty cells from a CSV snippet |
Read next
Read only the file needed for the task:
inspecting workbook state, extracting data, searching, or reviewing formulas |
|
references/command-selection-matrix.md | picking the smallest correct command before writing |
|
playbooks/15-verify.md | proving a mutation or handoff actually succeeded |
|
playbooks/20-write-safe.md | choosing the smallest safe mutation path |
|
playbooks/30-file-lifecycle.md | creating, importing, opening, or exporting a local workbook |
|
playbooks/40-script-fallback.md | built-in commands cannot express the requested workbook change |
|
references/shell-patterns.md | the task is naturally a shell pipeline |
|
references/gotchas.md | the task involves common real-world failure modes |
|
references/js-api-minimal.md |
script js is necessary and must stay tightly bounded |
|
examples/roundtrip-awk-write-table.md | you need a concrete shell roundtrip example |
|
examples/handoff-verify.md | you need a concrete export/import handoff example |
|
examples/template-import-anchor-check.md | you need a concrete non-English template import example |