in reply to Spreadsheet::ParseExcel and Dates

Here's some code snippets which will set you on the right track:
use Spreadsheet::ParseExcel::Utility qw(ExcelFmt); ... my $datefmt = 'yyyymmdd'; # ISO 8601 ... if (defined $cell->{Type} && $cell->{Type} eq 'Date') { $value = ExcelFmt($datefmt, $cell->{Val}); }
See Spreadsheet::ParseExcel::Utility for details.

Replies are listed 'Best First'.
Re^2: Spreadsheet::ParseExcel and Dates
by Anonymous Monk on Apr 22, 2019 at 21:07 UTC
    This worked. Thanks!