Generate Excel Report in Selenium using TestNG

Please use the following link to install the Katalon Studio:

https://katalon.com/sign-up?getr=krishnaRef Check Tubebuddy Features Here:
https://www.tubebuddy.com/krishnasakinala Facebook : https://www.facebook.com/automationtesting2016/
Linkedin : https://twitter.com/krishnasakinala
Google+ : https://plus.google.com/105286300926085335367
Twitter : https://www.linkedin.com/feed/?trk=hb_signin
Jar File Location - https://drive.google.com/open?id=0B3MavAHOpQakYlZwZGpqdzRqNXM

Blog - http://automationtesting.in/generate-excel-report-in-selenium-using-testng/

In software test automation after completion of the test suite execution we need to have a report for the execution status and it is the only way of evidence for the pass and fail status of the tests. And most of the clients bother about the detailed report of the execution status. Most of the licensed automation testing tools will have in built rich report option to show the execution status. But coming to open source automation tools lacking in this option. Same way, Selenium also does not have the automation report generation option. But to execute the test suite, selenium is depending on unit testing frameworks like TestNG and Junit.

After test suite execution using TestNG or Junit, by default they will give the HTML reports, but the information provided by these reports are not so good. And apart from these reports sometimes there is need to generate Excel Reports as people habituated to Excel. And the information should be very clear and should show the summary also for the PASS, FAIL and SKIP status of the entire test suite in the form of PIE chart. To generate these kind of reports we need to write so much of logic. But to avoid that and generate nice Excel reports we can download this ATExcelReport jar file and can generate the excel report. And this report has dependency with the TestNG. So, to generate this kind of report we need to run the entire test suite using TestNG before generating the excel report.

To generate excel report we will take two sample scripts and will execute the same with testng.xml file first then we can generate the excel report. Here, for each test tag in the testng.xml file; it will create separate sheet in the excel and will provide the test result in that sheet. Apart from this result, it will create a sheet called Summary sheet and it will give the total tests pass fail status in the form of PIE chart.