Re: Variable Value Confusion

You want a string compare, not a variable assignment.

if ( $sheet->{Cells}[$row][2]->{Val} = "SYSTEM" )  {
[download]

should probably be:

if ( $sheet->{Cells}[$row][2]->{Val} eq "SYSTEM" )  {
[download]

Comment on Re: Variable Value Confusion Select or Download Code

Replies are listed 'Best First'.
Re^2: Variable Value Confusion by finhagen (Sexton) on Mar 12, 2009 at 22:37 UTC
Toolic, Thank you for your advice. I tried the "eq" option but that didn't address my problem. What I did do that kind of worked was add a new foreach statment: `foreach my $row ($sheet->{MinRow}+18..$sheet->{MaxRow}){ if ($sheet->{Cells}[$row][2]->{Val} eq "SYSTEM") {$comment = $shee +t->{Cells}[$row-2][2]->{Val};} }` [download] However, the net result was the script ran down to the last SYSTEM in the spreadsheet and returned the $comment value above it. I made the mistake of posing a similar issue related to the script as Iterative Subroutine Approach Question posting. To avoid further confusion I am going to pick this question up there and close out this posting. Thanks again for your assistance! Hagen Finley Boulder, CO	[reply] [d/l]

Replies are listed 'Best First'.

Re^2: Variable Value Confusion
by finhagen (Sexton) on Mar 12, 2009 at 22:37 UTC

foreach my $row ($sheet->{MinRow}+18..$sheet->{MaxRow}){

    if ($sheet->{Cells}[$row][2]->{Val} eq "SYSTEM") {$comment = $shee
+t->{Cells}[$row-2][2]->{Val};}
}
[download]

Hagen Finley

Boulder, CO

[reply]
[d/l]