XLSX Import - Command Line Interface
Command line interface for xlsx-import. Configurable import spreadsheet files with TS types support.
Part of XToolSet - collection of tools makes handling spreadsheet handy, easy with great developer experience.
Usages
Global installation
# Install globally:
npm i -g sxi
# Usages:
sxi config.js invoice.xlsx > result.json
Local installation
1. Install package
# install globally:
npm i --save sxi
# usages:
node_modules/.bin/sxi config.js invoice.xlsx > result.json
# usages with npx
npx sxi config.js invoice.xlsx > result.json
2. Additionally, possible to use with packages.json scripts
package.json:
{
"scripts": {
"import-xlsx":"sxi config.js invoice.xlsx > result.json"
}
}
bash:
npm run import-xlsx
Examples
sxi config.js invoice.xlsx > result.json
# Additionally, great piping with xlsx-renderer-cli: (required `sxr` installed)
sxi config.js invoice.xlsx | sxr template.xlsx > refreshed-invoice.xlsx
Command body
sxi [options] <config.js> [input.xlsx]
Arguments
-
<config.js>
indicate the config file. -
[input.xlsx]
data source.
Output
The sxi
writes into stdout
imported data as a json, to save it into a file please to append > filename.json
.
It is also allowed using pipe parameter to forward imported data into another command.
The Configuration File
The config inherit from xlsx-import
. Please use link below for more information:
Support
If any help needed, just feel free to create an issue. We will be really thankful for added links into stackoverflow topics if exists.
We are ready to provide paid support, in order that please contact me: hi@siemienik.pl or support@siemienik.pl.