Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Hareesh Ram Chanchali
Ranch Hand
Posts: 110
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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....
 
Nitin Jawarkar
Ranch Hand
Posts: 79
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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

 
Hareesh Ram Chanchali
Ranch Hand
Posts: 110
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
author & internet detective
Marshal
Posts: 34371
345
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hareesh,
Yes, POI can also be used for reading a spreadsheet. Link to the POI homepage from Nitin's link.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic