poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nick Burch <nick.bu...@alfresco.com>
Subject Re: Timezone used by POI to read date values
Date Thu, 18 Nov 2010 14:21:14 GMT
On Thu, 18 Nov 2010, shruti surulkar wrote:
> When I am using POI to read an excel file, which contains some date 
> values, I am facing a problem where the date index read is not in 
> accordance to the GMT timezone.

Excel files don't store the timezone in them - all dates and times are 
always assumed to be in the timezone of the machine that opens them. POI 
is no different

You might want to take a look at POI classes like DateUtil if you need 
more control

Nick

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


Mime
View raw message