This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Customer Requirements for Developers and have Marcho Behler on-line!
See this thread for details.
The moose likes Other Open Source Projects and the fly likes PRoblem in reading numeric data as String from excel files Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Customer Requirements for Developers this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "PRoblem in reading numeric data as String from excel files" Watch "PRoblem in reading numeric data as String from excel files" New topic
Author

PRoblem in reading numeric data as String from excel files

nick sharma
Greenhorn

Joined: May 05, 2008
Posts: 28
Hi
I am using Apache POI to read from excel files,the problem i am facing is that when i store a contact number in a cell,i am unable to read it as a string and store it,if i try to convert it into string using the String.valueOf() method it converts into the proper scientific form.

Can anybody suggest a way to go around this???
Ulf Dittmer
Rancher

Joined: Mar 22, 2005
Posts: 42956
    
  73
Are you specifically setting the cell type to string? I think the default is numeric, in which case effects like the one you describe are to be expected.
 
wood burning stoves
 
subject: PRoblem in reading numeric data as String from excel files
 
It's not a secret anymore!