Export Test Results To Excel Sheet
Hi, Please help me with code, on how to export test results to excel sheet..
Forum Discussion
''''Excel:
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
objExcel.Workbooks.Add
intRow = 2
objExcel.Cells(1, 1).Value = "starttrack"
'Your Existing Vbs Script Goes Here.
A= "PASS"
B="FAIL"
If VRes_code=Code_number Then
Log.Message "Responce Code:"+VRes_code+" PASS"
objExcel.Cells(intRow, 1).Value = A
else
objExcel.Cells(intRow, 1).Value = B
Log.Error "Responce Code:"+VRes_code+" FAIL"
end if
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
objExcel.Workbooks.Add
intRow = 2
objExcel.Cells(1, 1).Value = "starttrack"
'Your Existing Vbs Script Goes Here.
A= "PASS"
B="FAIL"
If VRes_code=Code_number Then
Log.Message "Responce Code:"+VRes_code+" PASS"
objExcel.Cells(intRow, 1).Value = A
else
objExcel.Cells(intRow, 1).Value = B
Log.Error "Responce Code:"+VRes_code+" FAIL"
end if
