parse Excel number which represents a date

fionbarr has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: parse Excel number which represents a date by Corion (Patriarch) on Aug 28, 2015 at 13:59 UTC
That is how Excel represents dates. See Spreadsheet::ParseExcel for the routines that convert from numbers to formatted strings or just use the formatted value instead of the raw value. Maybe also consider Spreadsheet::ParseXLSX, which is more recent.	[reply]
Re^2: parse Excel number which represents a date by fionbarr (Friar) on Aug 28, 2015 at 15:45 UTC
Success with 'Spreadsheet::ParseXLSX'. Thanks to Corion and others who suggested possibilities.	[reply]
Re: parse Excel number which represents a date by tangent (Parson) on Aug 28, 2015 at 15:13 UTC
How are you getting the value of the cell? If you use: `$cell->{Val}` [download] then you will get the unformatted value, but if you use: `$cell->value()` [download] you should get the formatted value	[reply] [d/l] [select]
Re: parse Excel number which represents a date by MidLifeXis (Monsignor) on Aug 28, 2015 at 14:37 UTC
See also CPAN. --MidLifeXis	[reply]
Re: parse Excel number which represents a date by fionbarr (Friar) on Aug 28, 2015 at 14:01 UTC
more info: the date is '1/14/2016' which is represented by the number '42387'	[reply]


Come for the quick hacks, stay for the epiphanies.
	PerlMonks