You won't find it in the Win32::OLE docs. I first learned it a long time ago writing Excel macros with VBA. The Excel help files and the object browser are your friends.

If you are using Excel automation regularly, you'll want to be familiar with Excel's object model. You can find help and diagrams in the help files, but the Programming help files are not installed by default.

Once you are familiar with the object model, use the Object Browser for quick lookups. If you don't already know where to find the object browser, open the VBA code window (I use Alt+F11) and then open the Object Browser using the View menu or just hit F2.

Another great place to learn is cacharbe's Using Win32::OLE and Excel - Tips and Tricks.

Good luck!

Update: And remember the macro recorder to help with syntax.

In reply to Re^3: merging cells in excel by bmann
in thread merging cells in excel by chuckdawit

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • 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! —
  • 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:
    & &amp;
    < &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.