Search
 
 

Display results as :
 


Rechercher Advanced Search

Latest topics
» FlexMonkium Download Not available under Gorillalogic site
Thu Dec 08, 2016 5:40 pm by bhanu.praveen

» Selenium Script issue
Tue Dec 06, 2016 9:48 pm by njain213

» Difference between QTP, Selenium and Silk test
Tue Dec 06, 2016 7:58 pm by jessicacyrus1

» Where does selenium script pick browser from
Tue Dec 06, 2016 1:52 pm by janbaskt

» Safari throws an HTTP ERROR: 404
Tue Dec 06, 2016 1:51 pm by janbaskt

» Access Denied Error in Selenium RC
Tue Dec 06, 2016 1:51 pm by janbaskt

» Automating Flex application through selenium webdriver
Fri Dec 02, 2016 2:06 pm by abhinay.krs

» Starting with Selenium, what is Selenium?
Mon Nov 28, 2016 4:00 pm by Foma

» Getting started with Selenium
Mon Nov 28, 2016 3:23 pm by Rebbelx

Navigation
 Portal
 Index
 Memberlist
 Profile
 FAQ
 Search

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

View previous topic View next topic Go down

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

Post by sai.tanmai 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

sai.tanmai

Posts : 1
Join date : 2013-06-17

Back to top Go down

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

Post by Love Sharma 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

Love Sharma
Regular Participant
Regular Participant

Posts : 27
Join date : 2012-06-01

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum