Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Re: Using win32::ole on Excel

by VSarkiss (Monsignor)
on Oct 27, 2002 at 23:44 UTC ( [id://208408]=note: print w/replies, xml ) Need Help??


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

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others rifling through the Monastery: (5)
As of 2024-03-28 22:24 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found