[SOLVED] perl problem with Spreadsheet::XLSX::Utility2007

qrange · 10-31-2011, 05:23 AM

there is a problem with ExcelFmt() subroutine. when I try this:

Code:

print ExcelFmt('hh:mm', $time), "\n";

to get time in hour:minute format, it fails if time is 12:00 AM, with error:

Code:

Use of uninitialized value $dObj in int at /usr/share/perl5/Spreadsheet/XLSX/Utility2007.pm line 775.
Use of uninitialized value $dObj in subtraction (-) at /usr/share/perl5/Spreadsheet/XLSX/Utility2007.pm line 776.

what to do?
thanks.

qrange · 10-31-2011, 08:34 AM

this has been solved. problem was that 12:00 AM is stored in excel cell as 0. (excel seems to store time as percentage of day). but for some reason, perl module returned that value as NULL. so I used:

Code:

my $time = 0;  
$time=$Cell->{Val} if( $Cell->Value );