• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Jeanne Boyarsky
  • Ron McLeod
Sheriffs:
  • Paul Clapham
  • Liutauras Vilda
  • Devaka Cooray
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

Apache Excel api

 
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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...
 
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Sheriff
Posts: 28371
99
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Stinging nettles are edible. But I really want to see you try to eat this tiny ad:
Smokeless wood heat with a rocket mass heater
https://woodheat.net
reply
    Bookmark Topic Watch Topic
  • New Topic