Data is there in two excel sheets .. how ur going to retrive the data in winrun

Data is there in two excel sheets .. how ur going to retrive
the data in winrunner thru script.. write down the script?

Question Posted / guest

3 Answers
5325 Views
AZTEC, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Data is there in two excel sheets .. how ur going to retrive the data in winrunner thru script.. wr..

Answer / suneel reddy

use data driven test script

ddt commands

Is This Answer Correct ?

1 Yes

0 No

Data is there in two excel sheets .. how ur going to retrive the data in winrunner thru script.. wr..

Answer / uday kumar. a

Hi,

As per the question, Excel sheets means In an Excel file we
have multiple sheets(Sheet1, sheet2 etc...)
Here i can access the sheet1 data, but WR does not provide
any functions, so that we can access sheet2.

There is no direct option to access sheet2 in Excel file

Is This Answer Correct ?

0 Yes

0 No

Data is there in two excel sheets .. how ur going to retrive the data in winrunner thru script.. wr..

Answer / deepak ethirajan

First link the data tables to an appropriate table name.
eg:-
Table1= "C:\\excel1.xls";
Table2= "C:\\excel2.xls";

use the ddt_open command to open the data tables.

ddt_open(Table1,.....
ddt_open(Table2,....

Now, you can access the data from either Table1 or Table2
by the table name.
eg:
V1= ddt_val(Table1,<parameter1>)
V2= ddt_val(Table2,<parameter2>)

Is This Answer Correct ?

0 Yes

1 No

Post New Answer