This week's book giveaway is in the JavaFX forum.
We're giving away four copies of Introducing JavaFX 8 Programming and have Herbert Schildt on-line!
See this thread for details.
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 Introducing JavaFX 8 Programming this week in the JavaFX 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
Rancher

Joined: Mar 22, 2005
Posts: 42958
    
  73
Post the code you're using and the data you're working with.
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
Rancher

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

Joined: Oct 13, 2005
Posts: 44449
    
  34
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 ??
 
It's not a secret anymore!