• 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
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

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.
 
Marshal
Posts: 28263
95
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.
 
I wasn't selected to go to mars. This tiny ad got in ahead of me:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic