Hi
I had a question regarding POI.
I have a cell in an Excel sheet that may or may not be empty. I am currently
using the following to see if a cell is empty or not:
if(cell.getCellType() != HSSFCell.CELL_TYPE_BLANK ) //is the cell empty?, if
not, execute the code below
{
the cell has contents, do some stuff
}
When I highlight the cell and use Edit->Clear->All, the cell is empty, and the
code in the brackets isnt executed.
However, if I only clear it by using the <delete> key, the cell contents
appear to be empty, but the cell itself is not empty, so the code is
executed.
Is there another method that I can use to determine if a cell has nothing
inside it?
Thanks
Joe
---------------------------------------------------------------------
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/
