Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Save test result in Excel sheet
#1
Not Solved
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 ?
Reply
#2
Not Solved
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.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Trying to create List box in excel sheet at Run time with values yes No JACKSPARROW 0 1,589 01-17-2017, 11:05 AM
Last Post: JACKSPARROW
  Not able to click the save button in Save As window while downloading from SAP kathirvelnagaraj 0 2,300 08-25-2015, 07:37 PM
Last Post: kathirvelnagaraj
  Custom sort -Excel Sheet kiran 1 3,690 01-28-2014, 09:23 AM
Last Post: supputuri
  Can we save an exported Excel sheet directly from QTP? Akhila 2 3,138 11-28-2013, 10:30 AM
Last Post: Akhila
  Save File1.xls as Text File1.txt with save as type - Text(Tab Delimited) Rupesh Singh 0 2,409 03-13-2013, 09:54 AM
Last Post: Rupesh Singh

Forum Jump:


Users browsing this thread: 1 Guest(s)