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


in reply to variable in variables

The proper way to do this is to use a hash, not variable variable names:

use strict; use Spreadsheet::WriteExcel; my $workbook = Spreadsheet::WriteExcel->new("demo.xls"); my %worksheets; my @PEOPLE = ("BOB" , "SUE", "JOHN" ); for my $p (@PEOPLE) { $worksheets{$p} = $workbook->add_worksheet($p); $worksheets{$p}->write('A2', ucfirst(lc($p)) . ' is here'); }

Replies are listed 'Best First'.
Re^2: variable in variables
by ohgary (Initiate) on Apr 25, 2013 at 20:41 UTC
    Ok, that handles an initialization of the worksheet, but how do I do the worksheets writes outside of a for loop? An adhoc write to another element?

    As my example, How do I assign a "person" and then be able to do my write as my example showed?

      how do I do the worksheets writes outside of a for loop?
      Old:
      $NAME = "BOB"; $worksheet_$NAME->write('A2', "$NAME is here");
      New:
      $NAME = "BOB"; $worksheets{$NAME}->write('A2', "$NAME is here");

      BTW, as for why symbolic references should be avoided, see the classic three part series by MJD: part 1 and part 2 and part 3.