JAVASCRIPT

nodejs read file sent in the request without saving to file system

const multer = require('multer');
const {Duplex} = require('stream'); // It's a Native Node Module 
const fs = require('fs');
const readXlsxFile = require('read-excel-file/node')

const storage = multer.memoryStorage();
const upload = multer({
   storage: storage
});

function bufferToStream(bufferIn) {
    let duplex = new Duplex();
    duplex.push(bufferIn);
    duplex.push(null);
    return duplex;
}

app.post('/api/endpoint_name', upload.single('file'), function(req, res) {
    const file_buffer = req.file['buffer'];
    const file_stream = bufferToStream(file_buffer);
    const read_stream = fs.createReadStream(file_stream);
  	readXlsxFile(read_stream)
      .then(function(rows) {
      	console.log('Rows in the Excel : ', rows);
      });
});