Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

PRoblem in reading numeric data as String from excel files

 
nick sharma
Greenhorn
Posts: 28
  • 0
  • 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: 42966
73
  • 0
  • 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.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic