Write Multiple data in different excel cells using selenium webdriver

Question

In the following code i want to pass two data in two different cells. (Cell 1 and Cell 2).But its only showing data for cell 1.Someone please help.

import java.io.FileOutputStream;
import java.util.concurrent.TimeUnit;

import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;

import org.junit.After;
import org.junit.Before;
import org.junit.Test;
import org.openqa.selenium.By;
import org.openqa.selenium.Keys;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.firefox.FirefoxDriver;
public class xl {
private WebDriver driver;
@Before
public void setUp() throws Exception {
driver = new FirefoxDriver();
driver.manage().timeouts().implicitlyWait(30, TimeUnit.SECONDS);
}

@Test
public void test() throws Exception {
driver.get("http://www.google.com/");
String s = driver.getTitle();
writereport(0,0,s);
writereport(1,1,"Valid");
}

@After
public void tearDown() throws Exception {
driver.quit();
}



public void writereport(int a,int b,String text) 
   { 
    try
    {
   FileOutputStream f = new FileOutputStream("C:\\DEMO.xls",true);
   WritableWorkbook book = Workbook.createWorkbook(f); 
   WritableSheet sheet = book.createSheet("TESTRESULTS",0);
   Label i = new Label(a, b, text);
   sheet.addCell(i);
   book.write(); 
   book.close(); 
    }
    catch (Exception e)
    {
     e.printStackTrace();
    }
   }}

I have tried Label i = new Label(a, b, text); sheet.addCell(i); Label P = new Label(a, b, text); sheet.addCell(p); But No luck

Marielle · Accepted Answer · 2013-10-29 00:03:12Z

The second time you call writereport, you are trying to create a workbook that already exists. This fails.

To write to an existing workbook with jxl, you need to make a copy of that workbook first.

    public void writereport(int a, int b, String text) {
    try {
        File excelFile = new File("D:\\DEMO.xls");

        WritableWorkbook book;
        WritableSheet sheet;
        Workbook existingBook = null;

        if (!excelFile.exists()) {
            book = Workbook.createWorkbook(excelFile);
            sheet = book.createSheet("TESTRESULTS", 0);
        } else {
            existingBook = Workbook.getWorkbook(excelFile);
            book = Workbook.createWorkbook(excelFile, existingBook);
            sheet = book.getSheet("TESTRESULTS");
        }

        Label i = new Label(a, b, text);
        sheet.addCell(i);
        book.write();
        book.close();

        if (existingBook != null)
            existingBook.close();
    } catch (Exception e) {
        e.printStackTrace();
    }
}

(This is not a selenium issue by the way).

CloudyMarble · Accepted Answer · 2013-12-10 06:11:53Z

0

Write result in Existing excel sheet using selenium webdriver. User this method in your code method. like

writeresultinexcel(3, i, "Pass");

or

writeresultinexcel(3, i, "Fail");



public void writeresultinexcel(int row, int col, String result) throws Exception{

try {

File fl = new File("excelpath");

WritableWorkbook wwb;

WritableSheet wsht;

Workbook existingbook=null;

if(!fl.exists()){

wwb=Workbook.createWorkbook(fl);

wsht=wwb.getSheet("excelpath");

}

else {

existingbook=Workbook.getWorkbook(fl);

wwb=Workbook.createWorkbook(fl,existingbook);

wsht=wwb.getSheet(0);

}

Label lbl=new Label(row, col, result);

wsht.addCell(lbl);

wwb.write();

wwb.close();

if(existingbook!=null){

existingbook.close();

}

} 

catch (Exception e) {

        }
    }

edited Dec 10, 2013 at 6:11

CloudyMarble

37.7k70 gold badges103 silver badges133 bronze badges

answered Dec 10, 2013 at 5:44

Rajesh S. Upase

16

Collectives™ on Stack Overflow

Write Multiple data in different excel cells using selenium webdriver

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related