Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked

Re^3: Inserting copied rows in Excel using Win32::OLE

by guha (Priest)
on Aug 29, 2004 at 10:44 UTC ( #386716=note: print w/replies, xml ) Need Help??

in reply to Re^2: Inserting copied rows in Excel using Win32::OLE
in thread Inserting copied rows in Excel using Win32::OLE

Well as I see it, the real problem is that the Excel/Word/etc/etc object model is quite complex. Lots of objects, methods and properties to sling around. To my experience there are no shortcuts but to understand that model.

That isn't easily done of course, and you have to start somewhere and the tools you mentioned are the maps into this exciting world.

You will start the baby-talk, that is translate macros to Perl and get things done. Often you'll do this mechanically and perhaps not really understand what's going on. However as your path goes on, more problems to solve, you will gain more experience and at some time you will begin to "understand" the thinking behind the model and you will start to know where to look for methods and properties in this vast object forrest, you will see the light.

Now this is when the fun starts and the power is under your fingertips.

You asked for more information, there is one document in the Tutorials section, namely Brother cacharbe's famous Excel, Using Win32::OLE and Excel - Tips and Tricks, node that I recommend you to read and ponder.


  • Comment on Re^3: Inserting copied rows in Excel using Win32::OLE

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://386716]
[stevieb]: I don't know what you mean. I write the code in C/C++ that accesses the ICs per the datasheet, wrap it for Perl, then use them. My code ensures that the functions/methods from Perl do the right thing for the chips/sensors etc
[stevieb]: At least that's what I'm working on right now. I've also been updating my automated test software Test::BrewBuild so it handles this work properly. It's not really easy meshing high level languages with low-level hardware :)
[stevieb]: this link is probably better for an overview of my test software

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (5)
As of 2017-06-25 23:10 GMT
Find Nodes?
    Voting Booth?
    How many monitors do you use while coding?

    Results (572 votes). Check out past polls.