Re: Spreadsheet::XLSX Cell Access

[runrig]

Obligatory link: http://perl.plover.com/varvarname.html.

Use a hash:

my %yield;

$yield{$_} = $sheet->{"${_}35"} for "F".."K";
#or
$yield{$_} = $sheet->{ $_ . 35 } for "F".."K";

[Hammer2001]

Runrig et el, thanks for your quick replies.

Runrig, how do declare an array of hashes? In your snippet "my %yield;" will only declare a single hash whereas I need 6 of them.

I can testify that

my %pond$_ for "F".."K";

does not work.

Thanks,

Hamid

[Hammer2001]

Runrig et el, thanks for your quick responses. Runrig, how do I declare an array/series of hashes? In your snippet "my %yield;" will only declare a single hash whereas I need 6 of them.

I can testify that

my %pond$_ for "F".."K";

does not work.

Thanks,

Hamid

PS. Sorry for erroneously starting a new thread.

[Laurent_R]

An array of hashes is declared as a simple array:

my @pond;

Then to use it, one possible way is this:

$pond[$i]{$_} = 'foo';

But from what you have shown, you only need a single hash as follows:

$yield{$_} = 'bar';

Read the link that has been provided to you in an earler post.