File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Other JSE/JEE APIs and the fly likes Apache Excel api Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Other JSE/JEE APIs
Bookmark "Apache Excel api" Watch "Apache Excel api" New topic
Author

Apache Excel api

sandy indira
Greenhorn

Joined: Feb 03, 2010
Posts: 13
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
Marshal

Joined: Mar 22, 2005
Posts: 42919
    
  68
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
Bartender

Joined: Oct 14, 2005
Posts: 18987
    
    8

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 agree. Here's the link: http://aspose.com/file-tools
 
subject: Apache Excel api