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

Suggest and Define a solution for an application whose objects are not recognized by UFT?

0 Answers  


hi study this carefully,WHO ARE TEACHING WITH THE HELP OF FLIGHT RESERVATION WINDOW...THOSE FACULTIES ARE VERY BAD...BUT WHO ARE TELLING WITH PROJECT ORIENTED MEANS(NOT FR WINDOW) DIRECTLY OPEN THE BANK WEB PAGES OR ANY OTHER REAL TIME WEB PAGES... BASED ON THAT WEB PAGES, FACULTY TEACH, IN THIS WEB PAGE WHEN UR USING QTP , WHEN UR USING MANUAL... WHERE UR WRITING THE SCRIPTS FOR THIS WEB PAGE.. .LIKE THIS ................THIS IS THE TEACHING FORMAT FOR QTP... 1ST U FIND OUT WHO IS FOLLOWING THIS TYPE OF FORMAT THOSE PEOPLES ARE .BEST FACULTIES AND JOIN THAT INST. THIS IS 100 % TRUEEEEEEEEEEEEE REMEMBER IT........ NOW ONWADS U HATE FLIGHT RESERVATION WINDOW ONLY REAL TIME WEB PAGES........... THAN KU

1 Answers  


any one could you explain the following code with example: intFieldItemsCnt =CInt(GetProperty(Browser ("Browsername").Page("Pagename").Weblist ("weblistname"),"items count")) msgbox intFieldItemsCnt

1 Answers  


What do you mean by checkpoints in qtp?

0 Answers  


what is meant by automation tool?

1 Answers  






GET WHETHER THE GIVE NUMBER VALID OR NOT IN BETWEEN THE GIVEN RANGE?IN VB SCRIPT(QTP)

2 Answers   CSC,


what is a test strategy & what is the difference between test strategy & test plan?

5 Answers  


Why we use QTP ,We can use other tools like WR OrSilktest What r the options in Qtp that WR and Swilktest Does not have.

0 Answers   Hewitt,


When ‘option explicit’ keyword is used in qtp?

0 Answers  


how to write testcases for web based insurance,from the script by using qtp.

1 Answers  


what is difference normal,analog,low level recording in qtp? what is lowlevel recording?

2 Answers   JPMorgan Chase,


In qtp is it possible to check broken links of a page?

0 Answers  


Categories