in reply to Re: Spreadsheet::XLSX Cell Access
in thread Spreadsheet::XLSX Cell Access

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

Replies are listed 'Best First'.
Re^3: Spreadsheet::XLSX Cell Access
by Hammer2001 (Novice) on Sep 13, 2013 at 00:27 UTC

    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.

      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.