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

Re: Does Win32::OLE::Const->Load('Microsoft Excel'); depends upon Excel version

by syphilis (Bishop)
on Mar 19, 2020 at 23:39 UTC ( #11114493=note: print w/replies, xml ) Need Help??


in reply to Does Win32::OLE::Const->Load('Microsoft Excel'); depends upon Excel version

Hi agnes00,

The example in the Win32::OLE documentation seems to be trying to load Excel as:
$xl = Win32::OLE->new('Excel.Application') or die "oops\n";
You could try that and see if it makes a difference.

Did the test suite pass when you installed Win32::OLE ?
If you installed it via ppm, then you won't have run the test suite.
In that case grab the Win32::OLE source, unpack it to some location, cd to that location, and run:
perl t/2_variant.t perl t/3_ole.t
Let us know if they both pass. Please provide a copy'n'paste of the results if there are failures.
(Those 2 test files seem to rely on the loadability of Excel, and are therefore relevant to your issue.)

Other than that, try looking through the Win32:OLE bug reports and see if there's anything there that helps.
Nothing there stands out to me, though 67609 might perhaps be relevant.

I don't know much about Win32::OLE - I don't have it, nor do I have Excel. And I doubt that Win32::OLE is being actively maintained. (The current version on CPAN is 6 years old.)

There's also a number of modules that have been written for Excel. Perhaps one of them might better suit your purposes - I don't know.
You can see a list of those modules at https://metacpan.org/search?q=Excel.

Cheers,
Rob

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (5)
As of 2020-05-28 06:34 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    If programming languages were movie genres, Perl would be:















    Results (165 votes). Check out past polls.

    Notices?