Re: Finding out Excel 'variables'

See also Save Excel worksheets as PDF with regard to "Excel constants."

West Wind Technology's GetConstants utility is another option. (Note that they do shuffle the links around occasionally, so it may be necessary to do some searching.)

I think what you are really looking for, however, is more along the lines of the "Object (Model) Browser", some variation of which you may already have on your machine called "OLE Browser" or "Type Library Browser", if you installed Win32-OLE-0.1403 or upgraded from that to a later version. You might find it in C:\Perl\html\OLE-Browser or C:\Perl\html\lib\site\Win32\OLE depending on your install.

You may also wish to have a look at Dr. Steven Roman's Object Model Browser Version 2.

HTH,

planetscape

Comment on Re: Finding out Excel 'variables' Select or Download Code

Replies are listed 'Best First'.
Re^2: Finding out Excel 'variables' by davies (Monsignor) on Jan 18, 2011 at 15:51 UTC
If MerryMonk is after the built-in constants, my reply is barking up the wrong tree. The code to get them is available from the ActiveState site, but I reproduce it here: `use strict; use Win32::OLE; use Win32::OLE::Const; my $xl = Win32::OLE::Const->Load("Microsoft Excel"); printf "Excel type library contains %d constants:\n", scalar keys %$xl +; foreach my $Key (sort keys %$xl) { print "$Key = $xl->{$Key}\n"; }` [download] Regards, John	[reply] [d/l]

Replies are listed 'Best First'.

Re^2: Finding out Excel 'variables'
by davies (Monsignor) on Jan 18, 2011 at 15:51 UTC

If MerryMonk is after the built-in constants, my reply is barking up the wrong tree. The code to get them is available from the ActiveState site, but I reproduce it here:

use strict;
use Win32::OLE;
use Win32::OLE::Const;

my $xl = Win32::OLE::Const->Load("Microsoft Excel");
printf "Excel type library contains %d constants:\n", scalar keys %$xl
+;
foreach my $Key (sort keys %$xl) {
    print "$Key = $xl->{$Key}\n";
}
[download]

Regards,

John

[reply]
[d/l]