I want to add the output values of two scenarios in the DataTable during runtime. However, after running the test script only the output value of second scenario is getting displayed in the Data Table as viewed through the Runtime Table Summary. The first output value is getting overwritten by the second output value.

I tried using the "DataTable.SetNextRow" method, however its not working.
Kindly assist.
Many thanks

Question asked by visitor

Can you please elaborate more on what is ur problem as the output value will be written only on the current row and until you pass to next row in ur script the values will be overwritten.

If you want to kep the value of any object then its always better to use the GetRO propery and assign it against some variable.

Hope this helps you can always come back with more clear explanation of your problem.

Thanks,
Kunals.

Try this:

Save the two output values in "FOutputValue" and "SOutputValue" and use the following code:

(Pre-req: Create a dummy file named dummy.xls in the root folder)

Set ExcelAppl=CreateObject("Excel.Application")
Set WrkBook=ExcelAppl.Workbooks.Open("C:\dummy.xls")
Set sheetPrimary=WrkBook.Activesheet
sheetPrimary.Cells(1,1)=""&FOutputValue
sheetPrimary.Cells(1,2)=""&SOutputValue
WrkBook.Save
ExcelAppl.Quit