How to get cell format of xls

bimleshsharma has asked for the wisdom of the Perl Monks concerning the following question:

I am getting format of cell but i am unknown about the actual properties. Because i have to use same format for other cell if bg_color=red. I am using code below to get format..

# Get the format from the cell
    my $format   = $template->{Worksheet}[$sheet]
                            ->{Cells}[$row][$col]
                            ->{FormatNo};
[download]

Comment on How to get cell format of xls Download Code

Replies are listed 'Best First'.
Re: How to get cell format of xls by moritz (Cardinal) on May 23, 2012 at 07:11 UTC
What module are you using? What problem are you trying to solve? What's your question? Did you read the module's documentation on formats? Perl 6 - the future is here, just unevenly distributed	[reply]
Re: How to get cell format of xls by bimleshsharma (Beadle) on May 23, 2012 at 09:43 UTC
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.	[reply] [d/l]
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
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]