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

Does QTP support Java Script also. Which is one is preferrable for QTP, VB script or Java script

18 Answers   IBM,


what is the exact Diff. Between Test and Component in QTP?

1 Answers  


How to execute the WR Script through QTP? I have WinRunner script with initialization script, common scripts, GUI AND functions. I connected WR through QTP with "call to WinRunner" option but I am getting problem after connecting to WinRunner i.e. showing "Do you want to quit now" with 'yes' and 'No' message box

0 Answers   L&T,


Take a situation when you are working with QTP, suddenly system has crashed.so you again start the system. My questyion is how can QTP directly opened when the system desktop appears.

1 Answers  


what r the drawbacks and limitations of QTP?

2 Answers   NIIT,






I want to open a GOOGLE page without recording a test in QTP.Can any one answer me?

4 Answers   IBM,


WE ARE PLANING TO DESIGN AUTOMATION FRAME WORK. HOW TO CALL CONFIGURATION SCRIPT FILE(.VBS) FROM DRIVE SCRIPT FILE(.VBS)

1 Answers  


WHAT IS THE USE OF "FUNCTION GENERATOR" IN QTP?

2 Answers  


How should i find out whether the cursor is moving horizantally. when tabbing continuously

2 Answers   Livetek,


How can we use regular expressions for a table in web page, each cell in table having unique identification, Now I want to count number of rows in table and enter data in all cells of the table?

1 Answers   CTS,


I have 2 Environment variable which holds int. I called into my test and addedup. but output is concatenating the values instead of Sum. Ex. Envi("a")= 10, Envi("b") = 20, c= Envi("a")+ Envi("b"). msgbox c ( Ans.1020). How to overcome this pblm? I used the add fn also..

3 Answers   BirlaSoft,


Can you write a script to check if the folder exists or not?

0 Answers  


Categories