How to read data from EXCEL file using Jasmine (Protractor framework)

[Nakul Arora]

We are new to Protractor and Jasmine.  We are trying to automate E2E testing of Angular application using Protractor and Jasmine. 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
        // }

     });

});

[Lucian Enache]

Why would you even try to do something loke that? Your tests should be data agnostic, but at modt if you really want to provide data from the outside, use either a web service or some static files that deliver JSON format data.

Sent from my iPhone

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

[Nakul Arora]

Actually i wanna try to make it data driven framework, so if you have any idea to get data from excel sheet using java script then please share it.

[Adrian Lynch]

You're running this in node?

Grab yourself a node package and go from there:

https://www.npmjs.org/search?q=excel

Adrian

--

[Nakul Arora]

Thanks Adrian, Its really very use-full. but i am not able to use these files because I don't know how to use these file.

could you please guide me?

On Tuesday, November 4, 2014 2:13:06 PM UTC+5:30, Nakul Arora wrote:

[David Souther]

An overview of NodeJS is likely outside the scope of this mailing list. Message me directly and I can give you some pointers - davidsouther...@gmail.com

[Manoj]

Use XLSX to read and write data. working.
https://www.npmjs.org/package/xlsx

[Arshdeep Brar]

Hey Nakul, did you get something to work? As am also very new and want to know if it is possible as we do in Selenium and QTP.

[Peter Hendrick]

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);

        });

    });

});

[Swati Khandelwal]

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!

[Balaji Singh .Y]

[Manaswini choudhary]

Hi peter,

    could you pelase tell me where we need to place the json file?and also what are all the configuration changes we need to make for this data driven frame work.????

[Shivakumar H N]

Getting the Uncaught ReferenceError: require is not defined - whether there a way to resolve the require not defined in jasmine?

On Saturday, 22 August 2015 06:12:26 UTC+5:30, Peter Hendrick wrote:

[Balaji Singh .Y]

Hi All,

Even i was very much frustuated with datadriven framework with protractor and jasmine. Initially i was using Json file as object repository and for data also i was using the json file only.

After lot of search on Internet and other forums i just got tired nothing worked out their is no much info on datadriven with excel.

That`s when i started designing my framework on datadriven with excel and succesfully impleted it.

But the only issue is i cant make it run my testcase with different set of data.

even though with lot of try with different possiblites it didn`t work out but it works with one to one mapping that is each test case with datarow in excel.

so if u need my apporach please let me know and contact my on this email id : bal...@gmail.com

With Regards,

Balaji Singh

Mobile No : +91 8884479958

--
You received this message because you are subscribed to a topic in the Google Groups "Angular and AngularJS discussion" group.

To unsubscribe from this topic, visit https://groups.google.com/d/topic/angular/szvTofhwp1M/unsubscribe.
To unsubscribe from this group and all its topics, send an email to angular+unsubscribe@googlegroups.com.

To post to this group, send email to ang...@googlegroups.com.

Visit this group at https://groups.google.com/group/angular.

For more options, visit https://groups.google.com/d/optout.

--

BALAJI SINGH .Y

[jyotsn...@gmail.com]

Hi Balaji,

                Can you help me out with this question.How do you test the data that is added today by data driven using protractor?Can you reply me as soon as possible.

To unsubscribe from this group and all its topics, send an email to angular+u...@googlegroups.com.

To post to this group, send email to ang...@googlegroups.com.
Visit this group at https://groups.google.com/group/angular.
For more options, visit https://groups.google.com/d/optout.

--

BALAJI SINGH .Y

[Ranjith Samalla]

HI

I'm also facing issue how to work with excel sheet for protractor

On Tuesday, November 4, 2014 at 2:13:06 PM UTC+5:30, Nakul Arora wrote:

[Tito]

why are you using excel at all? why not make it data driven?

[Ranjith Samalla]

Hi Tito,

for now I shown demo to management through Json files just i'm passing data to test script but now Managment asking instead of Json can you try with excel sheet so i.e reason I'm posting Question here

here I'm new to Protractor even I dont know how to use Data driven testing  plz guide me which once is better and how can I use for that i can explain to management 

Thanks & Regards,

Ranjith Samalla

9440247045

--
You received this message because you are subscribed to the Google Groups "Angular and AngularJS discussion" group.
To unsubscribe from this group and stop receiving emails from it, send an email to angular+unsubscribe@googlegroups.com.

[Tito]

well it depends
1. what kind of date is it
2. how much data is it
3. who is populating this data inyo excel
4. is it being populated manually or is it generated automatically from yet another data spirce

[Ranjith Samalla]

No

for now i'm only one person doing testing and i only need to enter data manually etc..

Thanks & Regards,

Ranjith Samalla

9440247045

[Tito]

well you could try databases such as
mysql
postgres
sql server

and have your test use that instead of excel

[Ranjith Samalla]

For Test Data ex: +ve and -ve how we can you do using mysql etc..?

Thanks & Regards,

Ranjith Samalla

9440247045

[Tito]

it does not matter what type of test you are doing. what was included in the excel spreadsheet.

can you show us some of the data you were leveraging in excel to do your test

On Thursday, April 19, 2018 at 10:37:40 PM UTC-7, Ranjith Samalla wrote:

For Test Data ex: +ve and -ve how we can you do using mysql etc..?

Thanks & Regards,

Ranjith Samalla

9440247045

On Thu, Apr 19, 2018 at 6:13 PM, Tito <yos...@gmail.com> wrote:

well you could try databases such as
mysql
postgres
sql server

and have your test use that instead of excel

--
You received this message because you are subscribed to the Google Groups "Angular and AngularJS discussion" group.

To unsubscribe from this group and stop receiving emails from it, send an email to angular+u...@googlegroups.com.

[Ranjith Samalla]

hi tito,

ex: UserNmae field: accepting 1 to 20 alphanumaric data only

for this +ve and - ve testing like this i want to do

Thanks & Regards,

Ranjith Samalla

9440247045

To unsubscribe from this group and stop receiving emails from it, send an email to angular+unsubscribe@googlegroups.com.

[Tito]

and then what happens? how is the data processed. the more info you provide the quicker we might provide you a data driven solution.
how does the test process this data

[spruh...@gmail.com]

Hi Balaji,

I also want to know abt how to read the data (test data) by using XLXS report,Kindly help me for this.

Thanks 

Spruha

spruh...@gmail.com

To unsubscribe from this group and all its topics, send an email to angular+u...@googlegroups.com.

To post to this group, send email to ang...@googlegroups.com.
Visit this group at https://groups.google.com/group/angular.
For more options, visit https://groups.google.com/d/optout.

--

BALAJI SINGH .Y

[nikhil rao]