aspose file tools*
The moose likes Other JSE/JEE APIs and the fly likes How to read a Date column from an Excel sheet using Apache POI Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Java » Other JSE/JEE APIs
Bookmark "How to read a Date column from an Excel sheet using Apache POI" Watch "How to read a Date column from an Excel sheet using Apache POI" New topic
Author

How to read a Date column from an Excel sheet using Apache POI

GNS GNS
Greenhorn

Joined: Jun 21, 2006
Posts: 1
Hi,

I have an excel sheet which has a Date column whose cell type is custom d-mmm-yy.
When i read this excel using apache POI then this column gets read as a numeric cell and returns the big decimal value.

Is there any way of identifying the cell type to be Date for this custom format?

thanks,
GNS
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42286
    
  64
Hello "GNS GNS"-

Welcome to JavaRanch.

On your way in you may have missed that JavaRanch has a policy on display names, and yours does not comply with it; specifically, a first name and a last name are required. Please adjust it accordingly, which you can do right here. Thanks for your prompt attention to this matter.


Ping & DNS - my free Android networking tools app
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to read a Date column from an Excel sheet using Apache POI