Skip Menu |
 
rt.cpan.org will be shut down on March 1st, 2021.

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

Report information
The Basics
Id: 87746
Status: open
Priority: 0/
Queue: Spreadsheet-XLSX

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

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



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>
Download (untitled) / with headers
text/plain 1018b
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.
Download test.pl
text/x-perl 544b

Message body is not shown because sender requested not to inline it.

Download ATT00001.htm
text/html 216b

Message body is not shown because sender requested not to inline it.

Download report.xlsx
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet 9.3k

Message body not shown because it is not plain text.

Download ATT00002.htm
text/html 205b

Message body is not shown because sender requested not to inline it.

From: chris_jack [...] msn.com
Download (untitled) / with headers
text/plain 119b
Try using $cell->{_Value} and look for a non-numeric (or well defined date) format. Note the underscore. Regards Chris


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

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