How to work with excel opened from IE application using Selenium webdriver java code

Hi All,

We have a scenario where excel will be downloaded from IE application and using the add in of the excel we need to submit some data to DB from excel. Any suggestions on how do we handle this scenario using Selenium Webdriver

Thanks in advance

Hi Sai,

Assuming you have excel sheet downloaded on your machine and you know how to push data in DB, please see below steps to pick the read the data from excel sheet using Selenium Webdriver:

Download plugin “jxl-2.6.jar” //Or any latest version

import java.io.FileInputStream;
import java.io.IOException;
import jxl.Sheet;
import jxl.Workbook;

FileInputStream efile=new FileInputStream("E:\\"File Path"\\Sheet1.xls");
//It does not work with xlsx version

Workbook workbook = Workbook.getWorkbook(efile);
Sheet sheet = workbook.getSheet("Login");
String username=sheet.getCell(0,2).getContents(); //Col,Row


You may use this code in a loop to fetch the data for every record

Thanks,
Lovekesh