Re: Spreadsheet::XLSX Cell Access


Perl: the Markov chain saw
	PerlMonks

Re: Spreadsheet::XLSX Cell Access

by duelafn (Parson)

on Sep 13, 2013 at 01:12 UTC ( [id://1053820]=note: print w/replies, xml )

Need Help??

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