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


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();

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.