Murali Krishna wrote:

Hi Amol,

(You can infer the correct type based on whether the string parses to a number 
etc)
how exactly can i do that, if the string verybig, which cann't fit even in 
double.

Obviously if it can't fit in a double, it isn't a double. If you parse a string into a number, you will probably lose precision anyway.

But Excel isn't precise anyway:

A1 = 10 ^ 60   = 1E+60
A2 = A1 + 1    = 1E+60
A3 = A2 - A1   = 0

For instance, if you're intending to use Excel to store large currency figures, for instance, think again. It's not reliable for that.

Daniel

--
Daniel Noll

NUIX Pty Ltd
Level 8, 143 York Street, Sydney 2000
Phone: (02) 9283 9010
Fax:   (02) 9283 9020

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: [EMAIL PROTECTED]
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/

Reply via email to