Test cases / sheet

deft sheet info

Sheet names, rows, columns

1 run on real files, 1 test 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.

Answer a question about a workbookPassed

List the sheet names in issues.xlsx, one per line, in sheets.txt.

deft sheet info issues.xlsx > sheets.txt

Input

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

Rendered by macOS Quick Look, first page

Output

ok sheet.info issues.xlsx  datatypes: 6 rows x 1 columns, Sheet1: 1 rows x 1 columns, issue2: 3 rows x 2 columns, issue5: 1 rows x 1 columns, issue6: 4 rows x 1 columns, spc_chrs: 8 rows x 1 columns
sheets=[{"name":"datatypes","rows":6,"columns":1},{"name":"Sheet1","rows":1,"columns":1},{"name":"issue2","rows":3,"columns":2},{"name":"issue5","rows":1,"columns":1},{"name":"issue6","rows":4,"columns":1},{"name":"spc_chrs","rows":8,"columns":1}]
Automatic checks (1)
  • text: file = "sheets.txt", contains = ["datatypes", "issue2", "spc_chrs"]