Tried a couple more things and still got the same results. Furstly, I tried declaring the cell to be numeric and chose one of the default formats from the list; when that cell had nothing in POI reported it as a BLANK. Finally, I tried delaring the cell as type Custom and specifying some arcane accoutning format for the cells contents; still when it was empty, POI reported it as a type BLANK again.
Do not know if that helps at all but I think POI is doing what I would expect. Yours Mark B yehogold wrote: > > But if the TYPE_NUMERIC cell is empty, won't it still be a TYPE_NUMERIC > cell? > > > VK123 wrote: >> >> 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. >> > > -- View this message in context: http://www.nabble.com/The-difference-between-a-blank-TYPE_NUMERIC-cell-and-a-TYPE_NUMERIC-cell-with-0.-tp24923291p24955293.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]
