How to import the Test Results in QTP to an Excel sheet

Answers were Sorted based on User's Feedback



How to import the Test Results in QTP to an Excel sheet..

Answer / mahi

if we want import complete sheet then go for


Datatable.Export "path of the excel file"

if we want import a perticular sheet then go for,

Datatable.ExportSheet "path of the excell file",SheetId to be exported

Is This Answer Correct ?    1 Yes 0 No

How to import the Test Results in QTP to an Excel sheet..

Answer / sudeepthz

could you explain with an example.. that would be greatful to me

Is This Answer Correct ?    0 Yes 2 No

How to import the Test Results in QTP to an Excel sheet..

Answer / venkat reddy

we can import testresults to excel sheet by using datatable
methods

Ex:-datatable.exportsheet "path where you want to
save.xls",sheetid


if i am wrong please correct me...

Is This Answer Correct ?    0 Yes 3 No

How to import the Test Results in QTP to an Excel sheet..

Answer / ravindra

DataTable.ExportSheet Relativepath &"path of that
excelsheet","Sheetname"

Is This Answer Correct ?    0 Yes 5 No

Post New Answer

More QTP Interview Questions

hi testers,one script has three actions , at the of running three actions are running , how to set run only perticular action and what is the use of split the action? when it will be useful?

3 Answers   Syntel,


how can i change the action path that called in other action. when i copy one action to other pc,the action"test2" calls another action(C:\test1\action0),and i update this"test1",the folder update to "action1",but when i open "test2", it just point the call path to "C:\test1 \action0", but does not update to "action1",and the change i make can be shown in test2. so, can i update the call path manully? thanks

2 Answers   HP,


I have 3 browsers i want to give facebook url in 2 nd browser using qtp

3 Answers   Tech Mahindra,


We are using the QTP version 9.0 where we want to call objects from global repository for a particular function at runtime for increasing the performance of framework.We are actually looking for loading the objects under test (OAT) dynamically when script runs and would like to unload the same once the execution of the script is completed.

2 Answers  


how can u put synchronization point in qtp,wat is exactly synchroniztion why we use it wat is benifit in qtp

13 Answers   College School Exams Tests, Mind Tree,






where exactly we can't do the automation testing. give some examples

2 Answers   Virtusa, Wipro,


Gmail application is there.On that Inbox so many mails are there including naukari mails. On that mails i can select the only naukri mail checkboxes. plz tell the descriptive code for the above..

2 Answers   Impetus,


How to attach a file to TD?

0 Answers  


In your QTP framework, what checkpoints were applied in the script to minimize script failure due to any reason during execution?

1 Answers   ITC Infotech,


Hi All I'm new in QTP. I'm trying to make test cases for login on Flight.exe . I have parametrise the agentname and password field. So wen wromg agent name or password is entered it show a dialog box with proper message(Like: "Wrong Password" or :Please enter Password" etc) and OK button. I have created If else block. Now my problem is i want to make checkpoint on error message Dialog box. But each time i create a checkpoint it shows same text message. So how i can check that message is there or not.

2 Answers  


How can we QTP Scripts in xml format? is there any way to do so?

2 Answers   Apex,


which is the easiest way you can send the QTP test results to Client if he want to see the screenshots when the results are failed?

1 Answers   CTS,


Categories