Spreadsheet-Templater-CLI
Command line interface for @MomsFriendlyDevCo/Spreadsheet-Templater
This command takes an input + output file path and allows setting of data within the spreadsheet.
Usage: spreadsheet-templator [arguments] <input.xlsx> <output.xlsx>
Options:
-V, --version output the version number
-d, --data [key=val] Set a data value - use multiple times if needed
(default: {})
--repeat [key=size] Create an empty data array of a given size (useful when
using faker) - can be specified multiple times
(default: {})
-i, --input [file] Specify an input XLSX file (alternative method)
-o, --output [file] Specify an output XLSX file (alternative method)
-v, --verbose Be verbose - use multiple to increase verbosity
-h, --help display help for command
Notes:
* @faker-js/faker is available as `faker` within a template
* lodash is available as `_` within a template
Examples:
# Create output.xlsx (from input.xlsx) setting `people` to an empty array of 100 items
spreadsheet-templator --repeat=people=100 input.xlsx output.xlsx