Share
Go down
sai.tanmai
Posts : 1
Join date : 2013-06-17

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

on Wed Jun 26, 2013 3:17 pm
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
Love Sharma
Regular Participant
Regular Participant
Posts : 27
Join date : 2012-06-01

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

on Thu Oct 24, 2013 10:45 am
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
Back to top
Permissions in this forum:
You cannot reply to topics in this forum