Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
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


Comment on Re^6: Not able to create worksheets inside a subroutine
Download Code
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?
Re^7: Not able to create worksheets inside a subroutine
by poj (Priest) on Sep 29, 2013 at 18:24 UTC
    Try adding $workbook->close() as last statement.
    poj

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (6)
As of 2014-09-02 22:35 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite cookbook is:










    Results (32 votes), past polls