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
allyhub sheet diff [was] [now] [options]Arguments
Section titled “Arguments”| 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 |
Options
Section titled “Options”| 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 |
Global options
Section titled “Global options”--dir <value>: the project’s folder; default the one around where it is run. --json: print the result as JSON.
Examples
Section titled “Examples”allyhub sheet diff finance/budget finance/budget-v2allyhub sheet diff finance/budget ~/Downloads/budget.xlsx --jsonExit codes
Section titled “Exit codes”0 when it succeeds; the others are listed in Exit codes.
In the work
Section titled “In the work”sheets: Making a sheet
sheet capabilities → sheet import → sheet calc → sheet trace → sheet diff → inspect sheet → sheet → frames → check → dev → render