This queue is for tickets about the Spreadsheet-XLSX CPAN distribution.

Report information
The Basics
Id:
87746
Status:
open
Priority:
Low/Low

People
Owner:
mikeb [...] cpan.org
Requestors:
lpenninger [...] clinipace.com
Cc:
AdminCc:



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.

From: chris_jack@msn.com
Try using $cell->{_Value} and look for a non-numeric (or well defined date) format. Note the underscore. Regards Chris


This service runs on Request Tracker, is sponsored by The Perl Foundation, and maintained by Best Practical Solutions.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.