Once we get the Test Result from QTP.,I Have to convert
into Excel file format..Is it possible..Can any gudie me
regarding this...
For Example :
Total Test Case is : XXXXX
Test Case passed : XXX
Test Case Failed : XXX
--------
Total XXXXXX
---------
Answers were Sorted based on User's Feedback
u can create a column name call result status in the data
table.if test iteration is passed then put "PASS" else
Put "FAIL" in the datatable. onces execution complete u can
check the pass & failed one then import it in to excell or
notepad.
For getting total test case numner,use datatable.rowcount.
Still if you any questions tell me know
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / kishore
first creat an object to excel sheet
Set fso1 = CreateObject("Excel.Application")
Set objExce2 = fso1
for m=1 to n 'here m is row value
objExcel2.cells(m,1).Value=" Test Case Passed" 'here 1 ia
coloumn value
else
objExcel2.cells(m,1).Value=" Test Case failed"
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / ch
# 1 u can create a column name call result status in the
data
table.if test iteration is passed then put "PASS" else
Put "FAIL" in the datatable. onces execution complete u can
check the pass & failed one then import it in to excell or
notepad.
For getting total test case numner,use datatable.rowcount.
Still if you any questions tell me know
Narayan can u pls tell the process of adding the data to
data table.and how we will know weather iteration is pass
or fail?
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / sirisha
If u want to convert the Test Result from QTP.
Follow the process
1.Open the report
that is test result template
right click on that report
u have an option says that export to excel
so that al lthe data releasted to the report is posted into
excel sheet
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / hari
If u use this script the results are stored in u r excel
sheet in u r result column.
If browser("Yahoo").page("Yahoopage").webbutton("Login")
Exist Then
datatable.value("result",3)="Pass"
browser("Yahoo").page("Yahoopage").webbutton("Login").click
elese
datatable.value("result",3)="Fail"
End If
| Is This Answer Correct ? | 0 Yes | 5 No |
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?
Can u Reduce the size of Object repository? What are the problems u have faced in Qtp tool?
Hi could some one explan what is the use of the function Defination generator, And how to use the function defination generator.. Explan with the example..
What is the use of Accessibility check point?
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.
What is the difference between Client/Server application and Web application ?
hi all, I want to know about the QTP scripts, i have read more books but all areis to be a theory so how can i improve my script skills. if anybody knows about qtp scripts plz guide me and i need a sample scripts.my mail id is karthis4u@gmail.com, 9986667831 If you all have any data send it to akadi111@gmail.com
What are Child Objects?
can any one make me confirm about a real time employee with better experience in QTP who is providing QTP course individually in Bangalore???
Suppose there are 100 links in a web page and the number of links will be changing dynamically from time to time. I need code such that every time i had to click on the last link of the web page.
hi everyone today is the first time i saw this website,and hi iam siraj,iam very impressed by seeing evryones response towards questions,iam a newcomer and i have got tryining in testing can anyone please send me some projects relaited to testing.i know it is very confidential but still if u send it will a great help. my mail id venku_krs@yahoo.co.in
i have 100 manual test cases, how to automate from no 1. ols detail steps