in reply to Spreadsheet::XLSX date problem

From Excel|help:

Microsoft Excel stores dates as sequential numbers known as serial values. Excel stores times as decimal fractions because time is considered a portion of a day.... You can view a date as a serial value and a time as a decimal fraction by changing the format of the cell that contains the date or time to General format.
Excel supports two date systems: the 1900 and 1904 date systems. The default date system for Microsoft Excel for Windows is 1900. To change to the 1904 date system, click Options on the Tools menu, click the Calculation tab, and then select the 1904 date system check box.

The 1904 version is the default, IIRC, for Excel on Apple's OSen (or most of them).

Replies are listed 'Best First'.
Re^2: Spreadsheet::XLSX date problem
by Anonymous Monk on Jul 31, 2011 at 18:57 UTC
    This is good general information on Microsoft Excel date formats, but it's worthless for this particular problem. The scant documentation provided by the author of Spreadsheet::XLSX is the issue here. The PerlMonks definitely failed on this one.
[reply]

In Section Seekers of Perl Wisdom