Skip to content
Get started

allyhub inspect sheet

A workbook's facts, for you to judge, never problems: error values by cell, numbers written into formulas, a cell unlike its neighbours, what nothing reads, exceptions in calculated columns, values under a validation that breaks them, the rounds iterative calculation ran

Terminal window
allyhub inspect sheet [sheet] [options]
Argument Type What it is
<sheet> string The sheet, by its file or its id in allyhub.yaml
Option Type Default What it does
--kind list of string Only facts of these kinds: sheet-error, sheet-number, sheet-unlike, sheet-exception, sheet-unused, sheet-invalid, sheet-typed, sheet-ordinary, sheet-iteration
--plain string "0,1,-1" Numbers a formula may hold and not be said, by commas; –all says them too
--around integer 1 How many neighbours each side must read alike for a cell to be unlike them
--all boolean false Every finding on a line of its own, and every number in every formula, and a table’s columns nothing reads

--dir <value>: the project’s folder; default the one around where it is run. --json: print the result as JSON.

Terminal window
allyhub inspect sheet finance/budget
allyhub inspect sheet finance/budget --kind sheet-error,sheet-number
allyhub inspect sheet finance/budget --plain 0,1,100 --all

0 when it succeeds; the others are listed in Exit codes.

sheets: Making a sheet

sheet capabilities → sheet import → sheet calc → sheet trace → sheet diff → inspect sheet → sheet → frames → check → dev → render

Was this page helpful?