How to write the test results into excel sheet

Help Studio
, ,
1

I have written some test cases and the result of the test case I need to write it into excel sheet.
Can anyone suggest me how to do it?

2

Hi @Kunal_Jain

You can use the ‘Write Range’ activity to write the result into an Excel file. If you want to write multiple sheets in the same file, you can do the same by using the same file location but distinct sheet names.

Hope this helps, let us know if you want more details.

Best Regards.

3

Hi @arjunshenoy ,
I need to write just the result of test cases i.e. If a test case fails than write False, and if it passes write True.
for that Test case.
How to do it??

4

@Kunal_Jain

I assume that you’ll be writing this in a tabular format right?

Test Case Result
1 True
2 False
3 True

Please confirm if this is how you are planing to write the data into an Excel.

Best Regards.

5

I have to write the test case in the format provided below:
Name of Test Case Value Expected Result Actual Result

1.LogIn ABC True True