Perl Monk, Perl Meditation | |
PerlMonks |
Re: Does Win32::OLE::Const->Load('Microsoft Excel'); depends upon Excel versionby syphilis (Archbishop) |
on Mar 19, 2020 at 23:39 UTC ( [id://11114493]=note: print w/replies, xml ) | Need Help?? |
Hi agnes00,
The example in the Win32::OLE documentation seems to be trying to load Excel as: 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: 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
In Section
Seekers of Perl Wisdom
|
|