Re^2: Not able to create worksheets inside a subroutine

in reply to Re: Not able to create worksheets inside a subroutine
in thread Not able to create worksheets inside a subroutine

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]

Comment on Re^2: Not able to create worksheets inside a subroutine Download Code

Replies are listed 'Best First'.
Re^3: Not able to create worksheets inside a subroutine by hdb (Monsignor) on Sep 29, 2013 at 15:59 UTC
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