Your skill will accomplish what the force of many cannot |
|
PerlMonks |
Re: Using win32::ole on Excelby VSarkiss (Monsignor) |
on Oct 27, 2002 at 23:44 UTC ( [id://208408]=note: print w/replies, xml ) | Need Help?? |
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
In Section
Seekers of Perl Wisdom
|
|