in reply to Spreadsheet::ParseExcel and Date strangeness


I couldn't reproduce this error. Could you confirm that the number format for the cells in Excel is as follows:
d/m/yyyy hh:mm
Or if not could you post the actual format.

Also, which version of Excel and Spreadsheet::ParseExcel are you using.

--
John.

Replies are listed 'Best First'.
Re^2: Spreadsheet::ParseExcel and Date strangeness
by MMX (Initiate) on Jan 07, 2005 at 21:56 UTC
    I'm using Spreadsheet::ParseExcel v0.2603 with ActiveState Perl 5.6, and Excel 2000 (v9.0.2720).

    Edit:
    After some digging I realized I'm actually running ParseExcel 0.2603, not 0.15.

      I've retested it with Excel 2000 and S::PE 0.2603 and I get the same (correct) results.

      So it remains to be verified what is the actual number format that had been specified in Excel. Can you post the format reported be Format->Cells->Number->Category in Excel.

      --
      John.