in reply to parsing excel sheet from a perl program

Wong Method call (Worksheet). The "worksheet(<name or number>)" method returns a single worksheet. "Worksheet" is a class name, not a method name.
Try: 
 for my $sheet ( $excel->worksheets() ) {
 ...

[download]
This will step through worksheets.

     Theory is when you know something, but it doesn't work.
    Practice is when something works, but you don't know why it works.
    Programmers combine Theory and Practice: Nothing works and they don't know why.         -Anonymous

Replies are listed 'Best First'.
Re^2: parsing excel sheet from a perl program
by rahulgsp83 (Novice) on Mar 09, 2010 at 14:09 UTC
    hi, thanks for all you replies ,the issue is solved now , regards, rahul
[reply]

      Duped, in essence, by Reaped: Re^3: parsing excel sheet from a perl program, which I created when server burped: I had clicked create on this, after reviewing; but got the Gates, not this page.
      This seems to have happened multiple times lately (20100309).

      That's great.

      Now, give back (or, more precisely) "give ahead" a little help... for the future reader with the same sort of problem: specify which of the above (if any) were useful in reaching your solution.

[reply]

In Section Seekers of Perl Wisdom