Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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



Once we get the Test Result from QTP.,I Have to convert into Excel file format..Is it possible..Ca..

Answer / narayan

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

Once we get the Test Result from QTP.,I Have to convert into Excel file format..Is it possible..Ca..

Answer / ravikiran

i want to copy results in qtp to excel or word how is
possible pls tell me through qtp only?

Is This Answer Correct ?    3 Yes 1 No

Once we get the Test Result from QTP.,I Have to convert into Excel file format..Is it possible..Ca..

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

Once we get the Test Result from QTP.,I Have to convert into Excel file format..Is it possible..Ca..

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

Once we get the Test Result from QTP.,I Have to convert into Excel file format..Is it possible..Ca..

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

Once we get the Test Result from QTP.,I Have to convert into Excel file format..Is it possible..Ca..

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

Post New Answer

More QTP Interview Questions

How to Synchronize the Browser at Field level? For example if you put Browser.sync(), its waiting upto for that Browser sync only. It should wait total Browser get upload with fields.

3 Answers   IBM, TCS,


if there is two login button in your page, how you know that this login button is correct for login .

2 Answers  


With what extension you can save the list of tests in a file to run in test batch runner?

0 Answers  


1.how can we report the QTP test result in a different excel sheet 2.

3 Answers   Aurigo,


how to write script in qtp(vbscript)..i mean with out application deployed..and how to call script1 into script2?

2 Answers  


Lets say,flipkart website...in search button we have entered category[i.e watches] it displays some items...question is how to test price displayed each product is correct or not through qtp

1 Answers   Cap Gemini,


whenever U using QTP,Test Director, Why we using separate Bug tracking tool?

1 Answers  


We have a dynamic webtable where rows keep on adding.I have to click on particular row where the status changes to Update or Save.How do you click on Status(either it can be Update or save)

2 Answers   IBM, Infosys,


Where u will use output checkpoint in QTP?

3 Answers   HCL,


If an application name is changes frequently i.e while recording it has name "Window1" and then while running its "Windows2" in this case how does QTP handles?

1 Answers   Crea,


what is the use of VIRTUAL OBJECTS? explain ?

4 Answers  


w is output value

3 Answers   MBT,


Categories