"It's been awhile since I went down this road but doesn't is still show up in the task bar?": not in any Excel / OS combination I've used. The only way to see it is in the task manager, and then I've always had to look in processes rather than applications.

"the other risk of using Win32::OLE is that you have available both read and write capabilities for the file": if you are creating a file that you want to be read only, you can set the OS option accordingly at creation time & Excel will respect it. That applies even if you create the file using Excel.

I'm not trying to suggest that there aren't advantages to doing it your way in some - perhaps many - situations. But when I hack Excel, I'm usually doing something fairly technical that the WriteExcel module & its cousins can't do. So I'm always using Win32::OLE anyway (unless I'm writing directly in VBA) & therefore I'm more familiar with avoiding its dangers than with using other modules.

Regards,

John Davies

In reply to Re^4: How to operate on multiple Excel worksheets with variable array by davies
in thread How to operate on multiple Excel worksheets with variable array by bill5262

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.