Spreadsheet::ParseExcel $cell->value() returning undef

Question

I am new to perl and having trouble with the spreadsheet excel parser module.

WHen I use $cell->value() on its own line, there appears to be no problem, however when I try to use this to insert the value into an array, it returns undef, code show below:

for my $row ($row_min .. $row_max) {
    my @line;
        for my $col ( $col_min .. $col_max) {
                my $cell = $worksheet->get_cell( $row, $col );
                $value = $cell->value;
                push @line, $value if defined($cell);
                print $cell->value;
                print Dumper $line;
                }

         }
}

Here print $cell->value; returns the contents of the cell but print Dumper $line; returns undef

Yes! Thanks, I was using Dumper incorrectly and the getvalue was actually working. Thanks for the help. — James Jiimmy, Jun 03 '15 at 10:57
Exactly such errors are very easy capture using: `use strict; use warnings;` You have a happy day, because is very common than nobody bother with questions what dosen't contains use strict and use warnings;. — kobame, Jun 03 '15 at 13:06

score 2 · Accepted Answer · edited Jun 03 '15 at 10:46

2

You have to push $cell->valuenot $value

push @line, $cell->value if defined($cell);

You should add use strict at the beginning of your program, so you get an error message in such a case.

edited Jun 03 '15 at 10:46

choroba

231,213
25
204
289

answered Jun 03 '15 at 10:44

Jens

67,715
15
98
113

sorry - typo, now fixed (however using push @line, $cell->value if defined($cell); also returns undef) – James Jiimmy Jun 03 '15 at 10:48
try changing `$value = $cell->value;` to `my $value = $cell->value;`. – Jens Jun 03 '15 at 10:51
@JamesJiimmy and when you do `push @line, \$value` ? – Jens Jun 03 '15 at 10:55

Spreadsheet::ParseExcel $cell->value() returning undef

1 Answers1