• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Apache Excel api

 
sandy indira
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hello friends,

i was using apache excel api for reading the data from the excel sheets..

but there is a problem with that, its unable to read the numbers from it,
that is, there were some mobile numbers which were to be fetched from the
excel sheet but it has some problem in that..

for example if excel sheet has number 75578945639 then it will read as 7.557894563E9.

i have tried to format the excel sheet by putting these colums as number, general, text...but still i am facing the same problem..

please suggest me some thing 2 proceed with..

is it because of the excel api or there is some other format in which these columns with mobile numbers should be saved..


help friends...
 
Ulf Dittmer
Rancher
Posts: 42968
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please check your private messages by clicking on the "My Private Messages" link at the top of the page. Your account is about to be closed.
 
Paul Clapham
Sheriff
Posts: 21416
33
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
sandy indiranagar wrote:is it because of the excel api or there is some other format in which these columns with mobile numbers should be saved..


No, it's nothing to do with the API or the data format. It's all to do with the way that your code displays those numbers. You could use a DecimalFormat object to specify how to display it, or a Formatter, or the System.out.format() method. It's up to you.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic