|Don't ask to ask, just ask|
Using win32::ole on Excelby Anonymous Monk
|on Oct 27, 2002 at 23:13 UTC||Need Help??|
Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:
Hi Perl Monks,
I am new to perl and I am trying use perl to automate the process of executing a program, process the the result and present the data in Excel. I ve followed the samples in your site and some other resources, but the win32::ole function didnt work very well with excel in my case:
I can create a workbook, insert data and create a new chart with perl in excel, however, I cannot change the chart type, set the tile, axis title or run a macro.
I use the following code to
I ve put all this in the perl program but it has no effect, the chart always diplay as bar charts, and I can use perl to delete and data set in it.
Also If I insert the data first and create chart, as I can remove the data set, it alwasy give me the wrong data set in chart.
what's wrong with the code, I really dont know, are there any setting that I need to set on excel to use this function?
It is a kinda urgent one :(, I would appriciate if anyone could give me some advice.