in reply to Spreadsheet::ParseExcel and Dates
See Spreadsheet::ParseExcel::Utility for details.use Spreadsheet::ParseExcel::Utility qw(ExcelFmt); ... my $datefmt = 'yyyymmdd'; # ISO 8601 ... if (defined $cell->{Type} && $cell->{Type} eq 'Date') { $value = ExcelFmt($datefmt, $cell->{Val}); }
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re^2: Spreadsheet::ParseExcel and Dates
by Anonymous Monk on Apr 22, 2019 at 21:07 UTC |