Meaningless Drivel is fun!*
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 Android Security Essentials Live Lessons this week in the Android 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: 41124
    
  45
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: 41124
    
  45
Read the javadocs of the jxl.Cell#getContents() method and act accordingly.
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 38033
    
  22
Too difficult for "beginning". Moving thread.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: [$-409]@ what is this symbol am getting from excel ??
 
Similar Threads
How to fetch Date Field from excel sheet in Java
Using JDBC to insert into MS Excel file
what is this symbol "[$-409]dd-mmm-yy;@ " Excel to Java???
Read Excel values and store in to Database
Doubt on '#' in query.