allyhub sheet import
Makes a sheet of an Excel, CSV or TSV file: its sheets, tables, formulas, names and looks as a sheet file and CSV files, listed in allyhub.yaml, said what could not be carried over, each formula computed here and compared with the value the file holds; never over a file that is there
allyhub sheet import [file] [options]Arguments
Section titled “Arguments”| Argument | Type | What it is |
|---|---|---|
<file> |
string | The file to make a sheet of: .xlsx, .xlsm, .csv or .tsv |
Options
Section titled “Options”| Option | Type | Default | What it does |
|---|---|---|---|
--to |
string | The sheet’s file, from the project’s root (default <the file’s name>.yaml); its tables’ CSV files go beside it, under names no file there has | |
--max-unzipped |
number | 1536 |
MB the file may unzip to, a file past it refused |
--tolerance |
number | 1e-9 |
How far apart a computed number and the file’s may be, as a share of the larger, and count as the same; 0 lists every difference |
--all |
boolean | false |
Every difference, not the first 50 |
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 import ~/Downloads/forecast.xlsx --to finance/forecast.yamlallyhub sheet import ~/Downloads/leads.csv --to research/leads.yamlExit 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