How to save array of objects in MongoDB.in a Node.js application

Question

I am trying to upload an Excel file to MongoDB database.

I used below NPM package manager to convert Excel data to MongoDB

mongoXlsx.xlsx2MongoData(path, model, function(err, data){
  console.log(data); // (This variable data has an array of objects, each object is a row in Excel.)
});

The image attached has the data. Now, I want to upload this 'data' (That has an array of objects) into MongoDB. How can I do that? Please suggest.

Mongodb only takes data which are in json format, are you making sure that before pushing your data to mongodb, you are converting it into correct json format ? — zenwraight
– zenwraight, Commented Apr 25, 2018 at 20:33
Please format the code. just click on edit, select the code and type ctrl-K — Mozahler
– Mozahler, Commented Apr 26, 2018 at 1:53

Hayfa · Accepted Answer · 2018-04-25 21:51:58Z

1

You can use a for loop to iterate through the array , and insert each element of the array in a single mongoDB document :

for ( var counter=0 ;counter<data.length;counter++)
{
    dataBaseName.colletionName.insertOne(data[counter]);
}

but before that, as @zenwraight pointed out, you should convert your data into correct json format , for example Name : 'ABC' should become 'Name' : 'ABC' (same goes for other fields)

answered Apr 25, 2018 at 21:51

Hayfa

1452 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

How to save array of objects in MongoDB.in a Node.js application

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