Writing Excel file is "easiest" done using Excel::Writer::XLSX.

If you want to talk to the Office programs, there is little difference between doing that from Perl or doing that from within VBA, but VBA has the far superior IDE with autocompletion for doing OLE. Personally, I recommend using the macro recorder to record a VBA script that does most of your task and then rewriting the VBA either in Perl or Visual Basic to do all of your task. The macro recorder removes much of the need to learn the Office API before you start. See also Using Win32::OLE and Excel - Tips and Tricks, which applies to most of the Office Suite not only Excel.

In reply to Re: need advise on how to tackle an automation program using perl. by Corion
in thread need advise on how to tackle an automation program using perl. by perlynewby

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.