[prev in list] [next in list] [prev in thread] [next in thread] 

List:       poi-user
Subject:    Re: question about HSSF: reading integer values
From:       "Andrew C. Oliver" <acoliver () apache ! org>
Date:       2002-09-13 17:43:01
[Download RAW message or body]

POI is returning a double value.  With this value use
java.text.NumberFormat (and friends) to format it to your liking.

-Andy

On Fri, 2002-09-13 at 10:51, Reiter, Marcus wrote:
> Hello everybody,
> 
> as I'm working with the jakarta-POI -- the 
> HSSF-classes to read and write excel-files --
> I encountered the following problem:
> When reading numbers from excel-files, I always
> get double-values, but never integer values, e.g.:
> 
> Excel        HSSF cell-entry
> 
> 40      -->  40.0
> 40.0    -->  40.0
> 
> 
> Sometimes its very important in our project to know,
> wether it was an integer or not! Is it possible to get
> integer values? It would be enough if I'd get a
> string like "40".
> What would be possiblities?!
> 
> Thanks a lot for answer,
> Marcus 
> 
> 
> 
> 
> --
> To unsubscribe, e-mail:   <mailto:poi-user-unsubscribe@jakarta.apache.org>
> For additional commands, e-mail: <mailto:poi-user-help@jakarta.apache.org>
> 
-- 
http://www.superlinksoftware.com - software solutions for business
http://jakarta.apache.org/poi - Excel/Word/OLE 2 Compound Document in
Java                            
http://krysalis.sourceforge.net/centipede - the best build/project
structure
		    a guy/gal could have! - Make Ant simple on complex Projects!
The avalanche has already started. It is too late for the pebbles to
vote.
-Ambassador Kosh


--
To unsubscribe, e-mail:   <mailto:poi-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:poi-user-help@jakarta.apache.org>

[prev in list] [next in list] [prev in thread] [next in thread]