Selenium Webdriver Duplicating ExcelSheet

Question

I tried to copy an excel sheet containing 7 colomns named Excel.xls sheet into ExcelCopy.xls , but Getting an Java Null Exception error at @After Test and as am very new to this selenium coding please help me !!

 package TestNG;


import java.io.FileInputStream;
import java.io.FileOutputStream;

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

import org.openqa.selenium.WebDriver;
import org.openqa.selenium.support.ui.WebDriverWait;
import org.testng.annotations.Test;
import org.testng.annotations.BeforeTest;
import org.testng.annotations.AfterTest;

public class DuplicateExcelSheet {
    WebDriver driver;
    WebDriverWait wait;

    Workbook w;
    Sheet s;
    FileInputStream fi;
    FileOutputStream fo;
    WritableWorkbook ww;
    WritableSheet ws;
  @Test
  public void f() throws Exception{
    int colCount=s.getColumns();
    System.out.println(colCount);
    ww=Workbook.createWorkbook(fo, w);
    ws=ww.createSheet("Data", 0);

    for (int i = 0; i < colCount; i++) 
    {
    String s1=s.getCell(i, 0).getContents();
     Label l=new Label(i,0,s1);
     ws.addCell(l);
    }
     }

  @BeforeTest
  public void beforeTest() throws Exception{

      fi=new FileInputStream("E:\\selenium\\Excel.xls");
        w=Workbook.getWorkbook(fi);
        s=w.getSheet(0);
          fo=new FileOutputStream("E:\\selenium\\ExcelCopy.xls");
      }

  @AfterTest
  public void afterTest() throws Exception{
       ww.write();
       w.close();
      fi.close();
      fo.close();


  }

}

@AfterTest afterTest java.lang.NullPointerException at TestNG.DuplicateExcelSheet.afterTest(DuplicateExcelSheet.java:55) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) the error is something like this — rahul bommanaboina
– rahul bommanaboina, Commented May 22, 2015 at 19:27

Saifur · Accepted Answer · 2015-05-25 16:15:14Z

1

I assume you want to copy the full excel workbook. If, so use FileUtil which is much more easier and lot less coding. Good thing is you do not need to worry about the destination directory, files etc. It will also overwrite if the destination exists.

File sourceExcel = new File("D:\\Users\\Saifur\\Desktop\\Delete\\excelFrom\\Selenium.xlsx");
File dstExcel = new File("D:\\Users\\Saifur\\Desktop\\Delete\\excelTo\\Selenium_Copy.xlsx");

try {

    FileUtils.copyFile(sourceExcel, dstExcel);

} catch (IOException e) {

    e.printStackTrace();
}

Make sure you have the following import

import org.apache.commons.io.FileUtils;

Maven repo here

edited May 25, 2015 at 16:15

answered May 25, 2015 at 16:09

Saifur

16.3k7 gold badges51 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Saifur Over a year ago

@rahulbommanaboina Glad it did. Mark the answer as accepted if this is what you have been looking for. See this

timato · Accepted Answer · 2015-05-22 19:38:13Z

0

It looks like you declared FileOutputStream fo as a class member, but you are not assigning it anywhere. So, it is NULL at line 55 when you try to call fo.close()

If fo is not used, I suggest you just remove it from this class.

answered May 22, 2015 at 19:38

timato

1822 silver badges12 bronze badges

5 Comments

rahul bommanaboina Over a year ago

I modified the program using fileOutputStream , still am getting the same error .. !! :(

timato Over a year ago

I suggest putting all the object creation in @BeforeTest

timato Over a year ago

If you're using Eclipse, you can use a debugging breakpoint and watch the state of fo change as the test executes. Notes on breakpoints

rahul bommanaboina Over a year ago

ahh !! its throwing me errors if declare the objects in @ before test, as i used the objects in @Test , and coming to break points am not sure how to use them or check , as am a beginner in selenium and coding .

rahul bommanaboina Over a year ago

i got rid of exception , changed the program little bit, but now , excel sheet has been created , but data dint get copied, can some one please check the program and let me know , why the data has not been copied ??

Collectives™ on Stack Overflow

Selenium Webdriver Duplicating ExcelSheet

2 Answers 2

1 Comment

5 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

5 Comments

Linked

Related