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

how to run the script If QTP tool not identify object in web page

2 Answers  


QTP is used better in which type of application Web based application or desktop application

3 Answers  


how can i prepare for QTP(8.2) to face interview ? give over view details?

52 Answers  


Hi im new in Testing..can any one plz re-write this code SystemUtil.Run "C:\Program Files\Mozilla Firefox\firefox.exe","","C:\Program Files\Mozilla Firefox","open" ----using for loop(for i=0;i<=10;i++ )

2 Answers  


what properties do use to identify a browser and page while using descriptive programming?

3 Answers   TCS,


Analyzing the Checkpoint results ?

1 Answers   Crea,


Hi Guys, My Application in Microsoft Dynamic Navision, is it compitibale with QTP? if yes then let me know...

0 Answers  


Hi friends I need to know about jubula automation tool. Is anybody know in bangalore where jubula tanning class is going on do let me know. Its urgent for me to learn that tool please help.

0 Answers  


How can you delete the results file (XML)

2 Answers  


How to import a test case present in ".xls" file to TD under a Test set?

1 Answers  


Syntax for how to call one script from another? and Syntax to call one "Action" in another?

2 Answers  


how to test background color and dynamic images during runtime

4 Answers   CTS,


Categories