WriteExcel->sheets() fails to get the worksheets

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
I am trying to read an excel file usign the writeexcel. Following is
the code-snippet:
     my $workbook = Spreadsheet::WriteExcel->new('Temp.xls');

    print "Cannot create Temp.xls: $!\n" if (not defined $workbook);

    foreach $worksheet ($workbook->sheets()) {
       print "Worksheet Name is: ".$worksheet->get_name()."\n";

The file Temp.xls is already existing in the directory. I want to
further modify the worksheets. However, the sheets() method itself is
not working.
What might be the reason? I'm using perl 5.8


Re: WriteExcel->sheets() fails to get the worksheets

On Mon, 05 May 2008 16:58:48 -0700, Jim Gibson wrote:

Quoted text here. Click to load it

The obvious solution is to use Win32::OLE to do everything. I'd only use
the Perl Excel reading / writing modules if I had to do something with an
Excel spreadsheet on Unix.

Site Timeline