get date value from excel using poi

the date is store as double value in excel.

If we get numeric number directly, it would return some odd number nobody understands.

so If you know which cell i.e. column position say 0 in each row is going to be a date, you can go forrow.getCell(0).getDateCellValue() directly.
http://poi.apache.org/apidocs/org/apache/poi/hssf/usermodel/HSSFCell.html#getDateCellValue()

Advertisements

2 comments

  1. Vineeth · April 10, 2013

    How to convert this date to mm/dd/yyyy format?

    • LEON · April 10, 2013

      Here you get a java date object, you can do whatever transformation to it.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s