Data driven testing using csv\excel file in protractor

You need to use excel to json convertor. So make sure you write code for json only as below. So whether it is excel or json or input data will always be json. Reach back to me for any query.

test.json file [ { "username": "user", "passwordField": "pass12345" } ]

book1.xlsx file

Suppose your json is stored under D:/node_modules/test.json and excel is at D:/node_modules/book1.xlsx

import {protractor,element,browser,$,$$, By,by,wrapDriver,ExpectedConditions} from 'protractor';

var convertExcel = require('excel-as-json').processFile;
convertExcel('D:/node_modules/book1.xlsx', 'D:/node_modules/book1.json');

 describe ('Login Page Data Driven' , function() {
 browser.ignoreSynchronization = true;  

    beforeEach(function(){
     browser.ignoreSynchronization=true;
     browser.get('url');
     browser.driver.manage().window().maximize();
     });
       it('To verify Login, using Data Driven Technique from Json file', function(){
        var testData = require('D:/node_modules/test.json'); 
        var a = element(by.id("username"));
        var b = element(by.id("password"));
        a.sendKeys(testData[1].username);
        b.sendKeys(testData[1].passwordField); 
        browser.sleep(1000);
        }); 

       it('To verify Login, using Data Driven Technique from Excel file', function(){
       var testData1 = require('D:/node_modules/book1.json');
       var a = element(by.id("username"));
       var b = element(by.id("password"));
       a.sendKeys(testData1[0].username);
       b.sendKeys(testData1[0].passwordField); 
       browser.sleep(1000);
       });
 });