Change "'$_35'" to "$_ . 35".

Also, I've got no idea what you're trying achieve with "$yield$_ = ...".

You should probably read perlintro before proceeding.

Here's a very rough guess at what you might need:

$ perl -Mstrict -Mwarnings -e '
    my $sheet = {F35 => 1, G35 => 2, H35 => 3, I35 => 4, J35 => 5, K35
+ => 6};
    my @mycols = "F" .. "K";
    my @cells;
    for (@mycols) {
        push @cells, $sheet->{$_ . 35};
    }
    print "@cells\n";
'
1 2 3 4 5 6
[download]