xlsx-script

A framework that uses XLSX workbooks to create domain specific scripting languages.

Documentation

This simple framework processes XLSX workbooks (created with MS Excel, Numbers, Sheets, Calc, etc).

The workbooks, sheets and rows are read and processed sequentially following a simple set of actions.

The actions are also defined in the workbook(s) using javascript.

The defined action sequences can be used to automate just about any javascript API.

Installation

• Install the xlsx command.

user@laptop:~/Workspaces/test$ npm i -g xlsx-script

/usr/bin/xlsx -> /usr/lib/node_modules/xlsx-script/lib/index.js
+ xlsx-script@0.8.1
added 67 packages from 13 contributors in 3.113s

user@laptop:~/Workspaces/test$

• Test the installation by displaying the command help page.

user@laptop:~/Workspaces/test$ xlsx help

xlsx <command>

Commands:
  xlsx diff    compare two (or more) XLSX workbooks
  xlsx info    display information about the input file
  xlsx run     run the automation script
  xlsx script  display the automation script

Options:
  --version      Show version number                                   [boolean]
  --compare, -c  compare file(s) [XLSX_COMPARE]                          [array]
  --debug        extra error logging                                   [boolean]
  --input, -i    input file(s) [XLSX_INPUT]                              [array]
  --output, -o   output file [XLSX_OUTPUT]                              [string]
  --verbose, -v  use verbose messages                                  [boolean]
  --help         Show help                                             [boolean]

user@laptop:~/Workspaces/test$

Changelog

• v0.11.0 add xlsx diff command
• v0.10.0 refactor - including script in vm2 changes
• v0.9.0 replaces variables with vm (vm2)
• v0.8.1 added Travis CI and Coveralls
• v0.8.0 completed intial framework with 100% test coverage

License

xlsx-script is freely distributable under the terms of the ISC license.