cancel
Showing results for 
Search instead for 
Did you mean: 

Reading from excel based on a condition

vi
Occasional Contributor

Reading from excel based on a condition

Hi,

  i have scenario like i have an external excel file which contains TestcaseId,Inputdata1,Inputdata2.

 

i want to read the data from excel where testcase matches and get the inputdata corresponding to that testcases and pass thosse input to steps.

 

I have been trying to read from excel using different helper jexcel and other ways and nothing works.

 

Please can some one share the code to read from an excel file

3 REPLIES 3

Re: Reading from excel based on a condition

There is no code necessary to bring data into your tests from an Excel spreadsheet.

 

You'll need to add a DataSource test step. For more information, please see this document.

Amber
vi
Occasional Contributor

Re: Reading from excel based on a condition

Hi,

  i was trying this but it doesn't solve the problem.

i will store all my testcasename and input data in an external excel file.

whenever i execute a test case i will read the excel file and then look for matching testcase name and get the test data specific to that testcase.

 

i gone through that document, but it doesn't server the purpose.

how to i filter or match for the specific test casename in the datasource.

If you could provide me the detailed steps..that would be great help

vi
Occasional Contributor

Re: Reading from excel based on a condition

i am aware of getting data from the datasoruce. but do you know how to filter the rows from the datasource after getting the all data from the table.

New Here?
Join us and watch the welcome video:
Watch the New Interview
7Mistakes
Join the exciting event
SeptemberHubBub
Top Kudoed Authors
Join the September Hub-bub to show off, learn and win