Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re^2: install cpan Win32::OLE on cygwin - t/3_ole.t ....... 1/58 OLE exception from "Microsoft Excel":

by Anonymous Monk
on Aug 01, 2013 at 14:16 UTC ( [id://1047462]=note: print w/replies, xml ) Need Help??


in reply to Re: install cpan Win32::OLE on cygwin - t/3_ole.t ....... 1/58 OLE exception from "Microsoft Excel":
in thread install cpan Win32::OLE on cygwin - t/3_ole.t ....... 1/58 OLE exception from "Microsoft Excel":

To answer your questions:

What steps have you taken to verify that this error message reflects reality?

I think there is enoug disk and memory. Refer my previous answer.

I don't believe the message reflects reality. But I don't know why I would get a spurious message if the script deoes the right thing.

Re: What steps have you taken to remedy this error condition?

I googled the message and did not find a similar experience. The error is reported in different circumstances. Seems to indicate that others have been able to install Win32::OLE under cygwin.

I used Win32::OLE under XP, Excel 200? and cygwin. Installed without issues. So maybe there is something about Win 7 or Excel 2010

I tried the script in the debugger. I posted the Trace. I also checked variable values. They look normal, although I have no definitive idea what the values should be and the perl constructs used are beyond my expeience.

I have no idea how to progress this further.

Replies are listed 'Best First'.
Re^3: install cpan Win32::OLE on cygwin - t/3_ole.t ....... 1/58 OLE exception from "Microsoft Excel":
by Anonymous Monk on Aug 01, 2013 at 14:21 UTC
      I'll give that a go. But since the test verifies the creation of a workbook:
      >> 3_ole.t:130: my $Book = $Excel->Workbooks->Add;
      I thought it was an indication of a serious issue. But I agree, it pays to be optimistic!!

      The other branch in this conversation leads me to think that the message is spurious. Win 7 Excel 10 makes an issue out of documents that are attachments to emails. They need to be enabled before you can do something to them. Maybe the under Windows 7/Excel 2010 scripts need to tell the create operation that this is a trusted operation? I don't know how to do that, but I will investigate that too in 8 hours time.

        Interesting.   Microsoft has had its clock cleaned, very much in public places, several times about “security” issues ... and maybe we have some new issue here that the current set of pre-installation tests do not properly handle what Microsoft is up to today in this (your ...) environment.   If so, that will be an important and very-useful finding that will need to be promptly incorporated into the relevant CPAN scripts.

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others musing on the Monastery: (2)
As of 2024-03-19 06:57 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found