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
Answers were Sorted based on User's Feedback
Answer / amit kumar srivastava
I think after capturing the run time value by using command
like x=window("").something.....getroproperty("text") then
do like -
Datable.export("path where u want to see the data")
set datatable.value(x,1)
try this ,if you face any probelem then let me know.I have
another way for this also.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / madhavi
We can capture the proprty of the message box throug
getroproperty("innertext").Pass this to a variable.After
that use MID function to retrieve 'R'.After that we can
create an external excel object and pass the value to that
sheet.
Is This Answer Correct ? | 1 Yes | 1 No |
In how many ways we can add check points to an application using QTP.
How should i get name of the screen? Ex:There is a "submit" button.If i clicked on the submit button it opens a screen. I want that screen name.How can i get that screen name I dont have any property regarding that screen. If suppose we cliked on the screen , Then QTP captures the screen properties then i can get the screen name by using GETROPROPERTY But i want the screen name without clicking the screen. ("I am using the "settoproperty" for Second screen by using fist screen properties") Please tell me anyone
Hello, I am facing problem to check textpoint for mercury application . I have inserted checkpoint to check flight summary for place of departure and arrival with datatable and script look like "Browser("Find a Flight: Mercury").Page("Book a Flight: Mercury").Check CheckPoint("Book a Flight: Mercury_4")" but while I am executing this script at last my check point gets fail and display Text Checkpoint: captured "" between Summary and 4/31/2008FLIGHT , expected "Acapulco" Match case: ON Exact match: OFF Ignore spaces: ON I think value from data table is not fatched so please guide me what I have to do to overcome this problem.. Thanks
Hi, Hope you viewers are doing fine with good health. What are the steps and connection parameters to connect to Oracle db ? Can you connect with just the Oracle client or Oracle XE ? Cheers!!
Hi. GetRoProperty and OUTPUT Value Both are same purpose or not? plz explain in deatil with example?
Approach for Installation,comaptibility,system testing
how to create user defined functions in QTP? can any one expalin me with example.. Thanks in Advance for help
How good are you in writing VBscript code for your application? Can you completely write VBscrit for your project with out using recording mode in QTP?
Other than using import sheet statement for importing the data from excel sheet, is there any other method that can be used?
Hey friends i m facing a problem when i m running my script in qtp it waits for about 5-10 secs before starting execution why it is so can any one solve my problem .Previously it was running fine
what are the disadvantages of qtp? can linux support qtp9.2? how could get web address throu vbscript?
how to get childobject from .net application. i tried but its showing child object count zero. but window has child objects.the following script i written... pls help me how to get. set parent=SwfWindow("winodw name") CheckObjectDescription parent, SwfButton Public Function CheckObjectDescription(parent, oDesc) Set oDesc = Description.Create() oDesc("micClass:").Value ="Swfbutton" Set children = parent.ChildObjects(oDesc) cntObj=children.count msgbox(cntObj) End function