title: How to read the data from Excel sheet and print the result on console while working on protractor
body: <p>I am working on AngularJs application testing framework where I am using Protractor. I want to read the data (urls, usernames, passwords) from an excel sheet. I am using the following code but it's showing me errors. </p>
  
  <p>Please find the below code: </p>
  
  <pre><code>var Excel = require('exceljs');
  var wrkbook = new Excel.Workbook();
  
  wrkbook.xlsx.readFile('E:\\Login_Data.xlsx').then(function() 
  {
      var worksheet = wrkbook.getWorksheet('Sheet1');
      worksheet.eachRow(function (Row, Test_URL) 
      {
          console.log("Row " + Test_URL + " = " + JSON.stringify(Row.User_Name));
      });
  });
  </code></pre>
  
  <p>The data from excel sheet is : </p>
  
  <pre><code>Test_URL    User_Name   Password
  http://...com   abc@1111    xyz@333
  </code></pre>
  
  <p>Please let me know your positive inputs so that I can run my code and proceed forward.
  Thanks in advance</p>