Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

sheet gives me null pointer apache poi

I want to create a file .xls but when I set a value it gives me null pointer. this is my code :

(the file xls is empty at start and I need to create two sheet from the code):

Workbook wb = new HSSFWorkbook();
       Sheet general=wb.createSheet("General"); 
    
    //after this line it gives me null point
                Row row = general.getRow(0);    
                Cell cell = row.getCell(1);   

It seems that "general" is null.Anyone can help me?

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

>Solution :

getRow(0) throws Exception because row-0 does not exist.
you need to create the row in the first place :

Row row = general.createRow(0);
Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading