FORK NOTE: Fork just to change a version pointer in package.json which gave npm install issues.
Converting xlsx file to json files using nodejs
npm install xlsx-to-json
xlsxj = require("xlsx-to-json");
xlsxj({
input: "sample.xlsx",
output: "output.json"
}, function(err, result) {
if(err) {
console.error(err);
}else {
console.log(result);
}
});You can optionally provide a sheet name to extract from that sheet
xlsxj = require("xlsx-to-json");
xlsxj({
input: "sample.xlsx",
output: "output.json",
sheet: "tags"
}, function(err, result) {
if(err) {
console.error(err);
}else {
console.log(result);
}
});In config object, you have to enter an input path. But If you don't want to output any file you can set to null.
MIT @chilijung
