Skip to Main Content

New to Java

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

HSSFCell.CELL_TYPE_BLANK problem in reading excel sheet

807601Feb 4 2008 — edited Sep 10 2008
Hi ,
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 8 2008
Added on Feb 4 2008
27 comments
1,603 views