You can use TYPE_BLANK to check if the cell is empty. Regards,
Vijayakumar Gowdaman Group Technology & Operations (GTO) Global Markets Deutsche Bank off: 02075456250 Mob:07789773998 yehogold <[email protected]> 11/08/2009 19:35 Please respond to "POI Users List" <[email protected]> To [email protected] cc Subject The difference between a blank TYPE_NUMERIC cell and a TYPE_NUMERIC cell with 0. Hi. I'm trying to test if a specific cell is empty. For TYPE_STRING cells, I can get the cellStringValue and check it against an empty string. getNumericValue(), returns '0' when the cell is empty, making it impossible to differentiate between a truly empty TYPE_NUMERIC cell and one that contains '0'. How can a I check if a cell is truly empty? Thank you in advance for all your help. -- View this message in context: http://www.nabble.com/The-difference-between-a-blank-TYPE_NUMERIC-cell-and-a-TYPE_NUMERIC-cell-with-0.-tp24923291p24923291.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --- This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and delete this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. Please refer to http://www.db.com/en/content/eu_disclosures.htm for additional EU corporate and regulatory disclosures.
