1. How to capture data from images in QTP and produce them
in Excel sheet



1. How to capture data from images in QTP and produce them in Excel sheet..

Answer / pravati

x=Browser("").page().image().Getroproperty("alt")
set excel=createobject("excel.application")
excel.application.visible=true
excel.workbooks.add
excel.activeworkbook.saveas ("path.xlsx")
excel.workbooks.open("path".xlsx)
set mysheet=excel.activeworkbook.worksheets("shtid")
mysheet.cells(1,1).value=x
excel.activeworkbook.save
excel.activeworkbook.close
excel.application.Quit
set mysheet=nothing
set excel=nothing

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More QTP Interview Questions

what are the parameters you are considering for object identification?

1 Answers  


How do you do batch testing in QTP, if so explain?

2 Answers  


How many types of Check Point in QTP

2 Answers   R Systems,


Does we use Classes and methods in realtime..?How wud we access methods in a class..?Thanq Guys..!

3 Answers  


How to connect to oracle(sqlserver) database to QTP

3 Answers   CTS,






Hi Friends, while playing the recorded test i am getting this error "Cannot identify the object "q" (of class WebEdit). Verify that this object's properties match an object currently displayed in your application." error is coming in this line of code "Line (2): "Browser("Google").Page("Google").WebEdit("q").Set "airtel broadband"". " .... please tell me how to overcome this problem. need help asap... Thanx in advance

3 Answers  


Any one please tell me how to create framework in QTP (in detail). Is there any website for reference?

1 Answers  


How to test the login page in different ways in automation testing and i need code?

0 Answers   Cognizant,


In an interview, what r the general questions asked in QTP? pls give me anwser to this question?

0 Answers  


Can we continue functionality testing without framework?

4 Answers  


In QTP , Test Director combination . what is the role of Test Director? How QTP Launching QTP in T.D ? If it is Winrunner possible. but QTP How it is possible?

1 Answers   IBM, TCS,


Explain more about the Test Fusion Report of QTP?

0 Answers  


Categories