Save test result in Excel sheet

Save test result in Excel sheet - Printable Version

+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: VB Scripting/Descriptive Programming (https://www.learnqtp.com/forums/Forum-VB-Scripting-Descriptive-Programming)
+--- Thread: Save test result in Excel sheet (/Thread-Save-test-result-in-Excel-sheet)

Save test result in Excel sheet - janriis - 10-11-2010

Hi all

I am quite sure that there are several threads regarding test results to Excel, but what I need is the following:

For each web page or element im checking, I have the following code

Code:
If Browser(tBrowser).Page(tPage).Frame(tFrame).WebRadioGroup(tWebRadioGroupHEHFleksAnmod).Exist Then

reporter.ReportEvent micPass, "Page #1:","Page OK"

else

reporter.ReportEvent micPass, "Page #1:","Page Not OK"

end if

Now i want to export this to an Excel sheet with 2 columns:

Column A: Page #
Column B: Status
Column C: Company name
Column D: Iteration #

How do i do this with descriptive programming ?

RE: Save test result in Excel sheet - KavitaPriyaCR - 10-11-2010

I don't think these are possible,
1. we can export log file as excel file.
2. We can export specific columns to excel

We can acheive these by adding sheet to Data table (or to the existing sheet only we can), add required parameters to that sheet, write the results into that sheet and finally export that sheet to required excel file.
if reqd, i will give you script for this.