How to import an Excel File with Nodejs?

Question

I am a nodeJS programmer. I want to the import excel file into my mongoDB database table with validation.

Validation like if any field is blank then that record not inserted into database and after importing all data from the file display this record not inserted because that field is blank.

There are many package are available but i am confuse which one is better for import excel file.

So please help me which package to use to import an Excel file. And if a demo code is possible please answer it.

npmjs.com/search?q=keywords:excel will give you libraries with examples of implementation. — TGrif
– TGrif, Commented May 3, 2019 at 11:48

Mital Marakana · Accepted Answer · 2020-03-18 10:07:36Z

router.post('/transferFiles', function (req, res) {
  var neatCsv = require('neat-csv');
  var array;
  var fs = require('fs');

  var storage02 = multer.diskStorage({
    destination: function (req, file, cb) {
      cb(null, './uploads/');
    },
    filename: function (req, file, cb) {
      cb(null, Date.now() + file.originalname);
    }
  });
  var upload02 = multer({
    storage: storage02
  }).single('file');

  console.log("req.file");
  console.log(req.files);

  upload02(req, res, function (err) {
    if (err) {
      console.log("upload error 1" + err);
    }
    //console.log(req.file);
    /** Multer gives us file info in req.file object */
    if (!req.file) {
      console.log('No file Passed 1');
      return;
    }
    fs.readFile(req.file.path, async function (err, result02) {
      if (err) {
        console.error(err);
        return;
      }
      array = await neatCsv(result02);
});

here result02 is added in array.so easily you can data to mongodb with help of json

Collectives™ on Stack Overflow

How to import an Excel File with Nodejs?

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