We will see the use of apache POI open source library in java to read and write excel file. If you are using Apache POI > 4.x version, then refer Read write excel using Java 4.x Download We have 2 ways to download the Apache POI library If using normal java project, download POI jar…
According to http://jexcelapi.sourceforge.net/ – jexcel API is to read and write excel sheet data, Note: Excel should be of .xls format , if it is a .xlxs format, then open the excel and click onFile -> Save As and choose “Excel 97-2003 WorkBook” format. We can’t edit an existing excel, but can create a new excel(copy existing excel content) and update…
There are 2 ways to edit or set environmental or system variable on windows machines: Method 1 – In Windows 7 OS Then, When we update existing variables, then we need to append value instead of overwriting existing value, better to add “;” at the end and append the value. Method 2 – Through command…
In this post, we will see how to convert testng report (index.html) to a more readable/emailable report by using ANT build and build.xml. We will see how we can generate the following report[screenshot] after done the required steps: Things Required: Eclipse IDE – If you are new, please follow this link Create 4 .java…
Testing your web application across different browsers to make sure: Application performs similar manner for different browsers. Webelements should be working as expected.(Active or inactive) Application should have same font and color for objects. Length/width of fields should be same across browsers. Test case: verify saucedemo site login For this we will use selenium java and…
To view the HTML content and spy on an webelement, there are different ways for different browsers, mostly people use firefox browser to identify the web elements as it has more number of addons for web element identification. 1) Firebug – Once firebug is installed, you will see a bug icon on the right top…
Selenium provides different type of locators to uniquely identify web elements on the browser. Any web application elements that render on the HTML DOM [tags & attributes] can be automated using selenium. To view the HTML DOM on any browser – On any browser > load the application url > right click on any element…
As mentioned in prevois post selenium webdriver setup, hope you downloaded the Eclipse IDE and all required jar files. NOTE: Place the Eclipse IDE and jar files under a fixed folder location, do not change the folder path once you start writing the selenium tests. Note: If you are using Maven project to maintain your jar…
Note: For the entire discussion of selenium topics on this blog, we will be using Java language. Basic setup of selenium webdriver needs the following items – JDK – Java developement kit: Download and install latest from here, Note: Click on the icon (Java Platform (JDK) xxxx) and follow the agreement procedure, then choose right file for…