Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

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

by devbond (Novice)
on Sep 29, 2013 at 18:02 UTC ( #1056246=note: print w/replies, xml ) Need Help??


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

#!/usr/bin/perl use warnings; use Spreadsheet::WriteExcel; use Spreadsheet::ParseExcel; use Spreadsheet::ParseExcel::SaveParser; my $workbook; my @s; $Month=Sept; sub create_excel { $workbook = Spreadsheet::WriteExcel->new('FAISTATS_'."$Month".'.xls'); for ( $i=1;$i<=8;$i++) { $s[$i] = $workbook->add_worksheet( "cpzea0".$i."a0001" ) ; } $s[9] = $workbook->add_worksheet( "WEEKLY" ) ; $s[10] = $workbook->add_worksheet( "MONTHLY" ) ; } create_excel();
declaring workbook outside is not working

Replies are listed 'Best First'.
Re^7: Not able to create worksheets inside a subroutine
by poj (Prior) on Sep 29, 2013 at 18:24 UTC
    Try adding $workbook->close() as last statement.
    poj
Re^7: Not able to create worksheets inside a subroutine
by Anonymous Monk on Sep 29, 2013 at 18:18 UTC
    What does not work?

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1056246]
help
Chatterbox?
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (5)
As of 2017-05-01 02:49 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    I'm a fool:











    Results (544 votes). Check out past polls.