Search
 
 

Display results as :
 


Rechercher Advanced Search

Latest topics
» Regarding Alert Interface
Fri Feb 24, 2017 2:00 pm by karthikeyakumar

» Geting issues in identifying the elsements in webdriver
Fri Feb 17, 2017 4:41 pm by janbaskt

» WebDriver - why not to use a singlton for it?
Fri Feb 17, 2017 4:40 pm by janbaskt

» WebDriver session when using testng annotation to invoke driver instance
Fri Feb 17, 2017 4:39 pm by janbaskt

» Selenium fails to launch Chrome
Fri Feb 17, 2017 4:39 pm by janbaskt

» why do i get this error
Fri Feb 17, 2017 4:38 pm by janbaskt

» Selenium Tutorial
Thu Feb 16, 2017 5:21 pm by Rahul

» When to use Selenium IDE, RC and WebDriver
Mon Feb 13, 2017 2:35 pm by azharuddin

» How to integrate selenium with ZAPI-Zephyr
Sat Feb 11, 2017 2:25 am by gseera002c

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