Write data to excel using Apache POI with TestNG framework

Question

I am trying to write data to excel sheet using Apache POI.I am using TestNG framerwork and eclipse IDE. Program is executing successfully without any error.But when I click refresh on my project source, excel sheet is not coming. Please tell me how will I see my generated excel sheet. My code is as below:

public class Test {
    public static void main(String args[]) {
        try {
            FileOutputStream fos = new FileOutputStream("User.xls");
            HSSFWorkbook workbook = new HSSFWorkbook();
            HSSFSheet worksheet = workbook.createSheet("worksheet");
            HSSFRow row1 = worksheet.createRow((short) 0);
            HSSFCell cell1 = row1.createCell((short) 0);
            cell1.setCellValue("abc");
            HSSFCell cell2 = row1.createCell((short) 1);
            cell2.setCellValue("123");
            workbook.write(fos);
            fos.close();
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}

What path you have given to generate excel sheet? Post some of your code for better understanding. — Sachin
– Sachin, Commented Mar 16, 2013 at 7:59
public class Test{ public static void main(String args[]){ try{FileOutputStream fos=new FileOutputStream("User.xls"); HSSFWorkbook workbook=new HSSFWorkbook(); HSSFSheet worksheet=workbook.createSheet("worksheet"); HSSFRow row1=worksheet.createRow((short)0); HSSFCell cell1=row1.createCell((short)0); cell1.setCellValue("abc"); HSSFCell cell2=row1.createCell((short)1); cell2.setCellValue("123"); workbook.write(fos); fos.close(); } catch (FileNotFoundException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace();}}} — sarmila
– sarmila, Commented Mar 16, 2013 at 8:08

longhua · Accepted Answer · 2013-03-16 09:26:30Z

1

Please check your project's root directory. It should be there by default. If you have specified the working directory in your run configuration -> arguments, you should check that folder. Besides, you can always get the complete file path in Java.

System.out.println(new File("User.xls").getAbsolutePath());

answered Mar 16, 2013 at 9:26

longhua

4,28223 silver badges28 bronze badges

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

Comments

NPKR · Accepted Answer · 2013-03-16 09:27:08Z

1

try this way to create file

FileOutputStream out =
            new FileOutputStream(new File("User.xls"));

This file will be stored in your class directory folder.

Ex: (Test.java is stored in (c://Workspace//src//Test.java) , the file also will store in same path c://Workspace//src//User.xls")

answered Mar 16, 2013 at 9:27

NPKR

5,5165 gold badges35 silver badges48 bronze badges

Collectives™ on Stack Overflow

Write data to excel using Apache POI with TestNG framework

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