Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number

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

by Discipulus (Abbot)
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\ line 20

why ??
thanks 4theTuT Lor*

Replies are listed 'Best First'.
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


Log In?

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

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (2)
As of 2021-10-19 22:51 GMT
Find Nodes?
    Voting Booth?
    My first memorable Perl project was:

    Results (77 votes). Check out past polls.