How to write in cell in excel using apache POI in JAVA?

Question

How to write into excel file to the particular cell.I have a method which accepts file location and row number to which i have to write into it.

What i tried is read the file then created a cell and set the value into it, but when i look into it the cell is still blank.

    public void writeInExcelRowCell(String file , int rowNum) throws Exception {
        FileInputStream excelFile = new FileInputStream(new File(file));
        Workbook workbook = new XSSFWorkbook(excelFile);

        Sheet sheet = workbook.getSheetAt(0);
        sheet.getRow(rowNum).createCell(2).setCellValue("DONE");
        sheet.getRow(rowNum).createCell(3).setCellValue("PENDING");
        workbook.close();        
        
    }

Sam · Accepted Answer · 2020-11-01 16:52:59Z

3

What you did is right, but have forgot to write your changes. You need to open an Outputstream to write those changes.

    FileOutputStream outputStream = new FileOutputStream("yourfile");
    workbook.write(outputStream);
    workbook.close();
    outputStream.close();

Hope this works!!

answered Nov 1, 2020 at 16:52

Sam

6321 gold badge5 silver badges11 bronze badges

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

4 Comments

Aleksandr Erokhin Over a year ago

Please note that you should always close resources in a finally block.

Sam Over a year ago

Yes forgot to mention that. Use finally or try-with-resources to close these stream. Thanks for that @AleksandrErokhin

Akhi21 Over a year ago

@Sam i just had a question what if the cell has already some value will it override it?

Sam Over a year ago

Yes. I hope so.

Collectives™ on Stack Overflow

How to write in cell in excel using apache POI in JAVA?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related