How to write on another sheet in excel Java use POI

Question

I would like to write to a cell on sheet 2, but the operation errors and I get this message :

Exception in thread "main" java.lang.NullPointerException at Testnextsheet.Testnextsheet.main(Testnextsheet.java:43)

public static void main(String[] args) throws IOException{
    try{
        FileInputStream files = new FileInputStream(new File("d:\\Materi\\Selenium\\Projects\\Excel\\Book1.xlsx"));
        XSSFWorkbook workbook = new XSSFWorkbook(files);
        //----Sheet 1-------------------------------------//
        XSSFSheet sheet1 = workbook.getSheet("Sheet1");
        //---sheet 2--------------------------------------//
        XSSFSheet sheet2 = workbook.getSheet("Sheet2");

            //-----------write text to sheet 2------------------------//    
            sheet2.getRow(3).getCell(2).setCellValue("Test");


        FileOutputStream fout= new FileOutputStream(new File("d:\\Materi\\Selenium\\Projects\\Excel\\Book1.xlsx"));
        workbook.write(fout);
        workbook.close();
        files.close();
    }
    catch(FileNotFoundException fnfe){
        fnfe.printStackTrace();
    }catch(IOException ioe){
        ioe.printStackTrace();
    }
}

Piyush Upadhyay · Accepted Answer · 2018-03-23 20:45:30Z

2

The sheet2 object,which is a TreeMap is empty in the beginning.You need to create a row, then cell and then set the value, something like below-

sheet2.createRow(2).createCell(1).setCellValue("Test");

In your case,sheet2.getRow(3) will throw NullPointerException.

The suggested way would be to iterate the XSSFWorkbook object to access the XSSFSheet and then create as many row and cell as you want and keep on setting the values.

answered Mar 23, 2018 at 20:45

Piyush Upadhyay

4455 silver badges12 bronze badges

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

2 Comments

Rifki Nurgraha Over a year ago

but i found new problem thas the border in existing will gone

Piyush Upadhyay Over a year ago

Could you please be more specific? if possible share the code snippet too..

Collectives™ on Stack Overflow

How to write on another sheet in excel Java use POI

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related