Subject: | Spreadsheet::XLSX reading dates as numbers |
Date: | Fri, 9 Aug 2013 16:44:13 +0000 |
To: | "bug-Spreadsheet-XLSX@rt.cpan.org" <bug-Spreadsheet-XLSX@rt.cpan.org> |
From: | Lisa Penninger <lpenninger@clinipace.com> |
Hi, I'm having a problem with dates in certain spreadsheets being read as numbers. If you look at the attached spreadsheet in Excel, the dates are correctly formatted. If you read it with test.pl, the cell type is returned as 'Numeric'. There is no
way that I'm aware of for my code to correctly determine that these are dates. Here is my output from running test.pl:
perl test.pl
Text
Milestones
Text
Target/ Actual (T/A)
Text
Date
Text
Contract Signed
Numeric
41510
Text
Estimated Project Start
Numeric
41511
Text
Estimated Project End
Thanks for any help.
Lisa
IMPORTANT: This email message is intended solely for the individual or individuals to whom it is addressed. It may contain confidential or privileged information. If the reader of this message is not the intended recipient, you are requested not to read, copy or distribute it or any of the information it contains. Please delete it immediately and notify us by return e-mail or by telephone at +1 919 224 8800.
Message body is not shown because sender requested not to inline it.
Message body is not shown because sender requested not to inline it.
Message body not shown because it is not plain text.
Message body is not shown because sender requested not to inline it.