in reply to Not able to create worksheets inside a subroutine

devbond:

A couple notes:

...roboticus

When your only tool is a hammer, all problems look like your thumb.

Replies are listed 'Best First'.
Re^2: Not able to create worksheets inside a subroutine
by devbond (Novice) on Sep 29, 2013 at 15:53 UTC
    i made the following modifications but still no change in the output :(

    #!/usr/bin/perl

    use warnings;

use Spreadsheet::WriteExcel;

use Spreadsheet::ParseExcel;

use Spreadsheet::ParseExcel::SaveParser;

$Month=Sept;
my @s;
sub create {
$workbook = Spreadsheet::WriteExcel->new('FAISTATS_'.'$Month'.'xls');

for $i(1..8) {

$s[$i] = $workbook->add_worksheet( "rpzea0".$i."a001" ) ;

} }
create();

    [download]
[reply]
[d/l]

      Please add use strict; at the beginning and correct all errors that will be thrown. Also, the single quotes around $Month will prevent that you get the correct month. You also lack a dot in front of the extension xls.

[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom