You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Abhinav Srivastava <wr...@gmail.com> on 2006/07/12 02:28:28 UTC
numeric cell type
While reading a XLS using HSSF, cells which contain numbers
are being returned as type NUMERIC. e.g a cell having 2 would have its
value returned as 2.0 (double) and not as "2" as I would like it to.
any help?
Re: numeric cell type
Posted by Daniel Noll <da...@nuix.com.au>.
Abhinav Srivastava wrote:
> While reading a XLS using HSSF, cells which contain numbers
> are being returned as type NUMERIC. e.g a cell having 2 would have its
> value returned as 2.0 (double) and not as "2" as I would like it to.
> any help?
If the value is supposed to be a string, then enter it as a string.
Type '2 instead of 2 into the cell and you'll see what I mean.
Daniel
--
Daniel Noll
Nuix Pty Ltd
Suite 79, 89 Jones St, Ultimo NSW 2007, Australia Ph: +61 2 9280 0699
Web: http://www.nuix.com.au/ Fax: +61 2 9212 6902
This message is intended only for the named recipient. If you are not
the intended recipient you are notified that disclosing, copying,
distributing or taking any action in reliance on the contents of this
message or attachment is strictly prohibited.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/