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 Open Source Projects and the fly likes [$-409]@ what is this symbol am getting from excel ?? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "[$-409]@ what is this symbol am getting from excel ??" Watch "[$-409]@ what is this symbol am getting from excel ??" New topic
Author

[$-409]@ what is this symbol am getting from excel ??

indu yeturu
Ranch Hand

Joined: Aug 27, 2008
Posts: 123
Hi when I try to get Data objects from excel sheet ,am getting date appended with this special sign ?
how to get date alone ???
please.. give me the solution

thanks
indu


thanks,
indu
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41880
    
  63
Post the code you're using and the data you're working with.


Ping & DNS - my free Android networking tools app
indu yeturu
Ranch Hand

Joined: Aug 27, 2008
Posts: 123

Here the datecol[] is the array of string of dates am getting from excel... For eg.., i t display the date as "[$-409]28-Feb-10;@"
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41880
    
  63
Read the javadocs of the jxl.Cell#getContents() method and act accordingly.
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 38881
    
  23
Too difficult for "beginning". Moving thread.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: [$-409]@ what is this symbol am getting from excel ??