Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister

Re: Perl & Win32

by gellyfish (Monsignor)
on Mar 18, 2005 at 11:33 UTC ( #440674=note: print w/replies, xml ) Need Help??

in reply to Exporting an Excel Chart to PNG using Win32::OLE

This is possibly not really a Perl problem at all - as you can see - it appears to be a problem with the regional settings in Excel as described in these articles at MSDN.

Update: It is likely that Re: Perl & Win32 is the actual reason behind this - the error number seems to be some generic Excel automation error.


Replies are listed 'Best First'.
Re^2: Perl & Win32
by bart (Canon) on Mar 18, 2005 at 11:43 UTC
    The "Perl problem" is, IMO, turning these obscure Win32::OLE error messages into something far more informative.
      It would be difficult since errors of this kind are tunneled directly from the OLE engine. It's OLE's cryptic messages that should be fixed - then Win32::OLE will be fine.

        Worse than that, judicious grepping of all of the Windows include files would suggest that this value is not even known to the OLE subsystem but comes from the Application, so without some gigantic registry of the possible HRESULT from every possible automation component you are always going to have this problem.


        I figure that there must be a way to ask the system, though OLE, what these cryptic error messages mean, something similar to the API call GetLastError() and the libwin32 functions Win32::GetLastError() and Win32::FormatMessage(). In that case, I think it's reasonable to ask Win32::OLE to handle the necessary paperwork for us.

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (2)
As of 2022-01-18 01:18 GMT
Find Nodes?
    Voting Booth?
    In 2022, my preferred method to securely store passwords is:

    Results (52 votes). Check out past polls.