| 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: 26496
|
|
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
|
|
 |
|
|
subject: How can we know the date format when we get the data from EXCEL using JXL package
|
|
|
0
