I agree with you. It's great to try your hand at things to find other ways of doing everyday tasks. Perl is perfect for this sort of thing

Have a look at this node for information on the OLE browser. I posted this question because I had a vague idea about what OLE did but didn't know how the browser could help me. In the end, I used I couldn't have written the above code without it. For some reason the OLE browser didn't work on my PC - it turns out that I needed to make a change to the registry. Thanks Zoogie!

My understanding(from my imagination) of OLE is that most (not all) Win32 apps provide sort of external hooks. You can create an OLE object (it becomes an application server) with one of those applications and access those hooks from your Perl script. So in theory you can do whatever the application itself does (assuming that the author provided all the hooks.)

I have since written a Win32 script that uses OLE to "access" an Access database and pull out records etc.

While it's all quite fun, it means that your code isn't very portable though - you can only run it on Win32 (and maybe soon Mac?). So if there is a module out there that does the job I would stick to that.

UPDATE: I think maybe I put too many '()' in this reply. Maybe it's unreadable. Sorry.

In reply to RE: RE: Re: Creating Excel Spreadsheet from text data file by $code or die
in thread Creating Excel Spreadsheet from text data file by zzspectrez

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.