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
Output
sheets.txt 447 B
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"]
