HSSFCell.CELL_TYPE_BLANK problem in reading excel sheet
807601Feb 4 2008 — edited Sep 10 2008Hi ,
I have code which is reading an excel sheet. As long as all the colums have values it is reading properly but once once of the fields has a missing cell it doesnt work,
E.g.
My excel sheet has following fields:
First Name | Last Name | Group Name | Mobile number
xzsdf | dsfsdfsdf | fdfgfgfgfgfg | 8957854895
dfgdfgdfg | fgfgfgsfarw | fgdfgew3ertd | 9898989895
now if i have the group name missing in once of the rows it is not working.
Basically i am reading all the cell values into an ArrayList and in case
HSSFCell.CELL_TYPE_BLANK is true then i add a "1" into the ArrayList
But it does not check for HSSFCell.CELL_TYPE_BLANK at all because in that loop the System.out.println statements are not running.
Please help me with this problem.