Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re: Alternative to Win32::OLE when using Excel?

by VSarkiss (Monsignor)
on Jan 17, 2006 at 15:54 UTC ( #523759=note: print w/ replies, xml ) Need Help??


in reply to Alternative to Win32::OLE when using Excel?

As Limbic~Region states, you've got a lot of different questions packed up in there.

As far as whether you would use Spreadsheet::WriteExcel or Win32::OLE, I had to choose a couple of years ago, and wrote about my experience here.


Comment on Re: Alternative to Win32::OLE when using Excel?
Re^2: Alternative to Win32::OLE when using Excel?
by Anonymous Monk on Jan 17, 2006 at 16:18 UTC
    Vsarkiss,
       Do you agree with the statements regarding creating Charts in the Spreadsheet module is experimental and they need to be created beforehand? If charts need to be created beforehand and all the other steps mentioned have to be followed then Win32::OLE is by far the only real option I have. Do you know how I can grab the process ID from the Excel object then when using the GetActiveObject method? If need be I might just go about "Ending the Process"es using the system function if I can't find another way of killing the Excel processes started. I'm open to other suggestions but right now I can't have these Excel.exes building up in Task Manager. Appreciate any help.

    Rob

    formatting added by jdporter

      rpike, why do you continue to post anonymously rather than logging in?
      And how can you not have realized by now the simple fact that post contents are HTML formatted?

      We're building the house of the future together.
        Could you please answer this then. Is there a place to change my password? I'll do a search but in the case I can't find anything could you answer this? I know you can click "remember me" but other people use this system and having such a password makes it hard to remember. Thanks.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://523759]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (12)
As of 2014-11-27 16:24 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My preferred Perl binaries come from:














    Results (186 votes), past polls