Breaking News: Grepper is joining You.com. Read the official announcement!

how to read excel file in selenium java

Final-Flash answered on February 12, 2023 Popularity 4/10 Helpfulness 7/10

answer how to read excel file in selenium java

how to read excel file in selenium java

Comment

 // excel file is like 2D array
// file must be with .xlsx 
//setup your project with apache POI dependency

// below function takes two input
public static String ReadData(int row, int cell) throws IOException {
	String path="C:\\DataFile.xlsx";
	FileInputStream fis = new FileInputStream(new File(path));
	XSSFWorkbook workbook = new XSSFWorkbook(fis);
	XSSFSheet sheet = workbook.getSheetAt(0);//select your sheet 
	XSSFRow row = sheet.getRow(row);
	String	data = row.getCell(cell).getStringCellValue();
	return data;
				
}

//with FileOutputStream you can write data into file

Popularity 4/10 Helpfulness 7/10 Language java

Source: Grepper

Tags: excel file java selenium-java

Link to this answer
Share Copy Link

Contributed on Feb 12 2023

Final-Flash

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

how to read excel file in selenium java

Contents

More Related Answers

how to read excel file in selenium java

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.