Search
 
 

Display results as :
 


Rechercher Advanced Search

Latest topics
» how to connect DB in selenium webriver
Fri Oct 06, 2017 4:09 pm by anbarasi

» How find any text in browser screen and click on it?
Thu Oct 05, 2017 2:02 pm by sandeepkommineni

» Selenium Webdriver
Tue Oct 03, 2017 1:35 pm by PiyushBiswas

» GRID setup tutorial.
Wed Sep 27, 2017 4:29 pm by johnyapp

» Drag & Drop Between Windows Using Selenium Driver
Wed Sep 27, 2017 2:10 pm by 26rondel

» Check if window is closed / verify input
Sat Sep 23, 2017 10:21 pm by brainstir

» How to work on pages with AJAX in selenium?
Mon Sep 18, 2017 6:08 pm by azharuddin

» pause test until user press a key like F2
Wed Aug 09, 2017 11:10 pm by djnforce

» Selecting the input for auto populating element
Sat Jul 29, 2017 7:53 pm by kdabbara

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