Selenium Framework Tutorial #11 - Read Excel File in Selenium with Apache POI - Part 2

In this Selenium Framework Tutorial, we will learn how to read excel file in selenium with apache POI library. In this part 2 video we will learn how to write the custom utility using apache POI to read test data from XLS file and use that data in our test scripts

🌟 Please hit LIKE ❤️, SHARE, and SUBSCRIBE for more AMAZING courses:

🌟 TEST AUTOMATION COURSES 🌟

🌟 MANUAL TESTING AND ISTQB COURSES 🌟

🌟 SOFTWARE TESTING MOCK INTERVIEWS 🌟

🌟 SOFTWARE TESTING INTERVIEW QUESTIONS AND ANSWERS 🌟

🌟 RESUME AND CAREER TIPS 🌟

🌟 API TESTING COURSES 🌟

🌟 PROGRAMMING COURSES 🌟

🌟 TEST MANAGEMENT TOOLS 🌟

🌟 AGILE TESTING TOOLS 🌟

🌟 ATLASSIAN JIRA COURSES 🌟

🌟 AGILE PROJECT MANAGEMENT COURSES 🌟

🌟 AGILE BASICS COURSE 🌟

🌟 FOLLOW US ON TWITTER 🌟

🌟 LIKE US ON FACEBOOK 🌟

🌟 OUR TUTORIAL WEBSITES 🌟

🌟 GET MY TRAININGS ON UDEMY 🌟

✨ Tags ✨
selenium framework,selenium framework tutorial,selenium framework using java,selenium framework for beginners,apache poi for selenium,apache poi maven dependency,apache poi java,apache poi install eclipse,apache poi download eclipse,apache poi download,how to read data from excel sheet in selenium webdriver using java,how to read excel file in selenium webdriver,apache poi,Read Excel File in Selenium with Apache POI Part 2

✨ Hashtags ✨
#SeleniumTutorial #SeleniumJavaFramework #SeleniumFramework #Framework #SeleniumWebDriverJava #RcvAcademy #SoftwareTestingMentor

🌟 Join this channel to support my work 🌟

[snehaingalkar]

I was waiting for videos. Thanks a lot for such informative videos.

[krishnavamankrishna]

if in Excel we used a formula for calculation then formateCellValue can display in the console that formula instead of value any alternative solution is there

[ashish_dewal]

Can you please help me i am getting the error "Cannot invoke because "sheetName" is null"

[monil.joshi]

How to read excel file present on one drive in selenium java

[AjaySingh-oezb]

It is giving error - "You need to specify at least one testng.xml, one class or one method"

[mvtvvlogs]

getting this error: have tried everything not able to resolve: Please help:
java: cannot access
class file for not found

[TheCoolparas]

package utilities;

import java.io.File;
import java.io.FileInputStream;
import
import java.io.IOException;

import
import
import
import
import
import

public class ReadXLSdata {

public static void main(String[] args) throws EncryptedDocumentException, IOException {

ReadXLSdata red = new ReadXLSdata();
red.getdata("login");

}

public String[][] getdata(String excelSheetName) throws EncryptedDocumentException, IOException {

File f = new +

FileInputStream fis = new FileInputStream(f);

Workbook wb = WorkbookFactory.create(fis);

Sheet sheetName = wb.getSheet(excelSheetName);

int totalRows = sheetName.getLastRowNum(); // FOR ROW COUNT


Row rowCells = sheetName.getRow(0); // FOR COULMNS COUNT
int totalCols = rowCells.getLastCellNum();


DataFormatter format = new DataFormatter();

String testData[][] = new

for (int i = 1; i <= totalRows; i++) {

for (int j = 0; j < totalCols; j++) {

testData[i - 1][j] =

- 1][j]);
}
}

return testData;
}
}