Hi Peter,

Your code was really very helpful. But I have a query related to it. Please 
explain the usage of parameter 'data'. I mean from where the value of data 
would come. The above code works perfectly on my system but i am unable to 
analyze the 'data' parameter. 
Please help!

On Saturday, August 22, 2015 at 6:12:26 AM UTC+5:30, Peter Hendrick wrote:
>
> Hi, I'm not sure if you were able to figure this out or not. however, I 
> was able to acomplish just this. If you start with an xls file, you will 
> have to convert it to .json format. There are websites and applications 
> that will do this for you. Just google .xls to .json. Then you will need to 
> place the json in your test code. 
>
> Here's what your json might look like.
>
> [
>     {
>         "someId": "signInButton",
>         "sendSomeKeys": "[email protected] <javascript:>"
>     },
>     {
>         "someId": "passwordButton",
>         "sendSomeKeys": "password"
>     }
> ]
>
> And here's how to implement it in your test:
>
> 'use strict';
>
> var testData = require('./path/to/json.json');
>
> describe('your test', function() {
>     testData.forEach( function (data) {
>         it('should read from an external json', function(){
>             element(by.id(data.someId)).sendKeys(data.sendSomeKeys);
>         });
>     });
> });
>
>
>
> On Tuesday, November 4, 2014 at 1:43:06 AM UTC-7, Nakul Arora wrote:
>>
>> We are new to *Protractor* 
>> <https://github.com/angular/protractor/blob/master/docs/tutorial.md> and 
>> *Jasmine 
>> <http://jasmine.github.io/1.3/introduction.html>.*  We are trying to 
>> automate E2E testing of Angular application using *Protractor* 
>> <https://github.com/angular/protractor/blob/master/docs/tutorial.md> and 
>> *Jasmine* <http://jasmine.github.io/1.3/introduction.html>. As part of 
>> the test data input we would like the script to read the data from an excel 
>> file (*.xls, *.xlsx). But I am unable to find any reference to this 
>> information. I really appreciate if anyone can give the exact approach to 
>> read data from excel as an input to the automation script.
>>
>> Cheers
>>
>> Please note : Only reason I am posting a standard snippet is bcoz we are 
>> actually trying to get the input as excel for this specific script (as our 
>> learning curve). Appreciate all the help. Thank you.
>>
>> Sample Code:
>>
>> describe('Test Calculator', function() {var firstNumber = 
>> element(by.model('first'));
>> var secondNumber = element(by.model('second'));
>> var goButton = element(by.id('gobutton'));
>> function ReadDataFromExcel() {
>>
>>     // Code to read first number & second number from Excel;
>>
>>   };
>>
>>   it('Testcase 1', function() {
>>
>>         browser.get('http://juliemr.github.io/protractor-demo/');
>>
>>         // ReadDataFromExcel()
>>         // for each record in EXCEL; perform below operation;
>>         // {
>>             firstNumber.sendKeys(a);
>>             secondNumber.sendKeys(b);
>>             goButton.click();
>>             // Always perform '+' operation
>>         // }
>>
>>      });
>> });
>>
>>

-- 
You received this message because you are subscribed to the Google Groups 
"AngularJS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/angular.
For more options, visit https://groups.google.com/d/optout.

Reply via email to