| 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
Show quoted text
________________________________
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.