Hi there,

Today I will not be writing any technical articles based on my field. Instead wanted to write about best things I have adopted in up & downs faced lately in my life.

I was bored.

My mind was tired of my daily routine of going to office, working, lunch, meetings, coming back home, dinner & sleep. After few days, it even whisper the next event on my schedule and predicted what was going to happen in next few minutes. Most of the times prediction was accurate and I was bored that much.

I tried going for shopping without having any specific thing to buy. Don’t worry! It doesn’t matter what is the crisis i’m involved in, always I have something to buy. But that was temporary happiness. I was so excited & happy while shopping and once back in home, its’ just gone! …

This a quick guide on writing test results in excel sheet at the end of your automation testing.

Use Case: Writing one cucumber test scenario test results in excel sheet

Tech Stack:

  • TestNG Automation Framework With Cucumber
  • Java 8
  • Maven
  • Rest Assured for API test automation
  • Selenium for UI test automation

Integration of Excel Sheet Output for Automation Tests

Apache POI: This is an open source project run by the Apache Software Foundation, and previously a sub-project of the Jakarta Project, provides pure Java libraries for reading and writing files in Microsoft Office formats, such as Word, PowerPoint and Excel.


When “RequestSpecification” for the HTTP request, you may forget to check URL encoding. That may affect the path you need to invoke.


You need to invoke:

By default, URL encoding enabled with RequestSpecification requests and will be the request as follows:

Hence disable URL encoding:


Dilshani Subasinghe

Techie | Traveler | Writer

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store