Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

Comment on

( #3333=superdoc: print w/ replies, xml ) Need Help??

The ways of doing this in Perl are pretty much identical to that of any other language, since the underlying subsystem is OLE.   You can directly reference any sheet in the workbook without affecting the user-interface (e.g. by activating or opening the sheet), and you probably don’t want to except to “put on an I’m Busy Show” for the end-user.   You can reference the elements in any Collection (such as Sheets either by index or by name.   Again, the principles and modus operandi are the same everywhere.   Learn how to do it first (say, in Excel’s own built-in VB/macro facility), then translate the known-good methods into Perl-talk.

Incidentally, I am of the opinion that “when in Rome, do as the Romans do.”   In the Windows environment, that’s OLE.   It works, and it works quite well.   Much better, IMHO, than trying to build a file.


In reply to Re: Creating desired number of worksheets in excel by sundialsvc4
in thread Creating desired number of worksheets in excel by talnewtoperl

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!
  • 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, 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, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • Outside of code tags, you may need to use entities for some characters:
            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.
  • Log In?
    Username:
    Password:

    What's my password?
    Create A New User
    Chatterbox?
    and the web crawler heard nothing...

    How do I use this? | Other CB clients
    Other Users?
    Others chanting in the Monastery: (7)
    As of 2014-07-31 22:41 GMT
    Sections?
    Information?
    Find Nodes?
    Leftovers?
      Voting Booth?

      My favorite superfluous repetitious redundant duplicative phrase is:









      Results (254 votes), past polls