Skip to content
Get started

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

Terminal window
allyhub sheet import [file] [options]
Argument Type What it is
<file> string The file to make a sheet of: .xlsx, .xlsm, .csv or .tsv
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

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

Terminal window
allyhub sheet import ~/Downloads/forecast.xlsx --to finance/forecast.yaml
allyhub sheet import ~/Downloads/leads.csv --to research/leads.yaml

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?