http://www.perlmonks.org?node_id=523759


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.

Do not rebuke them with harsh words ... but rather lead them gently - with URLs - so that they may learn wisdom.

  • Comment on Re: Alternative to Win32::OLE when using Excel?

Replies are listed 'Best First'.
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

[reply]

      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.
[reply]
        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.
[reply]

In Section Seekers of Perl Wisdom