How to add test case status (Pass / Fail) in result excel file using Selenium WebDriver?

Replies to This Discussion

Permalink Reply by Meenakshi Agarwal on January 26, 2019 at 9:43am

Hello Madhavi,

Yes, it is possible to write test cases in XLS files and also to store their pass/fail results into the "Result/Status" field in the same sheet or a different sheet. For this, you need to use TestNG (basically its annotation features) along with the Selenium Webdriver.

Here is a full-fledged example demonstrating how to use selenium to run test cases from XLS file and save their results.

Thanks-

• ▶ Reply

Permalink Reply by Madhavi Latha on January 29, 2019 at 4:59pm

Hi Meenakshi,

Thanks for sharing your blog. It is very helpful to me.

My test case scenario is: ---

- I have a test cases excel file(testcases.xlsx) in sheet1

From test cases sheet, I need to access test data aswell.

Once test case got executed, I need to create new file (Results.xlsx) in sheet1 and add test case actual result and test case status 

For example:

Test Cases sheet: (testcases.xlsx)

Result file: (Results.xlsx)

• ▶ Reply

Permalink Reply by Madhavi Latha on February 1, 2019 at 2:31pm

Can any one answer to this question....

• ▶ Reply

Permalink Reply by Madhavi Latha on February 15, 2019 at 5:17pm

Hi Meenakshi, 

Can you please reply to this question?

• ▶ Reply

Permalink Reply by Madhavi Latha on January 29, 2019 at 5:22pm

@Meenakshi,

This is regarding your blog:

Your class name " SaveTestNGResultsToExcel class " having multiple @Test annotations, so you can able to write each testcase result you are able to write in SaveTestNGResultToExcel.xls

Say for example, if the Package (login) having 10 test cases (10 java classes)

How to write each test case java class in result in SaveTestNGResultToExcel.xls file?

• ▶ Reply