aspose file tools*
The moose likes JDBC and the fly likes How can we know the date format when we get the data from EXCEL using JXL package Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How can we know the date format when we get the data from EXCEL using JXL package " Watch "How can we know the date format when we get the data from EXCEL using JXL package " New topic
Author

How can we know the date format when we get the data from EXCEL using JXL package

Hareesh Ram Chanchali
Ranch Hand

Joined: Jan 31, 2005
Posts: 110
Hai,

I am using jxl package to get data...
But how should i know the format of data in the date field of Excel sheet
How can i make my code suitable to get date data in many formats

Can anybody help me....


Hareesh Ram Chanchali
SCJP 5.0, IBM Certified Solution Designer
Nitin Jawarkar
Ranch Hand

Joined: Dec 18, 2004
Posts: 79
Hello Hareesh

Why not you try POI package of apache's tomcat hope it will solve you are all problems.
Check it here-

http://jakarta.apache.org/poi/hssf/quick-guide.html#NewSheet



Cheers<br />Nitin
Hareesh Ram Chanchali
Ranch Hand

Joined: Jan 31, 2005
Posts: 110
hai nitin,

I am facing problems while reading ...the data from excel sheet ...
That package is not able to identify the actual date fromat....

Do u feel that POI has this facility in reading different kinds of data
I have seen ur link ..but it is all about writing...hope u got me

any how thanks for reply
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30537
    
150

Hareesh,
Yes, POI can also be used for reading a spreadsheet. Link to the POI homepage from Nitin's link.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How can we know the date format when we get the data from EXCEL using JXL package