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