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>
