Google Groups Home
Help | Sign in
writeexcel->sheets() fails
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  2 messages - Collapse all
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
Anand  
View profile
 More options May 5, 7:35 pm
From: Anand <anand.acha...@gmail.com>
Date: Mon, 5 May 2008 16:35:16 -0700 (PDT)
Local: Mon, May 5 2008 7:35 pm
Subject: writeexcel->sheets() fails
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

Thanks,
Anand.


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
jmcnamara  
View profile
 More options May 5, 7:50 pm
From: jmcnamara <jmcnam...@cpan.org>
Date: Mon, 5 May 2008 16:50:54 -0700 (PDT)
Local: Mon, May 5 2008 7:50 pm
Subject: Re: writeexcel->sheets() fails

On May 6, 12:35 am, Anand <anand.acha...@gmail.com> wrote:

> I am trying to read an excel file usign the writeexcel.

Hi,

You are not off to a good start.

Spreadsheet::WriteExcel is a module for writing Excel files not
reading them. For that you need the Spreadsheet::ParseExcel module
(http://search.cpan.org/~szabgab/Spreadsheet-ParseExcel/) or to modify
an Excel file see the following:

http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel/lib/Spreadsh...

John.
--


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2008 Google