Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

I want to read datas from excel sheet  RSS feed

 
Anil Verghese
Ranch Hand
Posts: 155
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I want to know how to read data's from the excel sheet. I tried using POI api but it is returning date in this format Sat Oct 25 00:00:00 GMT+05:30 2008.
Can anyone ggive me a sample code for the same.

Regards
Anil
 
Joe Ess
Bartender
Posts: 9406
12
Linux Mac OS X Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
So what you really want to know is how to format the date?
Look at: java.text.SimpleDateFormatter
If POI is giving you a String rather than a Date, you'd need two instances of SimpleDateFormat, one to parse the String, the second to format the date the way you want it.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!