Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical

Re: Creating desired number of worksheets in excel

by sundialsvc4 (Abbot)
on Sep 11, 2013 at 12:10 UTC ( #1053480=note: print w/replies, xml ) Need Help??

in reply to Creating desired number of worksheets in excel

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.

  • Comment on Re: Creating desired number of worksheets in excel

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1053480]
[Discipulus]: but i'm also animalist, so i' hirted by 1nickt's sig: The way forward always starts with a mammal test... grin..
[erix]: I might if I did remember. It's probably somewhere in the site docs
[uhClem]: I don't favor that sort of thing around here but the place for our politics is wherever we live.
[uhClem]: And besides, the objection to it was off-topic.
[Discipulus]: 1nickt hide signature is a positive action; i think is not a solution here
[erix]: my objection to sigs is just that they take screen space. ( Some monks would have *several* slogans underneath a 1-liner reply )

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (11)
As of 2017-06-22 12:36 GMT
Find Nodes?
    Voting Booth?
    How many monitors do you use while coding?

    Results (519 votes). Check out past polls.