On Jun 7, 3:56 pm, jimsgib...@gmail.com (Jim Gibson) wrote:
> 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.cooool :) thank you! -- To unsubscribe, e-mail: beginners-unsubscr...@perl.org For additional commands, e-mail: beginners-h...@perl.org http://learn.perl.org/
