You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Hugo Osorio <os...@gmail.com> on 2007/04/03 17:50:26 UTC
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
RE: empty cells with iterators
Posted by "Karr, David" <da...@wamu.net>.
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:osorio.hugo@gmail.com]
> 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 <da...@wamu.net>:
> >
> > 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:osorio.hugo@gmail.com]
> > > 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: poi-user-unsubscribe@jakarta.apache.org
> > Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> > The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
> >
> >
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
Re: empty cells with iterators
Posted by Hugo Osorio <os...@gmail.com>.
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 <da...@wamu.net>:
>
> 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:osorio.hugo@gmail.com]
> > 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: poi-user-unsubscribe@jakarta.apache.org
> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
>
>
RE: empty cells with iterators
Posted by "Karr, David" <da...@wamu.net>.
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:osorio.hugo@gmail.com]
> 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: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/