Re: How to get cell format of xls

i am using module as below

use Spreadsheet::ParseExcel::SaveParser;
my $template = $parser->Parse('compare_reports/38_HMI1071_cre_cdo_G.xl
+s');
    # Get the format from the cell
    my $worksheet = $template->worksheet($sheet);
my $val=$worksheet->get_cell($row,$col)->value()
[download]

I am getting error (Can't call method "value" on an undefined value at)when cell($row,$col) is blank. How to handle blank cell. pls help.

Comment on Re: How to get cell format of xls Download Code

Replies are listed 'Best First'.
Re^2: How to get cell format of xls by moritz (Cardinal) on May 23, 2012 at 09:49 UTC
Use an `if` statement to only call ->value() if the return value from get_cell is defined. See also: perlintro. Perl 6 - the future is here, just unevenly distributed	[reply] [d/l]
Re^3: How to get cell format of xls by bimleshsharma (Beadle) on May 23, 2012 at 10:06 UTC
Ok, i used below but getting error... `if(undef $worksheet->get_cell($row,$col)){ next; }` [download] error now i am getting:"Can't modify non-lvalue subroutine call at ."	[reply] [d/l]
Re^4: How to get cell format of xls by moritz (Cardinal) on May 23, 2012 at 10:09 UTC
That's because you used undef, not defined. Perl 6 - the future is here, just unevenly distributed	[reply]
Re^2: How to get cell format of xls by Corion (Patriarch) on May 23, 2012 at 09:49 UTC
Have you tried not calling `->value` when `->get_cell()` returns `undef`? What happened when you tried it?	[reply] [d/l] [select]