Selenium Framework for Beginners 18 | How to use Excel for getting data in Selenium Java Framework

Also check this -    • How to read excel in Java   Website - https://automationstepbystep.com/ Today we will learn Why to use excel files How to add excel libraries How to create excel read function GetRowCount GetCellData How to call excel functions helpful tips Free Courses - https://automationstepbystep.com/ Why to use excel file In Selenium we can get data from external files like excel and csv MS Excel is most commonly used Helps to make our scripts independent of data handling Helps to add, update, manage data separately (outside the framework) Helps to make our framework data driven How to add excel libraries Step 1 Add apache poi libraries Download and add Jars from : https://poi.apache.org/download.html OR Add maven dependency From : https://mvnrepository.com/artifact/or... Step 2 Check if the libraries are added in your project Get Row Count Step 1 Create excel file and add some data Step 2 Create references for Workbook for new excel format (xlsx) XSSFWorkbook workbook = new XSSFWorkbook(“excel file location”); for old excel format (xls) HSSFWorkbook workbook = new HSSFWorkbook(“excel file location”); Step 3 Create references for Worksheet XSSFSheet sheet = workbook.getSheet(“sheet name”); Step 4 Call row count function sheet.getPhysicalNumberOfRows(); Get Cell Data Step 1 Create references for Workbook XSSFWorkbook workbook = new XSSFWorkbook(“excel file location”); Step 2 Create references for Worksheet XSSFSheet sheet = workbook.getSheet(“sheet name”); Step 3 Call function to get cell data sheet.getRow(rownum).getCell(colnum).getStringCellValue(); sheet.getRow(rownum).getCell(colnum).getNumericCellValue(); How to call excel functions Step 1 In all excel functions get rowNum, colNum as parameters This is to avoid hard coding of values and get the values from calling function Step 2 Create a constructor A constructor is a special method without any return type and name same as the class name Constructor is called every time a class object is created using the new() keyword Step 3 Parametrize the constructor To get excel path and sheet name Step 4 Create a new class to call excel functions Like, Subscribe & Share You can support my mission for education by sharing this knowledge and helping as many people as you can Never Stop Learning Raghav