On Jun 6, 2012, at 11:06 PM, rbm wrote:
> On Jun 7, 12:16 am, jimsgib...@gmail.com (Jim Gibson) wrote:
>
> I am able to get the methods to return one worksheet or all the
> worksheets in my workbook but I am unable to find a solution to get
> either worksheet() or worksheets() to return just 2 of the worksheets.
>
>
> I've also tried
>
> for my $worksheet ( $workbook->worksheets()) {
>
> which apparently returns array of worksheet objects but I am unable to
> reference any of these individually e.g.
>
> $worksheet [3]
>
> so that I can exclude the worksheets I don't want.
>
What you want to do is save the array of worksheets:
my @worksheets = $workbook->worksheets();
Now you can access individual worksheets $worksheets[0], etc.
--
To unsubscribe, e-mail: beginners-unsubscr...@perl.org
For additional commands, e-mail: beginners-h...@perl.org
http://learn.perl.org/
