How to capture data from images in QTP and produce them in
Excel sheet ?
Answers were Sorted based on User's Feedback
Answer / kiran
by using the textarea check point ,we can retrive the data
from the images,and then use export that value to a
datasheet.
| Is This Answer Correct ? | 10 Yes | 6 No |
Answer / manas
hi, we can't take the help of text area check point to
capture data and display in excel sheet,
we have to take the help of text area OUTPUT VALUE to
capture the data from image and disaply the coressponding
data in excel sheet.
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / tvsramakrishnachowdary
act=object heirarchy.getvisibletext
exp="the text which actually u need to check"
if exp=act then
msgbox "pass"
else
msgbox "fail"
end if
'for posting values into excel file follow below code
--------------------------------------------------------
excelsheet_object.cells(rowno,colno).value=act
| Is This Answer Correct ? | 2 Yes | 1 No |
We can Capture the Data from images by using the
Text Output Value. i,e
Insert --> Output Value --> Text OutPut Value
On record mode add the Text Output Value to the script and
Run. The Image Text will export to DataTable.
Same we can export to excel by using the DataTable.Export
method.
| Is This Answer Correct ? | 1 Yes | 2 No |
How do you export an output to a excel sheet? Ex: I get my answer by using Msgbox"..." &R. How do I displayed the result of the Msgbox (such as R) to an excel sheet? Please let me know.Thanks
hi everybody this questions is only for qtp real time users. anyone please clearly explain the approach u r following for qtp testing in ur company or qtp framework u r following in ur company pelase give me clear explanation then u did great favour to inexeprienced qtp users
how to get the object property
how do we add a new sheet to data table in QTP?
WHAT IS THE USE OF "FUNCTION GENERATOR" IN QTP?
what is the difference between DATA TABLE and DATA SET?
Could i know how how to explain keyword driven framework in interview? If any body knows plz send the explanation.
What is the basic concept of qtp?
What is Active Screen in QTP?
How to count no of edit boxes on the page?
How Can I find the least value in a bunch of variables using qtp.. E.g.:- A = 210, B = 212, C = 60, D = 111 I don’t want to write bunch of lines for this…. Is there a way to get the result in one line…..
Tell me about userdefined functions ?