Data retriving and Data writing using Jxl jar file in selenium

Test Automation 0 Comment 53

 Jxl is available as jar file. It  is the most widely used API for executing Selenium data-driven tests, which allows users to read, write, create, and modify sheets in an Excel(.xls) workbook at runtime. It is useful to access .xls file only.

Features:

  • Reads data from Excel 95, 97, 2000, XP, and 2003 workbooks
  • Reads and writes formulas (Excel 97 and later only)
  • Generates spreadsheets in Excel 2000 format
  • Supports font, number and date formatting
  • Supports shading, bordering, and coloring of cells
  • Modifies existing worksheets
  • Is internationalized, enabling processing in almost any locale, country, language, or character encoding (formulas are currently only supported in English, French, Spanish, and German, but more can be added if translated)
  • Supports copying of charts
  • Supports insertion and copying of images into spreadsheets
  • Supports logging with Jakarta Commons Logging, log4j, JDK 1.4 Logger, etc

 

How to download and configure  Jxl jar file with eclipse IDE

Download jxl Zip file from java2s.com.( click here jxl.zip (57KB)).

Extract files from zip file and save in a folder.

Now launch Eclipse IDE and go to the project.

Right click on project—>go to properties—>java buildpath—>libraries—>add external  libraries–>browse jxl jar file.

Example:

.xls sheet

0th row Input 1 Input 2  Output
1st row XX  XX
2nd row XX  XX
3rd row XX  XX
4th row XX  XX
5th row XX  XX
6th row XX  XX

Output= Input 1+Input 2

From above table we have to read data (Input 1,2) and write the output in the same sheet with the help of jxl in selenium.

Example

public class Jxl {

public static void main (String[] args) throws JXLException, IOException
{

File f =new File(“E:\\Yamini\\xl\\xx.xls”);

Workbook rwb = Workbook.getWorkbook(f);
Sheet rsh = rwb.getSheet(0);
int nor = rsh.getRows();
WritableWorkbook wwb = Workbook.createWorkbook(f, rwb);
WritableSheet wsh = wwb.getSheet(0);
for (int i=1;i<nor;i++)
{
int x = Integer.parseInt(rsh.getCell(0 ,i).getContents());
int y= Integer.parseInt(rsh.getCell(1, i).getContents());
int z=x+y;
Number n =new Number (2,i,z);
wsh.addCell(n);

}
wwb.write();
wwb.close();
rwb.close();
}
}

Author

Leave a comment

You must be logged in to post a comment.

© 2016 4frienz. Powered By Flowers

Back to Top