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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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: 41085
    
  43
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: 41085
    
  43
Read the javadocs of the jxl.Cell#getContents() method and act accordingly.
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 37950
    
  22
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 ??
 
Similar Threads
Using JDBC to insert into MS Excel file
what is this symbol "[$-409]dd-mmm-yy;@ " Excel to Java???
How to fetch Date Field from excel sheet in Java
Read Excel values and store in to Database
Doubt on '#' in query.