Win32::OLE ?

perchance has asked for the wisdom of the Perl Monks concerning the following question:

Good Morning Monks,
I hope this is a Perl question and will not turn out to be an ActiveState issue.
I need to create an Excel chart in a script, and looking through this site I found Win32::OLE which seemed an excellent choice, and I found all the documentation I needed through Win32::OLE.
However, when I wanted to actually put this all to use, I found the ppm (Perl Package Manager) had no access to the appropriate files, even though the on-site documentation said it should, and no ppd file present.

Does anybody know if Win32::OLE is being phased out or something? (Or phased in? ;0)
If so, what is replacing it? (I need something in ppd format for out installation people)
What modules have you found useful for OLE?
I am using perl version 5.005_02, ppm version 0.9.5.

Your inputs welcome, (sorry for being so Windozish so early in the morning...)
perchance

--- The One I Love

Comment on Win32::OLE ?

Replies are listed 'Best First'.
Re: Win32::OLE ? by MZSanford (Curate) on Jul 22, 2001 at 11:57 UTC
If you are doing this work to create/parse Excel files specifically, i have found the Spreadsheet::ParseExcel and Spreadsheet::WriteExcel modules to be far more stable, and to work wonderfully with the exception of lacking graph support (which i do not expect to see any time soon from them.). So, if this is just spreadsheet data, i would give them a look, they have a solid interface and are very stable. remeber the immortal word's of Socrates who said, "I drank what ?"	[reply]
Re: Win32::OLE ? by John M. Dlugosz (Monsignor) on Jul 22, 2001 at 10:40 UTC
It comes standard with ActiveState Perl, so you don't need to use PPM to grab it. If you don't have it on your machine, try re-installing. Current is Perl 5.6.1, AS build 628. OLE has had many fixes; upgrade!!! —John	[reply]
Re: Re: Win32::OLE ? by perchance (Monk) on Jul 23, 2001 at 15:39 UTC
Oops! Don't I feel sheepish :-) Do you happen to know where I can find a list of what they bundle in their install? (I tried looking through the online docs, but to no avail). Do you know if there exist ppd files for Win32::OLE nontheless? It's just a big hassle moving the whole company to an upgraded version of Perl, I mean, it will happen, but it'll take time. This way I could upgrade only the relevant package for my current needs. Thanks a mil', perchance	[reply]
Re: Re: Re: Win32::OLE ? by John M. Dlugosz (Monsignor) on Jul 23, 2001 at 17:33 UTC
No, just see what's there. Try the main win32lib PPD--I think that may contain it. Or, install the new distribution on a scratch machine and then copy the files you need.	[reply]