Re^3: Perl Excel OLE help


Keep It Simple, Stupid
	PerlMonks

Re^3: Perl Excel OLE help

by chinman (Monk)

on Jan 06, 2010 at 23:42 UTC ( [id://816004]=note: print w/replies, xml )

Need Help??

in reply to Re^2: Perl Excel OLE help
in thread Perl Excel OLE help

Hi MM,

You cannot access the sheet by name this way, because Excel is expecting the sheet index and not the name. You need to use the sheet index for 'Position', thusly:

my $Sheet = $Book->Worksheets(8);

Regards,
chinman

Comment on Re^3: Perl Excel OLE help Download Code

Replies are listed 'Best First'.
Re^4: Perl Excel OLE help by mmittiga17 (Scribe) on Jan 06, 2010 at 23:53 UTC
`Hi even when I do my $Sheet = $Book->Worksheets(8); It fails to work, I get same error` [download]	[reply] [d/l]

In Section Seekers of Perl Wisdom

Domain Nodelet^?

www.com | www.net | www.org

Node Status^?

node history
Node Type: note [id://816004]
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others studying the Monastery: (2)

As of 2026-03-12 02:14 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

No recent polls found

Notices^?

	• hippo	‥ epoptai's answer Re: how do I set a cookie and redirect was blessed by hippo!
	• erzuuli	‥ Anonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.