Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

WriteExcel->sheets() fails in getting worksheets

0 views
Skip to first unread message

Anand

unread,
May 5, 2008, 7:38:22 PM5/5/08
to
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. There are four
distinct worksheets in the workbook. 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

Thanks,
Anand.

Jim Gibson

unread,
May 5, 2008, 8:04:27 PM5/5/08
to
In article
<466d8e4a-5f23-48a2...@u36g2000prf.googlegroups.com>,
Anand <anand....@gmail.com> wrote:

> I am trying to read an excel file usign the writeexcel. Following is
> the code-snippet:

You asked the same question two minutes ago in comp.lang.perl.misc.
Please do not post the same question independently to more than one
newsgroup. If you must, cross-post your question to multiple
newsgroups, but do it simultaneously. If you can't figure out how to do
that using Google Groups, find a decent news reader and provider.

Thanks.

--
Jim Gibson

Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
http://www.usenet.com

0 new messages