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.-tp24923291p24939009.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]
