Excel to JSON conversion using Node JS

Question

I have been trying to convert excel sheet data to json format and I have already various modules like "xls-to-json","xls-to-json-lc","node-excel-to-json", So far I have got empty response.

My sample code goes like this :

var node_xj = require("xls-to-json");
node_xj({
    input: req.file.path,  // input xls
    output: "output.json", // output json
    sheet: "a"             // specific sheetname
}, function(err, result) {
    if(err) {
        console.error(err);
    } else {
        console.log("--------result----");
        console.log(result);
    }
});

My excel sheet contains very simple data :

What am i doing wrong in this , I am getting file and its valid path .

What is the result of result that you're printing to console? — Sudheesh Singanamalla
– Sudheesh Singanamalla, Commented Nov 26, 2017 at 14:21

Rajeev Akotkar · Accepted Answer · 2017-11-26 15:22:32Z

1

got the solution , all the libraries consider first row as header , so it was not getting displayed , it got displayed when i added 2nd row and every module has got its own structure of output/ response. some modules consider excel headers in output and skip the first row and few include first row .

answered Nov 26, 2017 at 15:22

Rajeev Akotkar

1,3979 gold badges29 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Excel to JSON conversion using Node JS

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related