Ok sorry, just seen cell.getCellType() == HSSFCell.CELL_TYPE_BLANK Thanks, Fabio.
-----Messaggio originale----- Da: fabio campardo [mailto:[EMAIL PROTECTED] Inviato: gioved� 17 febbraio 2005 20.16 A: [email protected] Oggetto: Blank Numeric Cells Hi there! I am new in the mailing list. I have to read an Excel SpreadSheet where the cells can be blank, or have a value, like 0. The problem is that I have to treat in different ways the blank value and the 0 value. Sometimes HSSFRow.getCell() method returns null when the cell is blank, so I can take null as a blank value and sometimes it returns a HSSFCell with 0 for the getNumericCellValue() and null for the getStringCellValue() even if the cell is empty. The problem is: How can I tell when the cell is empty or when it contains 0? Or is there any way to force Excel (somewhere in the excel settings..) to return always a null HSSFCell when the cell is empty? Thanks, Fabio. ___________________________________ Nuovo Yahoo! Messenger: E' molto pi� divertente: Audibles, Avatar, Webcam, Giochi, Rubrica� Scaricalo ora! http://it.messenger.yahoo.it --------------------------------------------------------------------- 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/ ___________________________________ Nuovo Yahoo! Messenger: E' molto pi� divertente: Audibles, Avatar, Webcam, Giochi, Rubrica� Scaricalo ora! http://it.messenger.yahoo.it --------------------------------------------------------------------- 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/
