Re: Spreadsheet::XLSX date format problem

Don't use ->{Val}. It contains the unformatted value. Use ->value() to get the formatted value.

Comment on Re: Spreadsheet::XLSX date format problem Select or Download Code

Replies are listed 'Best First'.
Re^2: Spreadsheet::XLSX date format problem by Anonymous Monk on Jul 11, 2014 at 14:47 UTC
I tried that an it still gave me the wrong format: `my $date_xlsx = $sheet->{Cells}[$row][1]->value(); print result: 41570` [download]	[reply] [d/l]