Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
need information regarding test batch runner
#2
Solved: 11 Years, 4 Months ago
Hi Galstar,

I can give you a one user defined function so that wherever you write Reporter.ReportEvent just add one more function which i have mentioned here so that you can see all the test results in excel.

Find the below function.

Code:
Function ReportResultToExcel(Testcase, Functionality,Description,Result)
    Set objExcel=CreateObject ("Excel.Application")
    Set objWorkBook=objExcel.Workbooks.Open("D:\xxxxxAUTOMATION\Test Result\TestResults.xls")
    Set objWorkSheet=objExcel.Worksheets("Sheet1")
    objExcel.DisplayAlerts=False
    rc=objWorkSheet.UsedRange.Rows.count
    rc=rc+1
    objWorkSheet.Cells(rc,1).value=Testcase
    objWorkSheet.Cells(rc,2).value=Functionality
    objWorkSheet.Cells(rc,3).value=Description
    objWorkSheet.Cells(rc,4).value=Result
    objWorkBook.Save
    objWorkBook.Close
    Set objWorkBook=Nothing
    Set objWorkSheet=Nothing
    Set objExcel=Nothing
End Function

Please let me know for further clarification.


Regards,
Venkat.Batchu.
Reply


Messages In This Thread
RE: need information regarding test batch runner - by venkatbatchu - 09-03-2010, 04:24 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Object identified despite having no information mjt 1 2,127 09-14-2015, 08:25 PM
Last Post: mjt
  QTP is getting closed after executing first test in MTM(Batch) Shyama 0 2,153 10-07-2014, 07:26 PM
Last Post: Shyama
  get cell data and frame information excellentpawan 2 2,882 06-21-2013, 02:35 PM
Last Post: vinod123
  Need information on disabled text box. sambu240 3 4,043 08-18-2012, 10:03 AM
Last Post: ravi.gajul
  Need information on actions. sambu240 0 1,787 08-15-2012, 11:40 AM
Last Post: sambu240

Forum Jump:


Users browsing this thread: 1 Guest(s)