How do you know the cell is blank?  Because you're going by the
row/column number you think you're looking at?  Remember that the
row/column numbers are 0-based, not 1-based.  Because of issues like
this, I like to have a "dumpCellData" method that goes through every row
and column, printing out the row/column numbers, the cell type, and the
string value of the cell. 

> -----Original Message-----
> From: Hugo Osorio [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, April 03, 2007 12:48 PM
> To: POI Users List
> Subject: Re: empty cells with iterators
> 
> thank you, i have used this field, but, the cell seems not to 
> be blank, but it still appears to have data despite it is empty...
> 
> 
> 2007/4/3, Karr, David <[EMAIL PROTECTED]>:
> >
> > Perhaps you're looking to check whether the cell type is "blank".  
> > Once you have a HSSFCell object, call "getCellType()" and 
> compare it 
> > against "HSSFCell.CELL_TYPE_BLANK".
> >
> > > -----Original Message-----
> > > From: Hugo Osorio [mailto:[EMAIL PROTECTED]
> > > Sent: Tuesday, April 03, 2007 8:50 AM
> > > To: poi-user@jakarta.apache.org
> > > Subject: empty cells with iterators
> > >
> > > Hello,
> > >
> > > How can i ask in the statement while(cellsIterator.hasNext()) AND 
> > > (some cell is not empty) since this cell is my control for 
> > > registering
> > >
> > >
> > > thank you
> > >
> >
> > 
> ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
> > The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
> >
> >
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/

Reply via email to