in reply to Using win32::ole on Excel

Win32::OLE is a strange beast, as you've found. I'd recommend two writeups, in case you haven't seen them yet. The first is cacharbe's tutorial called Using Win32::OLE and Excel - Tips and Tricks, and the other is the writeups on http://www.roth.net. Sounds like you may have found them already, but if not, take a look for some invaluable info.

One thing I've noticed is that I sometimes have to explicitly call the Value method when setting values. That is, instead of $Chart->{ChartType} = "xlLineMarkers";try using:$Chart->{ChartType}{Value} = "xlLineMarkers";I'm not sure if that's the problem -- in other words, this is a shot in the dark -- but it's worked for me under random circumstances in the past. As far as I've been able to tell, there's no rhyme or reason about when it's needed. (There probably is, I just haven't been able to figure it out....)

HTH

Update
Fixed typo in link to cacharbe's tutorial.

Replies are listed 'Best First'.
Re: Re: Using win32::ole on Excel
by Anonymous Monk on Oct 28, 2002 at 00:20 UTC

    hi,

    Thanks for the reply, I have try it but it didnt work for my case.

    There are some typing errors in the original post:

    I ve put all this in the perl program but it has no effect, the chart always diplay as bar charts, and I CANT use perl to delete and data set in it.

    Also If I insert the data first and create chart, as I CANT remove the data set, it alwasy give me the wrong data set in chart.

    So bassicaly I cant do anything with excel other than insert data and create chart.

    Thanks

[reply]

In Section Seekers of Perl Wisdom