Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Re: variable in variables

by moritz (Cardinal)
on Apr 25, 2013 at 17:27 UTC ( #1030708=note: print w/ replies, xml ) Need Help??


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'); }


Comment on Re: variable in variables
Download Code
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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1030708]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (9)
As of 2014-07-28 16:49 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite superfluous repetitious redundant duplicative phrase is:









    Results (204 votes), past polls