If the data is stored in Excel sheet(2nd and 3rd), how to access it for D

Advertise your Business Here

Refer this Site

Login | Sign Up


	Ask Questions on ANYTHING, that arise in your Daily Life at FORUM9.COM

Categories >> Software >> Testing >> Automation Testing >> WinRunner

WinRunner Interview Questions

Load Runner Interview Questions

QTP Interview Questions

Test Director Interview Questions

Rational TestSuite Interview Questions

Silk Test Interview Questions

Automation Testing AllOther Interview Questions

Question

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.

Question Submitted By :: Murali K

I also faced this Question!!

Rank

Answer Posted By

Re: 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.

Answer
# 1

Dim excelObj,counter
counter=1
Set excelObj=createobject("Excel.application") 'Excel Object
Set wbObj=excelObj.workbooks.open("c:\demo.xls") 'work bood 
object
Set wbs=excelObj.activeworkbook.worksheets("sheet2") 'work 
sheet object
while  not  isempty(excelObj.cells(counter,1)) 
	x=excelObj.cells(counter,1).value
	msgbox(x)
	counter=counter+1
wend

Is This Answer Correct ?

0 Yes

0 No

Uday Kumar. A

Question	Asked @	Answers
Other WinRunner Interview Questions


which testcases do u automate?		1
how to perform regression testing using winrunner?		1
can we write exception handlers (object,tsl,pop-up) programatically then how should we insert this in the script?		2
I am new to testing. Can anyone send a sample test script in which variables are used to automate the flight login page.		1
what is TSL in winrunner		2
what is the purpose of '*', '&','.' symbols in Regular Expressions (winrunner)?		1
hye.when we do recording,objects r indentified by GUI map editor.and respective script is generated.But my problem is that in GUI map editor objects r not stored-not their description.I tried 'LEARN' option in GUI map,even it is not working.So that i can't run my script.Tell me solution Thank you.		1
How does winrunner Recognize Objects in an application?	BirlaSoft	1
What is Add Watch?	Accenture	5
what is the automation framework?		1
How to use winrunner?		3
how we will create the functions and calls that functions in the main test in winrunner		1
How to write a content in to the file..which function did u use for that..?	Accenture	1
ca n u give the example for low severity & low priority in ur Internet Banking project	Agile-Software	1
hi everyone today is the first time i saw this website,and hi iam siraj,iam very impressed by seeing evryones response towards questions,iam a newcomer and i have got tryining in testing can anyone please send me some projects relaited to testing.i know it is very confidential but still if u send it will a great help. my mail id mateen_012005@yahoo.com	Satyam	3
Can we use the user defined functions (which inclues script with GUI functions) in Compile module? Example: public function MyGuiFun() { set_window(?Browser main window?); button_press(?OK?); } If yes. pls give some example, how to handle...!		1
We added data driven test in to our test script, how to remove the data driven wizard from the script?	Wipro	1
how do you rate your self in winrunner	Infosys	2
How many Record Methods are there in Winrunner?	Accenture	6
Where to use the public or private functions in your script?		2

For more WinRunner Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2007 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com