ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Testing  >>  Automation Testing  >>  QTP
 
 


 

 
 WinRunner interview questions  WinRunner Interview Questions
 Load Runner interview questions  Load Runner Interview Questions
 QTP interview questions  QTP Interview Questions
 Test Director interview questions  Test Director Interview Questions
 Rational TestSuite interview questions  Rational TestSuite Interview Questions
 Silk Test interview questions  Silk Test Interview Questions
 Automation Testing AllOther interview questions  Automation Testing AllOther Interview Questions
Question
i ve an excel in a QC folder. Thru my QTP script i want to 
open that excel in runtime. I am running this script from 
QC itself
 Question Submitted By :: Manoj M
I also faced this Question!!     Rank Answer Posted By  
 
  Re: i ve an excel in a QC folder. Thru my QTP script i want to open that excel in runtime. I am running this script from QC itself
Answer
# 1
Hi 
try this one, I am not giving you the whole syntax because 
if you start analyze you will get more information on this 
right? thats why...

SystemUtil.Run "excel",""

if you have any doubts let me know
 
Is This Answer Correct ?    1 Yes 2 No
Giridhar Reddy
 
  Re: i ve an excel in a QC folder. Thru my QTP script i want to open that excel in runtime. I am running this script from QC itself
Answer
# 2
with that code we can open a new excel or even open an 
excel that is saved in our system
but i want to open an excel (which is saved in Mercury 
Quality Center ) during run time.

is there any piece of code to download the excel from 
Mercury Quality Center to local machine during runtime?
 
Is This Answer Correct ?    0 Yes 1 No
Manoj
 
 
 
  Re: i ve an excel in a QC folder. Thru my QTP script i want to open that excel in runtime. I am running this script from QC itself
Answer
# 3
got to options and select folders tab and give path of the 
folder where the excelsheet is present in QC 
and then try out this:
x=PathFinder.Locate("Results.xls")
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
Set objWorkbook2 = objExcel.Workbooks.Open(x)
 
Is This Answer Correct ?    0 Yes 0 No
Karishma
 
  Re: i ve an excel in a QC folder. Thru my QTP script i want to open that excel in runtime. I am running this script from QC itself
Answer
# 4
hi manoj, 

Try this. Even I am doing the same thing for my application.
First connect your QTP to QC. Then open the code which you 
have saved in QC in QTP. Click on Test->settings(in QTP9.2 
it will be File->settings) -> click on resource tab . In 
that you can see a frame called DataTable. In that select 
the option "Other Location" and click on the browse icon 
beside that option. It will display you all the excel 
sheets in QC. Select your Excel sheet. Now autopmatically 
the excel sheet will be embedded to your code in 
runtime.You need not include any code for this excel sheet 
in your main code. (But do take care of the sheet names in 
the excel sheet. It should be correctly mentioned in your 
code.)
 
Is This Answer Correct ?    2 Yes 0 No
Saranya
 

 
 
 
Other QTP Interview Questions
 
  Question Asked @ Answers
 
When I parameterize a script then for each iteration script is executed from begining to end. If I want to execute some middle steps multiple times using Parameterization (avoiding begining and end steps), what is the solution of this (e.g. total steps are 1 2 3 4 5 and i want 2 3 4 only(not 1 nd 5)  1
what are recovery management techiniques? BirlaSoft2
what are recovery management techiniques?  1
How should I click on the right click menu objects When I trying to add the object properties to the OR.It is showing only Window(Window).Not all the objects of the window. Also while recording I found No script. How to solve this>.  1
Could some one help me the difference between GetTOProperty and SetTOProperty and when we will use these properties. and what is meant by SetToProperties.. Clinical-Soft5
In QTP if u got a defect , how to report to developer using Test director or Quality center . Wipro4
How we can add actions in the test using QTP? BirlaSoft4
To count the no of links present in the yahoo home page i have written the script like this Set fileSysObject=createobject("Scripting.FileSystemObject") Set linksFileName=fileSysObject.opentextfile ("D:\samplelinkfile.txt",2,true) Set linkDescObj=description.Create linkDescObj("micclass").value="Link" Set noOfLinks=browser("yahoo").Page("Yahoo! India").ChildObjects(linkDescObj) For i=0 to noOfLinks.count-1 linkName=noOfLinks(i).getROProperty("name") linksFileName.writeline(linkName) Next linksFileName.close Set fileSysObject=nothing While running the script it showing error that object "yahoo"isnot found in the object repository. Is there any setting before running the script? if yes what is the steps for it.Im using QTP9.0  2
what is throw object ?  1
This is the script generated by qtp plz can anyone write the same script using descriptive programming plzzzz guys do answer. Browser("orkut - login").Page("orkut - login").WebEdit ("Email").Set "rgovard" Browser("orkut - login").Page("orkut - login").WebEdit ("Passwd").SetSecure "47525d8be4926ea2f6e96b9a3f7472b6ae38" Browser("orkut - login").Page("orkut - login").WebButton ("Sign in").Click Browser("orkut - login").Page("orkut - home").Link ("Logout").Click Browser("orkut - login").Page("orkut - login").Sync Browser("orkut - login").Close  5
If you are using descriptive programming and you have two objects with the same name, so you are identiying them by name and index, how can you avoid errors if a third object with the same name is added at the begining of the page?  4
hi i have one issue while coding the dates . i want to add the date curret to 4 days . can any one helme plz about this regards balaji  2
What is the function of Filter in QC . give with a real time example. TCS1
VM1 = "Invalid username or password. Please try again. " VM2 = "Email id is required.Password is required. " VM3 = "Email id is an invalid e-mail address.Password is required. " VM4 = "Password is required. " VM5 = "Email id is required. " VM6 = "Email id is an invalid e-mail address. " 'Rowcount of the Local sheet Rowcount = DataTable.GetSheet("Invalid login transactions").GetRowCount 'Valid emailid and Password Emailid = "test@iteamic.com" Password = "Password0" 'For i = 1 to Rowcount 'Parameterised Email_id Browser("Browser").Page ("Page").WebEdit("emailAddress").Set DataTable("Email_id", dtLocalSheet) EID = Browser("Browser").Page ("Page").WebEdit("emailAddress").GetRoProperty("value") 'Parameterised Password Browser("Browser").Page ("Page").WebEdit("password").Set DataTable("Password", dtLocalSheet) PWD = Browser("Browser").Page ("Page").WebEdit("password").GetROProperty("Value") If EID = Emailid And PWD = Password Then Reporter.ReportEvent micPass, "EID & PWD check", "Email id and Password is correct, One iteration of Invalid login attempts is not being executed" Else Browser("Browser").Page("Page").WebButton ("Sign-In").Click 'Output value exported to the local sheet Browser("Browser").Page ("Page_2").Output CheckPoint("Home page_Sign in") 'Storing the output value in a variable(OUTPUT OUTPUT = Datatable.GetSheet ("Invalid login transactions").Getparameter ("Validation_message_signin").value 'comparing the Variable Output and the Validation message for a given input If OUTPUT = VM1 Then Reporter.ReportEvent micPass, "VM1", "Invalid username or password. Please try again. " else if OUTPUT = VM2 Then Reporter.ReportEvent micPass, "VM2", "Email id is required.Password is required. " else if OUTPUT = VM3 Then Reporter.ReportEvent micPass, "VM3", "Email id is an invalid e-mail address.Password is required. " else if OUTPUT = VM4 Then Reporter.ReportEvent micPass, "VM4", "Password is required. " else if OUTPUT = VM5 Then Reporter.ReportEvent micPass, "VM5", "Email id is required. " else if OUTPUT = VM6 Then Reporter.ReportEvent micPass, "VM6", "Email id is an invalid e-mail address. " else Reporter.ReportEvent micFail, "EID & PWD check_FAIL", "Validation message checkpoint failed. The captured v msg is not required" End if End if I am getting syntax error saying "Expected 'End If'" at the last line, Why is this? Kindly explain...  1
WHY U CHOOSE TESTING FIELD? TCS5
how i can delete the excel process for the task manager using QTP  2
difference Between LowLevel and Normal Recording Modes?  4
What is the difference between Image Checkpoint and Bitmap Checkpoint?  4
What are the types of Object Repositories in QTP? Ordain-Solutions1
In one of the scripts the pwd in the DT was encripted. Can any one tell me how to I decript or undo the same? BirlaSoft2
 
For more QTP Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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