aspose file tools*
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
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
Marshal

Joined: Mar 22, 2005
Posts: 42632
    
  65
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.


Ping & DNS - my free Android networking tools app
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: PRoblem in reading numeric data as String from excel files