Re: 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
[download]

Or if not could you post the actual format.

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

--
John.

Comment on Re: Spreadsheet::ParseExcel and Date strangeness Download Code

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.	[reply]
Re^3: Spreadsheet::ParseExcel and Date strangeness by jmcnamara (Monsignor) on Jan 10, 2005 at 00:43 UTC
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.	[reply]