How can i see test results in excel sheet ? test data not present in data table.
- 5 Answers
- 7502 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pavan
First u have to create the log file in any drive.
then write the script like
datatable.Export "d:/logfile.xls"
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / ira
datatable.Export "C:\qtp\runtime.xls"
or
Automation => Results => run time data table
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sandeepguttikonda
Test results can be seen in an excel sheet by using 2
techniques..
1) Creating an Excel object (Excel.application)
2) Datatable methods (Datatable.exort "path of the file)
(Datatable.exportsheet "path of the file", "source
sheet", "Destination sheet"
Regards,
Sandeep Guttikonda
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / kumar
Not getting what you said,Please be clear with your
question, looks like there are two different questions ?
Please explain much detail
| Is This Answer Correct ? | 0 Yes | 1 No |
How to use userdifined environment variables.Once we created in Environment tab which is at File--> Settings-- >Environment-->Userdifined
Explain in brief about the QTP Automation Object Model.
I have written a code to fetch values fro access db and place in the fields. Iam using GetROProperty to fetch runtime values. Now i want to add runtime values to the access db in field v3. please help me. Its not writting in the db. Option explicit Dim con,rs,db,c Set con=createobject("adodb.connection") Set rs=createobject("adodb.recordset") con.Open "Driver={Microsoft Access Driver (*.mdb)};dbq=D:\Sales.mdb" rs.open "select * from tax",con Do while not rs.eof Browser("Sales Tax Calculator").Page("Sales Tax Calculator").WebEdit("incost").Set rs.fields("v1") Browser("Sales Tax Calculator").Page("Sales Tax Calculator").WebEdit("intax").Set rs.fields("v2") c=Browser("Sales Tax Calculator").Page("Sales Tax Calculator").WebEdit("outtax").GetROProperty("value") rs.MoveNext print c Loop Do while not rs.EOF rs.EditMode rs.Fields("v3").Value="3" rs.Update rs.MoveNext Loop Set rs=nothing Set con=nothing
How to add multiple values in rows, under a single column of a run time datatable?
please give me the code for doing retesting of gmail login page using functions so the function has to give the value
What are the difference between QTP and Winrunner
Can an action have 2 shared object repositories associated with them? In that case, if two of them contain the same object, which one will be considered?
How to work with multiple browsers when opened in the window, write the script for it
What is Terminal Emulators”? Why we used in QTP.? How he works on QTP.
What is Port testing. Whhen will you perform?
Hi friends, In a particular test how many maximum call to new actions we can call?It reusable or normal actions what ever it is .
What is QTP scenario.
WinRunner 
