Skip to content
Get started

allyhub sheet diff

Two versions of a workbook compared, by value and by formula: two sheets (each its id or its file), or a sheet and an .xlsx. Cells whose formula changed and value did not are apart from those whose value changed; rows of a table line up by its key, else by their place

Terminal window
allyhub sheet diff [was] [now] [options]
Argument Type What it is
<was> string The version before: a sheet (its file or its id) or an .xlsx
<now> string The version after: a sheet (its file or its id) or an .xlsx
Option Type Default What it does
--tolerance number 0 How far apart two numbers may be, as a share of the larger, and be the same
--all boolean false Every cell, not the first 50 of each kind

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

Terminal window
allyhub sheet diff finance/budget finance/budget-v2
allyhub sheet diff finance/budget ~/Downloads/budget.xlsx --json

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?