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

Replies are listed 'Best First'.
Re^3: Not able to create worksheets inside a subroutine by hdb (Monsignor) on Sep 29, 2013 at 16:04 UTC
No, removing `my` is not the way to go at all. Always `use strict;`, clear away all errors and then see what happens.	[reply] [d/l] [select]
Re^4: Not able to create worksheets inside a subroutine by devbond (Novice) on Sep 29, 2013 at 16:53 UTC
I cant declare workbook as my as i need to use it in other subs too	[reply]
Re^5: Not able to create worksheets inside a subroutine by hdb (Monsignor) on Sep 29, 2013 at 17:42 UTC
Then, at least, declare it as a globel variable, ie outside of all subs. Or, better, pass it as a parameter into the subs, that need it.	[reply]
Re^6: Not able to create worksheets inside a subroutine by devbond (Novice) on Sep 29, 2013 at 18:02 UTC
Re^7: Not able to create worksheets inside a subroutine by poj (Abbot) on Sep 29, 2013 at 18:24 UTC
Re^7: Not able to create worksheets inside a subroutine by Anonymous Monk on Sep 29, 2013 at 18:18 UTC
Re^3: Not able to create worksheets inside a subroutine by ig (Vicar) on Sep 30, 2013 at 07:15 UTC
Spreadsheet::WriteExcel tries to close your workbook automatically but sometimes has problems "If the new(), add_worksheet() or add_format() methods are called in subroutines." You can read the section on the close() method for more detail on limitations of automatic closing.	[reply]