in reply to Help using Win32::OLE to add Excel charts having multiple series

That doesn't look like perl code, or code you have written.
  • Comment on Re: Help using Win32::OLE to add Excel charts having multiple series

Replies are listed 'Best First'.
Re^2: Help using Win32::OLE to add Excel charts having multiple series
by Anonymous Monk on Feb 23, 2010 at 06:40 UTC
    It is just a Visual basic pseudo code. Please help in writing Win32::OLE perl code to plot the excel chart, that takes the range of a column dynamically
[reply]
[reply]
      Um, no. Please ask a clear and coherent actual question, then you can get help in writing, as opposed to someone just writing something for you (and guessing and guessing).
[reply]
         How to translate following VBA code to perl code 

 Charts.Add
 ActiveChart.ChartType = xlXYScatterSmoothNoMarkers
 ActiveChart.SeriesCollection.NewSeries
 ActiveChart.SeriesCollection(1).XValues = "='Sheet1'!R2C1:R801C1"
 ActiveChart.SeriesCollection(1).Values = "='Sheet1'!R2C2:R801C2"

        [download]
[reply]
[d/l]

In Section Seekers of Perl Wisdom