This week's book giveaways are in the Refactoring and Agile forums.
We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line!
See this thread and this one for details.
Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

PRoblem in reading numeric data as String from excel files

 
nick sharma
Greenhorn
Posts: 28
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic