RE: Reading excel file with blanks

[Swati, Singhal (IE10)]

ok,
I am reading an excel file, but everytime it encounters a blank cell, it
returns null.

Please see the code below: I check if cell if null & try setting the cell
type to a String with a null string value.
But it throws a nullPointer exception.
Please help!!

for(int j=0;j<maxColumnSize;j++)
{
        HSSFCell cell = row.getCell((short)j);
        if(cell==null)
        {
                System.out.println("Cell Value is Null");       
        //      cell.setCellType(cell.CELL_TYPE_STRING);
        //      cell.setCellValue("");
                System.out.println("Cell VALUE:"+cell.getStringCellValue());
        //      dataArrList.add(cell.getStringCellValue());

        }       
        else
        {
                cell_type = cell.getCellType();
                switch(cell_type)
                {
                        case 0: double dDataValue =
cell.getNumericCellValue();
                                  Double dblVal = new Double(dDataValue);
                                  String dsValue = dblVal.toString();
                                  dataArrList.add(dsValue);
                                  break;
                                        
                        case 1: String sDataValue =
cell.getStringCellValue();
                                  dataArrList.add(sDataValue);
                                  break;
        

                        case 3: System.out.println("Cell is BLANK with
Value:"+cell.CELL_TYPE_BLANK);          
                                  String blnkValue =
cell.getStringCellValue();
        
System.out.println("blnkValue:"+blnkValue);
                                  if(blnkValue==null)
                                  {
                                                System.out.println("Cell
Value is Null");        
        
cell.setCellType(cell.CELL_TYPE_STRING);
cell.setCellValue("");
                                                System.out.println("blank
value:"+blnkValue);
                                                dataArrList.add(blnkValue);

                                }       
                                break;
                                                
                        case 4:boolean bDataValue =
cell.getBooleanCellValue();
                                 Boolean boolVal = new Boolean(bDataValue);
                                 String bValue = boolVal.toString();
                                 dataArrList.add(bValue);
                                 break;         
                }                                  
        }       
}



-----Original Message-----
From: Swati, Singhal (IE10) 
Sent: Wednesday, October 15, 2003 6:40 PM
To: '[EMAIL PROTECTED]'
Subject: Reading excel file with blanks
Importance: High


Hi,

I am using POI in one of my projects.

I am having trouble reading an excel file which contains some blank cells.
Has anyone ever read an excel file which may contain few blank cells??
How do we fix that??

Please help!!

Thanks

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]