# 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

Source: https://allyhub.com/docs/reference/cli/sheet-diff · AllyHub 0.10.0
Index of all docs: https://allyhub.com/llms.txt

## Usage

```bash
allyhub sheet diff [was] [now] [options]
```

## 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

| 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

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

## Examples

```bash
allyhub sheet diff finance/budget finance/budget-v2
allyhub sheet diff finance/budget ~/Downloads/budget.xlsx --json
```

## Exit codes

`0` when it succeeds; the others are listed in [Exit codes](https://allyhub.com/docs/reference/cli/exit-codes.md).

## In the work

**sheets**: Making a sheet

[`sheet capabilities`](https://allyhub.com/docs/reference/cli/sheet-capabilities.md) → [`sheet import`](https://allyhub.com/docs/reference/cli/sheet-import.md) → [`sheet calc`](https://allyhub.com/docs/reference/cli/sheet-calc.md) → [`sheet trace`](https://allyhub.com/docs/reference/cli/sheet-trace.md) → `sheet diff` → [`inspect sheet`](https://allyhub.com/docs/reference/cli/inspect-sheet.md) → [`sheet`](https://allyhub.com/docs/reference/cli/sheet.md) → [`frames`](https://allyhub.com/docs/reference/cli/frames.md) → [`check`](https://allyhub.com/docs/reference/cli/check.md) → [`dev`](https://allyhub.com/docs/reference/cli/dev.md) → [`render`](https://allyhub.com/docs/reference/cli/render.md)
