Excel Fomart Tool
install
npm install excel-format -g
usage
as node.js module
var excelFormat = ;var output = excel;console;
as command line
Usage: excelformat options <excel-file> Options: -h --help output usage information -V --version output the version number -t --template <file> template file for formating in mustache and ejs -s --sheet <n> the sheet index default 0 -o --output <file> the file to put the formating result
template
simple way: direct use mustache
== the sheet meta ==sheetname == use excel axis ==1A 2B ! == use number indexes ==Yes 33 42 51
complex way: use ejs to generate mustache template, then use generated template to format
== complex case ==<% for var i = 'A'; i <= 'E'; i++ %>7<%= String %><% %>