Group Discounts available for 3+ students and Corporate Clients

Introduction to IO streams /external files in Selenium

Introduction to IO streams /external files  in Selenium

  • For better maintenance of the project we are goiing to take the test data and locators by using the external files like excel text pad, xml ,database e.t.c
  • We are going to use excel files to maintain the test data&locators.

Why Excel:-

  • We can store the data in a format with the help of rows& columns. so the maintain is easy.
  • If you save the excel .xls format [Excel 97-2003 workbook[xls]]
  • Then it can access in any operating system[platform independence]
  • As part of manual testing we are maintaining test cases & test data in Excel file .so we can directly access those files to take the test data.
  • To support Excel files we need to configure jx1.jar file in Eclipse.
  • We can download the jx1.jar file from our site selenium testing
  • http://selenium in for testing
  • Copy jx1.jar file in lib folder.
  • Configure it in Eclipse by using same steps as sikuli jar file

Test data:-

  • The data which we are going to use to test the application is known as test data.
  • Create a folder with the name “test data” under the project folder of “work space”.
  • Take an Excel file and give the test data in below format

User name (JanJo selenium)


  • Save the Excel file with .xls formate [97-2003] in test data folder

* Write a program to login into mail by banking object repository from an excel file

Object repository:-

2repository mean a storage folder .object repository mean a storage folder which contains the element location like id, css, x path, name e.t.c.

2Create a folder with the name of workspace.

Take an Excel file and give the object repository in below format.

User name (f_ id)  pass word (f_ pwd)  sign (input _ sign in)

2  Save the Excel file in .Xis format [97 -2003] in or Folder

Inclined to build a profession as Selenium Developer? Then here is the blog post on Selenium Training In Chennai.


* Write a program to test the log in functionality of mail income by the rest data and object repository from 2

Different Excel Files:

Public class log in _ OR


Public web driver driver;

Public FileinputStream fi;

Public Workbook w;

Public Sheet S;

@ ist

Public void verify login ( ) thrown Exception


fi = new File inputStream (“E:\\…\\OR\\login.XIS”);

w = Workbook. Getworkbook(fi);

s= w.getsheet(“login”);

driver . Find  Element (,1). Get content())) . send keys(Jan 30 selenium)

driver.Find Element …(1,1) ….(“selenium”)

driver. Find element (By.cssSelection(s.getcell(2,1).get content()) .click();


@ Test public void verify logout()from exe


* Write a program to test the login functionality with multiple sets of login


* Write a program to test the login functionality of the with multiple sets of login credentials

* Test the log in functionality of with multiple sets of login credentials and provide the results in the below formula

Username password Result
Jan 30 selenium selenium Pass
Nagesh1 selenium Fail
April selenium selenium Pass
Nagesh 2 selenium fail

2 To accomplish the above scenario we need to fallow below 3 steps

  • Create an Excel File [Result File]
  • Add the complete i/p data to the created resuch file
  • Add a result column and provide the resuch an pass or fail based on the execution

2 Create a folder with the name ”Result” under the project folder of “work space 10” and capture all the results into this folder


Public void step1() throws Exception


FileoutputStream fo = new FileOutputStream (“E:\\work Space _10Am \\ selenium\\ result\\login.XIS”);

Writable Work book wb = Workbook.createworkbook(fo);

Writetable Sheet ws = wb.create sheet (“Results” ,0);

Label un = new Label (0,0 “username”);

Label pw= new Label (1,0 “password”);

Label rs= new Label (2,0 “Result”);

  1. add cell(un);
  2. add cell(pw);
  3. add cell(rs);


Nested for loop syntax:    

For (int i= 0; I<3; i++)


For (int j= 0; j<2; j++)


Sysem .out.println(j,i);




j      i

0     0

1     0

0     1

1     1

0     2

1     2

Step 2: program

Public class add input data to result File



Public void step 2() throws exception


//1. Print the i/p data on the console

  1. create result file and add provide console output

FileinputStream fi = new FileinputStream(“E:\\workspace_10AM\salenium\\Testdata….”)

Workbook w = workbook. Get workbook(fi);

Sheet S = w.get Sheet(0);

Fileoutput Stream fo = new file output Stream(“E:\\work space _10AM\selenium \\result”)

Create table workbook wb = workbook.create workbook(fo);

Writeable sheet us = wb. Create sheet(“Result”,0);

For(int i=0; i< l.getrow(); i++)


For(int j=0; i< l.getcolumn(); j++)


s.o.p (s.getcell(j,i).getcontent());

Label un = new Label (j,i, s. getcell(j.i).get content());

Ws.add cell(un);



Cabel rs = new label (2,0,”result”);

Ws. Add cell(rs);

Ws. Write();



Check out the top Selenium Interview Questions now!


It is two types

1) implicit time:-it is standard time

2) explicit time:-it means wait until the elements is available

Public void wait(String str)


For(int i=0; i<20; i++)


If(selenium .in element process(str))











How we can use in program:

Public static void method()



Wait(“Link= signout”);


2 iIf we are while loop then signout in not there then it keep out executing infinite times

X2 HOS 2 Admin 2 Admit

Y 2 HOS 2 Admin Advice 2 Admit

Interested to become master in Selenium? Enroll now for FREE demo on Selenium Training in New York City.

Data driver frame work:-

Develop the driver script [data driver frame work] from the scenario login & registration of

2to develop the driver script take the test data and object repository in an Excel file with below format

Public void reusable script() throws exception


Fileinput Stream fi = new fileinput Stream(“E:\\workspace_10AM \\selenium\\”)

Workspace w = workbook.getworkbook(fi);

Sheet s w.get sheet(“sheet1”);

For(int i= 1; i< s.get row(); i++)


If(s.getcell(2,i).get contents().Excelignore case(“textbox”))


If(selenium .inelement present(s.getcell(0,i).get content()))


Selenium .type(s.getcell(0,i).get content(), s.getcontent())


2develop the test data and object repository in a excel file for and run the script by using driver script

àonce the exception is copltted provide the results in an Excel file[resilt file]

Step1:- create an Excel file by using file output stream

Step 2:-Add input data to the result file by using ‘j loop’[ nested for loop’]

Step3:-Add a result column and provide the result as pass or fail based or the execution.

  • Explain about your frame work
  • Main is hybrid frame work.
  • It is a combination of test NG & data driver frame work.
  • We can use both the advantage of data driver &test NG[key board driver]
  • We are using xml file to execute both the test scripts[class].

2 Explain about your Framework?

Hybrid frame work

2 it is a combination if test NG an data driven frame work

2 we can use both the advantages of data driven and Test NG[Key word Driver]

2 we are using XML file to executes both the test script[class]

For an Indepth knowledge on Selenium, click on below

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at, we will update the article in 24 hours.”

0 Responses on Introduction to IO streams /external files in Selenium"

Leave a Message

Your email address will not be published. Required fields are marked *


Please Enter Your Details and Query.
Three + 6