Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Re: Problem enumerating Worksheets with Spreadsheet::ParseExcel

by jmcnamara (Monsignor)
on Dec 17, 2001 at 22:34 UTC ( [id://132601]=note: print w/replies, xml ) Need Help??


in reply to Problem enumerating Worksheets with Spreadsheet::ParseExcel


I get the opposite results. The uncommented loop works and the commented loop gives a warning.

The warning occurs because SheetCount is the index of the last worksheets +1. So I guess this is what you want (although I prefer the other method):

foreach (0 .. $book->{SheetCount} -1) { $sheet = $book->{Worksheet}[$_]; print $sheet->{Name},"\n"; }

--
John.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://132601]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others having a coffee break in the Monastery: (3)
As of 2024-04-16 04:07 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found