55 lines
1.1 KiB
JavaScript
55 lines
1.1 KiB
JavaScript
#!/usr/bin/env node
|
|
|
|
const yargs = require("yargs");
|
|
const excel2json = require("./../index");
|
|
|
|
const options = yargs
|
|
.usage("Usage: -i <input> -o <output> -m <mapper>")
|
|
.option("i", {
|
|
alias: "input",
|
|
describe: "Input File Excel (Required .xlsx)",
|
|
type: "string",
|
|
demandOption: true,
|
|
})
|
|
.option("o", {
|
|
alias: "output",
|
|
describe: "Output File to JSON",
|
|
type: "string",
|
|
demandOption: false,
|
|
})
|
|
.option("m", {
|
|
alias: "mapper",
|
|
describe: "Mapper File in JSON",
|
|
type: "string",
|
|
demandOption: false,
|
|
})
|
|
.option("s", {
|
|
alias: "sheet",
|
|
describe: "Sheet Name in workbook",
|
|
type: "string",
|
|
demandOption: false,
|
|
})
|
|
.option("p", {
|
|
alias: "print",
|
|
describe: "Print the exported json to console",
|
|
type: "boolean",
|
|
demandOption: false,
|
|
}).argv;
|
|
|
|
const inputFile = options.input;
|
|
const outputFile = options.output;
|
|
const mapperFile = options.mapper;
|
|
const sheetName = options.sheet;
|
|
const print = options.print;
|
|
|
|
const exported = excel2json({
|
|
inputFile: inputFile,
|
|
mapperFile: mapperFile,
|
|
outputFile: outputFile,
|
|
sheetName: sheetName,
|
|
});
|
|
|
|
if (print) {
|
|
console.log(exported);
|
|
}
|