Re: Getting Java dates from files using 1904 date windowing...

[Andrew C. Oliver]

Great... please submit patches when you figure it out. (and don't forget to add the @author tag)

Dan Sherman wrote:

Thanks! Yes, BiffViewer does confirm that the Mac Excel v.X files are
using 1904 date windowing (@#!@#!@##@!). It also shows me how I can
figure it out in my own code. Very cool!! Now the algorithm for 1904
dates....

Thanks again!

Dan

Hummmm... Use BiffViewer to confirm the files use 1904 date windowing (there is a record called 1904 something or other).. Anyone on the dev lisk know anything about the algorythm for 1904 dates???
-Andy

Dan Sherman wrote:

Hi!

I have code that will be used to read Excel files saved on both the PC
(Office 97 and 2000) and the Mac (Office v.X). I am having a problem
converting the Excel date representation to the correct Java date
representation with the files saved on the Mac. I'm guessing that Excel
on the Mac is saving dates using 1904 windowing. The HSSFDateUtil class
assumes 1900-based dates, so returns the incorect Java date. For example:

<snip>

--
To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org>

--
To unsubscribe, e-mail:   <mailto:poi-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org>