We use Excel file in our day to day work, for creating daily reports or maintaining expense sheet at home. Excel can also be used as a simple database, we can read entries from an excel file and can use them further in our program. We are using excel file to store Test execution reports, such as validation points, whether the test case is passed or not, true or false, and later using that cell information to decide whether the Test Case was passed or not. Excel automation plays an important role when using in Automation testing. We are using TestNG framework for our Test Case execution and stores the result in either Excel file(using java) or we use emailable reports from TestNG. We need to add external jar in our project to read and write excel file, POI jar is used to do this. You can download the jars from below link. Download POI Jars Follow below steps in eclipse to add the POI jars to your project After downloading the jars unzip the file Rig...