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

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

Question Posted / guest

3 Answers
16379 Views
Aurigo, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / puneeth

'Parameterization ... Data Table (Global Sheet) for Flight
Reservation

Invokeapplication "C:\Program Files\Mercury
Interactive\QuickTest
Professional\samples\flight\app\flight4a.exe"
'or
'SystemUtil.Run "C:\Program Files\Mercury
Interactive\QuickTest
Professional\samples\flight\app\flight4a.exe"

Dialog("Login").WinEdit("Agent Name:").Set
DataTable("Agent_Name", dtGlobalSheet)
Dialog("Login").WinEdit("Password:").Set
DataTable("Pword",dtGlobalSheet)
Dialog("Login").WinButton("OK").Click

If Window("Flight Reservation").Exist then
Window("Flight Reservation").WinMenu("Menu").Select "File;Exit"
DataTable.Value("Act_Res")="Pass"
Reporter.ReportEvent 0,"Login Details","Valid Values"
else
Dialog("Login").Activate
Dialog("Login").WinButton("Cancel").Click
DataTable.Value("Act_Res")="Fail"
Reporter.ReportEvent 1,"Login Details","Invalid Values"
End If

er=DataTable("Exp_Res",dtGlobalSheet)
ar=DataTable("Act_Res",dtGlobalSheet)
If Strcomp(er,ar)=0 Then
DataTable.Value("Remarks")="OK"
Else
DataTable.Value("Remarks")="Defect"
End If
DataTable.Export("D:\QTP9\LoginResults.xls")

Note: Create a data table in QTP and enter the following details
Agent_Name Pword Act_Res Exp_Res Remarks
puneeth mercury Pass
pooja mercury Pass
soumya mareiou Fail
mahesh miaoreu Fail
shivakumar mercury Pass

Is This Answer Correct ?

10 Yes

2 No

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

Answer / ravi

Prasad If u know the answer write else dont do any
thing.Dont copy the answers.

Is This Answer Correct ?

9 Yes

2 No

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

Answer / prasad

Is This Answer Correct ?

2 Yes

11 No

Post New Answer

More QTP Interview Questions

how u conduct GUI testing and PERFORMANCE testing on MS- WORD? and What r the GUI Test Cases and performance Test Cases?

3 Answers Accenture, Civil Service, ICICI, Jintek, Satyam, Singularity, Syntel, TCS, Wipro,

How to run scripts 1,29,3,5,7,2 scripts using test batch runner in QTP.... Ie...I wanted to run scripts not in an order 1,2,3,4,5...like that How it is possible using test batch runner... I dont want hardcoded script

0 Answers IBM,

For the below written code , i want to be stop the loop (ex:10 times), but it is focusing to first line of the code & generating error. vbwindow("vbname:=frmMain").Type micAltDwn + "6" + "2" + "D" +micAltUp 'wiil open the particular window in application vbwindow("vbname:=frmDeduction").vbbutton("vbname:=cmdNew").Click DataTable.ImportSheet"F:\QTP VBScript\Form 26-1.xls","Deduction",Global RowCount = DataTable.GetSheet("Global").GetRowCount i=RowCount For j =1 to i 'vbwindow("vbname:=frmDeduction").WinObject("nativeclass:=DataComboWndClass","abs_y:= 187").Type DataTable("Name", dtGlobalSheet) vbwindow("vbname:=frmDeduction").ActiveX("acx_name:=DataCombo","abs_y:= 187").Type DataTable("Name", dtGlobalSheet) vbwindow("vbname:=frmDeduction").ActiveX("acx_name:=DataCombo","abs_y:= 187").Type micF4 vbwindow("vbname:=frmDeduction").ActiveX("acx_name:=DataCombo","abs_y:= 187").Type micTab vbwindow("vbname:=frmDeduction").ActiveX("acx_name:=DataCombo","abs_y:= 216").Type micF4 vbwindow("vbname:=frmDeduction").ActiveX("acx_name:=DataCombo","abs_y:= 216").Type DataTable("Section", dtGlobalSheet) vbwindow("vbname:=frmDeduction").ActiveX("acx_name:=DataCombo","abs_y:= 216").Type micTab vbwindow("vbname:=frmDeduction").VbEdit("vbname:=txtAmtOfPay").Set DataTable("Amount_of_Payment", dtGlobalSheet) vbwindow("vbname:=frmDeduction").VbEdit("vbname:=txtAmtPaidDate").Set DataTable("Amount_PaidCredited_Date", dtGlobalSheet) vbwindow("vbname:=frmDeduction").VbEdit("vbname:=txtAmtPaidDate").Type micTab vbwindow("vbname:=frmDeduction").ActiveX("acx_name:=DataCombo","abs_y:= 316").Type micF4 vbwindow("vbname:=frmDeduction").ActiveX("acx_name:=DataCombo","abs_y:= 316").Type DataTable("Deduction_is", dtGlobalSheet) vbwindow("vbname:=frmDeduction").ActiveX("acx_name:=DataCombo","abs_y:= 316").Type micTab vbwindow("vbname:=frmDeduction").VbButton("vbname:=cmdSave").Click DataTable.SetNextRow Next vbwindow("vbname:=frmDeduction").VbButton("vbname:=cmdClose").Click

0 Answers

What the differences are and best practical application of each.

1 Answers

HI, Anybody can explain Automation Test Framework...and wht do we do before start of Automation.....

5 Answers Polaris, Siemens,

Which environments are supported by hp qtp?

0 Answers

why we are using environment variables instead of global variables?

1 Answers TCS,

Hi! Using Descriptive Programming How do we get Parent object for an object by writing script(DP). Say, i want to get a parent object for a "Link" in a web page by writing script in Descriptive Programming.

0 Answers

what is run-time data?

0 Answers

does the vb script knowledge is mandatery in testing using QTP

1 Answers

Is it possible to check the Run time value property of a field through a Database Checkpoint ? Further, is it possible to localize and mention a particular cell , in the database dynamically. My requirement is that I would need to check the status of a particular field , that would change from an "Active" state to a "Stopped" state dynamically.

1 Answers CTS,

What are the five challenges you faced in QTP?

0 Answers CTS,

For more QTP Interview Questions Click Here