Use Node. js to convert Excel to JSON_node.js

This article records the use of node in personal projects. the js method and process for converting Excel to Json is very simple, practical, and detailed. Here we recommend it to anyone who needs it. I have been working on an online course selection system and have chosen node. js, which is popular nowadays. Today, I was thinking about how to import the student or teacher information into a large number of excel tables. I want to convert the excel file to json and then import it to mongodb.

I searched a lot of online materials. Most of them are C # or python. do you need to compile it yourself? do you need to run a variety of missing libraries. Google found that this module exists in node. The URL is https://www.npmjs.com/package/xls-to-json ..

Record the steps below:

To any location, create a package. json. I don't know why npm cannot be installed after I try it.

{ "name": "abc", "version": "0.0.0", "private": true, "scripts": {  "start": "node ./bin/www" }, "dependencies": {  "xls-to-json": "*" }}

Save the installation package and run npm install directly. Create app. js

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

This is the code of the above website that is directly pasted. Then, when the sheet error occurs, I directly comment it out.

Put test.xls in the same directory, and then click node app. js ..

The information of all the students is coded. We can see that it is successful.

This method is very simple and crude .. Mark and share here. there is a better way to pass by, or I suggest you leave a comment. Thank you.

The above is all the content of this article. I hope you will like it.