Just been able to play with some code and found that if the cell is genuinely empty then it will be reported as type BLANK. I only had a couple of cells on the sheet, one had been explicitly set to be numeric, the other text; initially neither had a value and they both reported as BLANK. Next I initialised both and they reported as the correct type and finally, I cleared them both out again and they reverted to being BLANK as far as HSSF was concerned.
The only thing I did not try was setting a format on the cells; whether this has any bearing upon how the code will behave, I cannot guess but will try a little later. 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.-tp24923291p24953106.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]
