Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

Re: Using Win32::OLE and Excel - Tips and Tricks

by Discipulus (Curate)
on Aug 20, 2003 at 08:08 UTC ( #285128=note: print w/ replies, xml ) Need Help??


in reply to Using Win32::OLE and Excel - Tips and Tricks

thanks for this tutorial but I needed to your line

my $Sheet = $Book->Worksheets("Sheet1"); #in this way to make it run my $Sheet = $Book->Worksheets(1);
or I get this error:

Win32::OLE(0.1601) error 0x8002000b: "Indice non valido" in METHOD/PROPERTYGET "Worksheets" at C:\prova\OLEexcel.pl line 20

why ??
thanks 4theTuT Lor*


Comment on Re: Using Win32::OLE and Excel - Tips and Tricks
Download Code
Re: Re: Using Win32::OLE and Excel - Tips and Tricks
by guha (Priest) on Aug 21, 2003 at 13:12 UTC

    Looks to me like you are using an italian?? version of Excel, where I would guess that "Sheet1" is named "Foglio1" or some such.

    Accessing the sheet through index ie "1" in your example works, because you avoid the language differences

    HTH

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (9)
As of 2014-08-23 15:32 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (174 votes), past polls