Re: Spread***::WriteExcel new($var) not working

On May 20, 3:12 pm, Mick <karanarora...@xxxxxxxxx> wrote:
On May 20, 3:10 pm, Mick <karanarora...@xxxxxxxxx> wrote:



Hi

I am trying to use the perl module Spread***::WriteExcel to create a
new XLS file and write into it, however in my case the name of the xls
file has to be entered by the user and it can not be fixed. So to
achieve this write something like this in my code where $XLSPath is
entered by the user before this line.

#46 my $xlsReport = Spread***::WriteExcel->new($xlsFileName);

However, I get the error
---
Can't call method "add_work***" on an undefined value at line 96 in
c:\report-xls.pl which is
---

#95 # Create new Work*** in the workbook
#96 $work*** = $xlsReport->add_work***();

I reckon this means that the variable $xlsReport is undefined which
may be because of some error in line 46. I have seen the examples and
previous question threads and do not find any example in which the
name of the file is a variable. Please help!!

Regards

Mick

Extremely sorry, please read $XLSPath as $xlsFileName in the first
para.

Hi!

I figured out the problem after a long tussle. There was some problem
with the scope of variable definition. I can now certainly say that
statements like

my $xlsReport = Spread***::WriteExcel->new($xlsFileName)

work.

MCK
.