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

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/org.apache.poi/poi-ooxml 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 PLAYLISTS Udemy Discounts - https://automationstepbystep.com/udemy-discounts/ GitHub - https://github.com/Raghav-Pal/ Udemy - https://www.udemy.com/user/raghav-pal-3/ Training by Raghav at your venue - [email protected] Training schedule - https://automationstepbystep.com/trainings-2/ ------------ UI TESTING ------------ Selenium Beginners - https://bit.ly/2MGRS8K Selenium Java Framework from Scratch - https://bit.ly/2N9xvR6 Selenium Python - https://bit.ly/2oyMp5x Selenium Tips - https://bit.ly/2owxc50 Selenium Builder - https://bit.ly/2MKNtlq Katalon Studio - https://bit.ly/2wARFdi Robot Framework with RIDE- https://bit.ly/2Px6Ue9 Robot Framework with Eclipse - http://bit.ly/2N8DZxb Protractor - http://bit.ly/2KtqVkU TestProject - http://bit.ly/2DRNJYE ------------ API TESTING ------------ Web Services (API) - https://bit.ly/2MGafL7 SoapUI - https://bit.ly/2MGahmd Postman - https://bit.ly/2wz8LrW General - https://bit.ly/2PYdwmV Katalon Studio API Testing - https://bit.ly/2BwuCTN ------------ MOBILE TESTING ------------ Appium - https://bit.ly/2ZHFSGX Mobile Playlist - https://bit.ly/2PxpeUv ------------ CI | CD | DEVOPS ------------ Jenkins Beginner - https://bit.ly/2MIn8EC Jenkins Tips & Trick - https://bit.ly/2LRt6xC Docker - https://bit.ly/2MInnzx Kubernetes - http://bit.ly/2MJIlMK ------------ VERSION CONTROL SYSTEM ------------ Git & GitHub - https://bit.ly/2Q1pagY GitLab - http://bit.ly/2kQPGyQ ------------ PERFORMANCE TESTING ------------ JMeter Beginner - https://bit.ly/2oBbtIU JMeter Intermediate - https://bit.ly/2oziNVB JMeter Advanced - https://bit.ly/2Q22Y6a JMeter Tips & Tricks - https://bit.ly/2NOfWD2 Performance Testing - https://bit.ly/2wEXbLS ------------ PROGRAMMING ------------ Java Beginners - https://bit.ly/2PVUcXs Java Tips & Tricks - https://bit.ly/2CdcDnJ GROOVY - https://bit.ly/2FvWV5C JAVASCRIPT - http://bit.ly/2KJDZ8o PYTHON - http://bit.ly/2Z4iRye ------------ IDE ------------ Visual Studio Code - https://bit.ly/2V15yvt ------------ MAVEN ------------ Maven - https://bit.ly/2NJdDRS ------------ OTHERS ------------ Redis- https://bit.ly/2N9jyCG Misc - https://bit.ly/2Q2q5xQ Tools & Tips - https://bit.ly/2oBfwoR QnA Friday- https://bit.ly/2NgwGpw Sunday Special - https://bit.ly/2wB23BO Ask Raghav - https://bit.ly/2CoJGWf Interviews - https://bit.ly/2NIPPxk All Playlists - https://bit.ly/2LSiezA Keep Learning, Raghav ----------- Connect with Raghav ------------ Website - https://automationstepbystep.com/ LifeCharger - http://lifecharger.org/ Udemy Courses - https://www.udemy.com/user/raghav-pal-3/ Facebook - https://www.facebook.com/automationstepbystep Twitter - https://twitter.com/automationsbs Youtube - http://youtube.com/automationstepbystep Like, Subscribe & Share You can support my mission for education by sharing this knowledge and helping as many people as you can