Skip to main content

Posts

Showing posts from January 7, 2021

Read & Write Data from Excel in Selenium: Apache POI

  Selenium WebDriver   is the most used automation tool for the automation of web applications. Now, we know that these web applications are used by multiple users, and each one of those uses the applications as per their own data. So, considering the usage, it becomes the primary responsibility of the QAs also to test the web applications with varying data sets. Now the user journeys will be the same, but the data set will be different. Therefore, it makes more sense to execute the same test case with different data, instead of writing a separate test case for each user journey with each data set. This is where   Microsoft Excel   comes in handy, which is one of the favorite tools for storing test data.   Excel in Selenium   is one of the most used combinations for storing test data and then running the same test case against various data sets. There are various libraries in  JAVA  which helps in reading/writing data from  Excel  files....