|Problems? Is your data what you think it is?|
Re^2: install cpan Win32::OLE on cygwin - t/3_ole.t ....... 1/58 OLE exception from "Microsoft Excel":by Anonymous Monk
|on Aug 02, 2013 at 10:15 UTC||Need Help??|
I have installed Win32::OLE with cpan notest install Win32::OLE.
That worked without a hitch.
I created a powershell script (try.ps1) that uses the add method:
powershell -file try.ps1displays an excel workbook with 1 worksheet when executed in the cygwin environment
So, unless powershell has security magic, scripts can do this, there is enough memory and disk space.
I created an equivalent perl script (try.pl):
The sleep statements makes what happens visible. Otherwise the script just finishes with the error message below.
perl -w try.pldisplays an empty workbook. There is no worksheet displayed.
The workbook closes when the script finishes and the following is displayed:
So it appears that Add has a problem in my environment.
I don't believe the message is disk space or memory related, there is heaps of both as I posted earlier in this conversation. And I would expect the poweshell script to have the same problem. But that script runs fine.
I inspected the cpan make compile output, which I noticed had many warnings. All the same but for the location:
It's only a warning. Could it lead to my problem?