NullPointerException in createRow method in HSSFSheet

Question

I am trying to write data in excel.

FileOutputStream oFile = new FileOutputStream(yourFile, false); 
    HSSFWorkbook workbook=new HSSFWorkbook();
    HSSFSheet sheet=workbook.createSheet("Script_ID");
    HSSFRow rowheading =sheet.createRow(0); // throws exceptiom
    rowheading.createCell(0).setCellValue(" XYZ");
    rowheading.createCell(1).setCellValue("ABC");

The same code is working in Selenium but when i am trying the same code in IBM RFT it is throwing NullPointerException in createRow (mentioned above) and it is not creating new Sheet named "Script_ID". So not able to write any data in excel.

Can any one suggest me what is wrong with the code or any simple approach to write the data in excel as i have to iterate the code in 2 column in multiple rows in multiple sheets under the same excel file.

score 0 · Answer 1 · answered Oct 20 '15 at 16:09

0

Have you added the POI libraries to the Customization folder of RFT?

answered Oct 20 '15 at 16:09

Prakash

742
7
19

Yes I have POI 3.7 jar added – monk_507 Oct 22 '15 at 03:25
check if workbook object is null and that is why you have NPE or createSheet internally is running into a NPE. – Prakash Oct 28 '15 at 01:13

NullPointerException in createRow method in HSSFSheet

1 Answers1