Here at perlmonks:

• Using Win32::OLE and Excel - Tips and Tricks

MSDN:

• Excel object model (you may need to poke around for your specific version of excel, but overall it hasn't evolved much that I've seen)

On your local hard drive:

• OLE-Browser - installed with perl, look in the ActiveState menu (if you're running ActiveState perl)
• Open Excel, hit Alt-F11 to open VBA environment, then hit F2 to view the Object Browser
• The Excel VB help file has the object model in detail. This helpfile is not installed by default, so you may need to rerun setup.

You'll also need curly brackets around properties, and method calls look the same as they do in straight perl:

	VB	Perl
Properties:	Selection.Hidden = True	$xls->Selection->{Hidden} = 1;
Methods:	Worksheets(1).Activate	$xls->Worksheets(1)->Activate;

A couple of things about Win32::OLE you may find helpful:

• Win32::OLE->Option( Warn => 3 ); 
  # or 2 or 4
  [download]

• # load all excel constants (I may have the library name wrong)
  use Win32::OLE::Const 'Microsoft Excel';
  [download]

• # make it a little easier to iterate over collections
  use Win32::OLE qw/IN WITH/;
  [download]

Update: Closed the list tag, added missing tr.

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.