(Node) Consume a soap service

var soap = require('soap');
var parseString = require('xml2js').parseString;
var url = 'xxx.wsdl';

var args = { _xml: "xml representation of the request"  };
soap.createClient(url, function(err, client) {
if(err)
console.log("error:"+err);

client.funName(args, function(err, result, rawResponse, soapHeader, rawRequest) {
if(err)
console.log(err);

//optional, if response needed in json format
parseString(rawResponse, function (err, jsonResult) {
res.contentType('application/json');
res.send(JSON.stringify(jsonResult, null, 4));
});
});
});

(Node) Read from xlsx file

//npm install xlsx

if(typeof require !== 'undefined') XLSX = require('xlsx');
var workbook = XLSX.readFile('test.xlsx');
        // Selects the worksheet
var worksheet = workbook.Sheets["Sheet1"];
var range = XLSX.utils.decode_range(worksheet['!ref']);

for(var R = range.s.r; R <= range.e.r; ++R) {
  for(var C = range.s.c; C <= range.e.c; ++C) {
    var cell_address = {c:C, r:R};
    /* if an A1-style address is needed, encode the address */
    var cell_ref = XLSX.utils.encode_cell(cell_address);
            if(worksheet[cell_ref])
console.log(worksheet[cell_ref].v);
  }
}

Reference: https://www.npmjs.com/package/xlsx

(Node) Send Mail

// Following code send mail using SMTP information

Prerequisite NPM commands:
npm init -y
npm install nodemailer --save

Code starts from here

const nodemailer = require('nodemailer');

exports.sendMail = function(req, res, next) {
 nodemailer.createTestAccount((err, account) => {
      // create reusable transporter object using the default SMTP transport
      let transporter = nodemailer.createTransport({
          host: <<SMTP_IP>>,
          port: <<SMPT_PORT>>,
          secure: false,
          tls: {
          // do not fail on invalid certs
          rejectUnauthorized: false
      }

      });

      // setup email data with unicode symbols
      let mailOptions = {
          from: '"Harish Dewangan" <DoNotReply@company.com>', // sender address
          to: 'harish.dewangan@company.com', // list of receivers
          subject: 'Test mail , // Subject line
          html:    '<h2>This is a test mail <h2>'
      };

      // send mail with defined transport object
      transporter.sendMail(mailOptions, (error, info) => {
          if (error) {
              return console.log(error);
          }
          console.log('Message sent: %s', info.messageId);
      });

  });

 }