Test cases / sheet

deft sheet split

Split up: --sheets, --columns city or --every 1000

2 runs on real files, 6 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.

Export every sheetPassed

Export every sheet of issues.xlsx to its own CSV in a folder called sheets.

deft sheet split issues.xlsx --sheets --to csv -o sheets/

Input

issues.xlsx 13.3 KB
Rendered by macOS Quick Look, first page

Rendered by macOS Quick Look, first page

Output

1
1.5
ab
false
test
2016-10-20
1
2
ab
false
&
<
>
aaa ' aaa
""""
☺
֍
àâéêèçöïî«»
Automatic checks (1)
  • count_files: glob = "sheets/*.csv", count = 6

Split into files of 100 rowsPassed

Split countries.csv into files of 100 rows each in a folder called parts.

deft sheet split countries.csv --every 100 -o parts/

Input

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

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 101 rows.

NameCode
HungaryHU
IcelandIS
IndiaIN
IndonesiaID
Iran, Islamic Republic ofIR
IraqIQ
IrelandIE
Isle of ManIM
IsraelIL
ItalyIT
JamaicaJM
JapanJP
JerseyJE
JordanJO
KazakhstanKZ
KenyaKE
KiribatiKI
Korea, Democratic People's Republic ofKP
Korea, Republic ofKR
KuwaitKW
KyrgyzstanKG
Lao People's Democratic RepublicLA
LatviaLV

Showing 24 of 101 rows.

NameCode
Sint Maarten (Dutch part)SX
SlovakiaSK
SloveniaSI
Solomon IslandsSB
SomaliaSO
South AfricaZA
South Georgia and the South Sandwich IslandsGS
South SudanSS
SpainES
Sri LankaLK
SudanSD
SurinameSR
Svalbard and Jan MayenSJ
SwedenSE
SwitzerlandCH
Syrian Arab RepublicSY
Taiwan, Province of ChinaTW
TajikistanTJ
Tanzania, United Republic ofTZ
ThailandTH
Timor-LesteTL
TogoTG
TokelauTK

Showing 24 of 50 rows.

Automatic checks (1)
  • count_files: glob = "parts/*.csv", count = 3