Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

Re: Unexpected Excel TypeLib error

by Anonymous Monk
on Oct 12, 2015 at 08:19 UTC ( [id://1144490]=note: print w/replies, xml ) Need Help??


in reply to Unexpected Excel TypeLib error

Is is safe simply to remove this line (I have the same modules running in other versions of Excel)?

No.

That line is supposed to import excel constants, if it doesn't import the constants they won't be defined, and your program can't use them

But if your program doesn't actually use them ....

So its up to you :)

site:perlmonks.org No type library matching "Microsoft Excel"

Replies are listed 'Best First'.
Re^2: Unexpected Excel TypeLib error
by Anonymous Monk on Oct 12, 2015 at 08:29 UTC

    Constants are useless without an app (like excel), so use an ole instance to get the constants, the best way to get constants, direct quote from the docs/Win32::OLE::Const 

        use Win32::OLE;
    use Win32::OLE::Const;
    my $Excel = Win32::OLE->new('Excel.Application', 'Quit');
    my $xlcon = Win32::OLE::Const->Load($Excel);
    ... $xlcon->{xlMarkerStyleDot} ...

    [download]
[reply]
[d/l]

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://1144490]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others contemplating the Monastery: (7)
As of 2024-04-23 11:29 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found