vgrid fill

Fill a .sheet template with CSV data. Uses strict numeric parsing: integers and exact 2-decimal amounts only. Rejects currency symbols, commas in numbers, and formula injection. All other values are treated as text.

vgrid fill <template> --csv <file> --target <cell> --out <output> [options]

Option	Description
--csv	CSV file to load (required)
--target	Target cell, optionally sheet-prefixed e.g. tx!A1 (required)
--out	Output .sheet file path (required)
--headers	First CSV row is headers
--clear	Clear all data cells on the target sheet before filling
--delimiter	CSV delimiter (default: ,)
--json	Output JSON result

Examples

# Fill a template with CSV data
vgrid fill model.sheet --csv data.csv --target tx!A1 --headers --out filled.sheet

# Target a cell on the default sheet
vgrid fill model.sheet --csv data.csv --target A1 --out filled.sheet

# Clear existing data before filling
vgrid fill model.sheet --csv data.csv --target tx!A1 --headers --clear --out filled.sheet

# JSON output for scripting
vgrid fill model.sheet --csv data.csv --target tx!A1 --headers --out filled.sheet --json

Exit codes

Code	Meaning
0	Success
2	Bad arguments (invalid target, missing flags)
3	IO error (file not found, write failure)
4	Parse error (CSV format violation)