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

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

More WinRunner Interview Questions

What is the use of virtual object wizard and how it is used?

0 Answers  


If the data is stored in Excel sheet(2nd and 3rd), how to access it for Data Driven test; Ex: table = "c:\demo.xls" How to access 2nd or 3rd sheet data id demo.xls flie.

1 Answers   MBT,


In my application I was supposed to test two columns.The first column1 belongs to one module and the other column2 belongs to other module.The content in both the columns is same.I supposed to check whether the data present in the column1 is same as the one in column2. Each column contains number of rows.So checking each row manually is diificult.Is there any option available in WinRunner or QTP to check the column data.These two columns are available in Data Base Tables. One way is that I can just number of rows in each column so that I can get rows count of both the columns,but apart from that I was supposed to check whether the data is also same in both the tables. Can anybody suggest me how I can go about this.

1 Answers  


Explain in detail the parameterization steps in DDT?

1 Answers  


which testcases do u automate?

1 Answers  






What is the purpose of gui map configuration?

0 Answers  


We added data driven test in to our test script, how to remove the data driven wizard from the script?

1 Answers   Wipro,


how scripting language & programming language are different?

1 Answers   EDS,


How to insert the data in to the data table from the data base records?

2 Answers   CTS, Landscape Technologies,


How do I use function File_Printf() to output a Space and a New Line? Thx.

1 Answers  


how do you rate your self in winrunner

2 Answers   Infosys,


plz give me code or steps for pop up exception. or can u tell me how to pause test run for defining handler function?

0 Answers  


Categories