Test cases / sheet

deft sheet extract

Take a sheet or range: --sheet, --range A1:D20

1 run on real files, 9 tests on generated files, not shown. 0 failed.

Real-file tasks

Real files and a plain-language job, from the agent benchmark. These are the reference answers, not an agent run.

Take part of a tablePassed

Save the header and first 10 rows of countries.csv as top10.csv.

deft sheet extract countries.csv --range A1:B11 -o top10.csv

Input

countries.csv 3.7 KB
NameCode
AfghanistanAF
AlbaniaAL
AlgeriaDZ
American SamoaAS
AndorraAD
AngolaAO
AnguillaAI
AntarcticaAQ
Antigua and BarbudaAG
ArgentinaAR
ArmeniaAM
ArubaAW
AustraliaAU
AustriaAT
AzerbaijanAZ
BahamasBS
BahrainBH
BangladeshBD
BarbadosBB
BelarusBY
BelgiumBE
BelizeBZ
BeninBJ

Showing 24 of 250 rows.

Output

top10.csv 148 B
NameCode
AfghanistanAF
AlbaniaAL
AlgeriaDZ
American SamoaAS
AndorraAD
AngolaAO
AnguillaAI
AntarcticaAQ
Antigua and BarbudaAG
ArgentinaAR
Automatic checks (1)
  • csv: file = "top10.csv", rows = 11, columns = 2