poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nick Burch <nick.bu...@alfresco.com>
Subject Re: date problem
Date Mon, 20 Jun 2011 22:29:15 GMT
On Sat, 18 Jun 2011, hitz wrote:
> I am using apache.poi.hssf.usermodel.HSSF.when i try to read date from excel
> file, it gives numeric value

That's to be expected - excel stores dates as numbers (days since 1900 or 
1904). Use DateUtil to get the date, and DataFormatter to format it as a 
string in the same format as excel

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message