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": "j...@j.com"
},
{
"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 angular+unsubscr...@googlegroups.com.
To post to this group, send email to angular@googlegroups.com.
Visit this group at http://groups.google.com/group/angular.
For more options, visit https://groups.google.com/d/optout.
