poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Avik Sengupta <avik.sengu...@itellix.com>
Subject Re: Number Record
Date Wed, 23 Aug 2006 17:54:13 GMT
the 'default behaviour' is because Excel stores the data in that way..  
ie, numbers are stored as IEEE floats within the excel file.

On load, excel applies the stored cell formatting to the double before  
displaying on screen. If that is your requirement, that is what you  
should do.

Regards
-
Avik


Quoting "Finnerty, Mary Ann (GE Healthcare)" <maryann.finnerty@ge.com>:

> I am using POI to read xls files - no interest in writing them - BUT I
> need to get Number fields as plain text -- exactly as they are input
> into the spreadsheet.
> The default behavior is to read them in and turn them into doubles, but
> I can't do that.
>
> Anyone know how I can get around this?
>
> Thanks!
> Maffy
>
>
> Mary Ann "Maffy" Finnerty
>
> GE Healthcare
>
> Integrated IT
>
> Enterprise Solutions
>
> Sr. Software Engineer
>
>
>
> T 206 607 5612
>
> C 206 419 6784
>
> E Maryann.Finnerty@ge.com
>
> www.gehealthcare.com
>
>
>
> 925 Fourth Avenue, Suite 400
>
> Seattle, WA 98104 USA
>
> -----------
> I would rather be exposed to the inconveniences attending too much
> liberty than to those attending too small a degree of it.
>   - Thomas Jefferson
> <http://www.quotationspage.com/quotes/Thomas_Jefferson>
>
>



----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.


---------------------------------------------------------------------
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/


Mime
View raw message