http://www.perlmonks.org?node_id=1053820


in reply to Spreadsheet::XLSX Cell Access

Try:

my %yield;
my @mycols = ('F', 'G', 'H', 'I', 'J', 'K');
foreach (@mycols) {
    $yield{$_} = $sheet->{$_ . "35"};
}

[download]

Could also use $sheet->{"${_}35"} on the right hand side, its a stylistic preference there. The key is use a hash for the yield, use double-quotes when including a variable, and you need a way do distinguish $_ concatenated with 35 from the single variable $_35 (that's what the braces in "${_}35" are doing - telling perl that just _ is the variable not _35).

Good Day,
    Dean

In Section Seekers of Perl Wisdom